In a response of a query, I would like to select rows from the first
row to the 10th row.
And then later, I would like to select rows from the 11st row to 20th
row.....And so on.

Is there a way to tell a table's been altered?  sysobjects.crdate doesn't
change and there seem to be no date fields in syscolumns.  Is there someplace
else to look?

regarding this function...
dateadd(YY, 2, '2005-01-01')
what datatype is YY
i want to have a temp table looking something like this...

All - have setup Replicator as per the manual --- am receiving the
following message when running 'aserep.bat'
ASE Replicator requesting Java Virtual Machine exit with message: ASE
Replicator initialization error in component <DDBAdmin>. Component

I have been trying to set up a stored procedure that sends an e-mail.  When
I execute the stored procedure, I get "msg 11018  xp server must be up for
ESP to execute"  In the ASE log their is a message that says "xp server
failed to start.  Check if there is a entry for xp server ...

All - I hesitated to post this as I saw many similar postings in my
trawlings. However I have been unable to determine the problem in
relation to the answers I've seen for the similar problems. Basically
I had a working version of DBI and Sybase:DBD running with a 11.0.3

I've googled for this for a while but haven't found anything. Please could
someone tell me how I can find iF a table has a primary key and what is
the name of the constraint.
I have this so far (I'm on ASE 11.0 for Linux btw):

I tried looking around the Sybase website but could not find anything
(when the links worked that is....most didn't, sheesh).
Is the Developer's edition trialware, i.e., will work for only 30 days
or can't build a db bigger than 2gb, etc.

I know by the past, the question have already been asked ... but in
case of today, maybe we have new JAR for.
Could we use API to send Stream to Sybase?  Actually we need write a
file on the file system and call the BCP in command line ...

Is there a known problem (memory leak) with ISQL.exe (Sybase 11.0.3) on
VMS? We made a VMS batchprocedure which does an isql.exe call to
execute a stored procedure. It continues to loop if a certain table is
filled.

Hello everyone !!!
My problem:
I have recently installed ASE 12.5 on winxp. When I try to make a dump
or load with isql or DBArtisan i get this message:

I am preparing a script to generate database and server related
information for some reporting purpose.
I want to know how do I get the following information in ASE12.5
(1) For a table;

I am writing a script that would generate database and server related
information for some reporting purpose.
I want to know how do I get the following information in ASE12.5
(1) For a table;

Does (any version of) Sybase support the semistructured data model?
Can XML documents be stored efficiently on a Sybase database server?
What functionality (eg. indexing) and constraints (eg. schema
enforcement) does Sybase offer to semistructured data objects?

I need to get a table from a sybase DB.
I did a dbunload
fields are arranged this way :
'value',value,'value',value,'value',etc