Is there a way of bcp out and then in all tables in sybase? if so can
someone please help?
I just dont want to hard code every single table in a script if
possible

I am starting to tune the Metadata cache, but I am having trouble in
identifying one particular data structure: dbinfo. I am able to
identify and manipulate the dbtable structures for open databases, the
des structures for open objects and the ides structures for open

I am new to Sybase and I am using the Sybase API's to do a bulk copy.
But the blk_init function keeps on failing for me. I am trying to do a
bulk copy from Windows XP.
I have created  the connection and also set the CS_BULK_LOGIN as true.

I have customers that want to use timestamps as part of a unique key,
mainly to insure its uniqueness so I was wondering if there are any
good arguments for or against this.  Personally, I am against it but
I'm open to a good argument for it, if one exists.

I have a single table (tradeData) with 3 date fields
(settle_date,mat_date,value_date), and I am trying to determine the
largest date value within a row.
After some research the following SQL should seem to work, but I am

Can someone tell me whether the value for usertype for base datatypes
like char, varchar,int, decimal etc. changes from one Sybase ASE
release to another?
Thanks in advance

We have a stored procedure (developed by a third party) that runs a
number of queries to pull out monthly reporting data.
This procedure uses temp tables etc.
We are getting unreliable results - say running it for September works,

ASE 12.0.0.4
Solaris 8
We have an application that among other things currently uses an ASE
database to store pointers (physical location) of documents in a table.

Hello, we're currently experiencing some exceptional behaviour with one
of our production Sybase databases.
The situation is as follows:
Back ground:

Does someone know how to get only user defined tables? I mean SYSTABLE
contains all tables in database, so all system tables are there too. I
need to get something like you can check in "Interactive SQL" in
"Tools->Lookup Table Name", when only "Table" option is checked and

   I am trying to execute a query when starting isql. Some resources
have mentioned about -Q option to execute a query. It worked with isql
for SQL Server, but not with isql for Sybase. Is there any round about
way of doing this. Any help on this woukld be appreciated..

Hello I have a sp where the last statement is a "select * from...."
Now can I capture this resultset that is returned , into a table ?
(without modifying the sp itself)
Something like this ? (works in sql server, but not in sybase :( )

In our Business Application we are using the jconnect driver for years.
Now I read an Article
(http://www.ianywhere.com/developer/technotes/sas_jdbc_driver.html)
which tells me that the iAnywhere JDBC Driver is so much better, and

I'm trying to query off of Sybase tables using Embarcadero Rapid SQL
and I am trying to figure out the code to use to get date formatted to
"mmddyyyy" (10/12/2006 = 10122006).  Any ideas of what code I need to
use?