I have two dates. I must create one query which result is one column with
records with dates between two known dates. How to do this? Is there anyone,
who can help?
thx

I'm trying to perform a two-table SELECT where each table has a column
named 'stock_num'.  One of the tables, however, isn't necessarily
going to have row's for a given stock_num (it might or might not).  To
get around this, I do a LEFT JOIN.  Or atleast I'm trying to do one.

I recently started working on system that has Sybase ASE 12.5 running.
I am not a DBA by training or experience but I need to do a bit of
research on the database.
I can see what objects are in the database and look at the table

I am trying to write some C code that uses two phase commit (2PC) in
conjunction with a third-party lib that is XA-compliant. Everything
works until I get to the bit where one of my db logins wants to
prepare the transaction. The code is simply:

I got the following exception when executing the create subscription
command, I received: "P_Table_def doesn't exist" My subscription looks
like:
isql -Urepsys -Prepsys_pas -SERATO62_RS

I am trying to update the record being inserted using a trigger, but
sybase doesn't seem to allow it, Can anyone suggest an alternative
here is what i am trying to do
create trigger tr1 on xyz for insert as

Hi,
I saw it isn't possible to download the ASE 12.5.3 Developer Edition from
Sybase anymore. How much trouble am I in for when I develop on 15.x
instead and deploy on 12.5.3 (client still uses that... and 11.9, but I

How to create procedure which carries out the operator втавить one
second, then does{makes} a delay for one second then too most?
Thank you!!!

Hello, is there anyway to do the equivalent of Set Replication Off
while doing a BCP-in?
Thanks,

I'm new with sybase, i need to export if possible tables in my sybase db to
a mdb file. I need to do this using directly sql. There's a syntax to do
this?
And more,

what tools are available to check that a sybase interfaces file is ok
please? The project I am on is using a third-party component that is
reporting errors into the syslog about the sybase interface being bad.
The report is extremely sparse on detail. The name of the interface

I'm using Adaptive Server 12.5 and have a couple of problems with
formatting the output of SQL SELECT queries for use in further
analysis. The general issue is that it's so inflexible in its output
formatting - there seems to be no format that doesn't include lots of

I'm having a problem getting query results from sybtcl compiled on a
Solaris 8 server
with Tcl 8.4 (from sunfreeware), gcc 3.3.2 and Sybase ASE 12.5.4. It
works with

Hi, I try to execute this query "select number(*) as lp from AAA where lp <= 20". The answer is "Illegal usage of the number(*) function". What should I do to limit the result to 20 records?
PS. AAA is table which has more records than 20....
thx

Is there anywhere in the system catalogues (or elsewhere) that you can
look to see if a stored procedure parameter declaration has a default
parameter value specified.  I don't need to know what the default is
(though that might be useful too) just want to know if the parameter