hello again
How can I do a select in only one statement like below but including 6
tables?
select * from sysobjects where type ='U' and name not like 'TEST'

Hi friends,
I am having following query from oracle. I want to use the same in
sybase.
insert into AGS_TEMP

I have Sybase 12.5.3 on Solaris 5.8 and I need a generic bcp out and
then in for all tables, but I have 3 tables which have identity
columns that I need to keep.
Also in the same script I want to leave out 3 tables so I have a

Ok, I've read the instructions.  Honest.
I try (as per instructions),
bcp database.dbo.table out tableFile -c -Usa -P -Jutf8
And the error message is:

In a stored procedure, I have a simple SELECT by the primary key,
followed by an INSERT or UPDATE (depending on the result of the SELECT
query - if the record exists do the UPDATE, or do the INSERT
otherwise).

My simple java application can not connect the sybase database server
over LAN.
The client application is running on linux. The sybase database server
is running on a windows xp.

I have 2 tables and i have to map a decimal field in table A with a
character field in table B such that only the numeric part of the
character field is taken.

I have a character field which may have alphabets, numerals or both.
Is there any command to check if the first character or second
character of that field is an alphabet or numeral..

I inherited a collection of Sybase servers that are configured as
follows.
64 bit AMD processors. (Something like 10 on each machine.)
They run Solaris 10, 64 bit version. Machines are dedicated to Sybase

Hi Friends,
By mistake I deleted some rows from one of the tables in my sybase
database.
Is there any way to rollback that particular operation ? Please help,

Hello I am writing a web front end for some tables. For some reason i
can do select * from table where id=1  but i cant do where id='1' . Is
there a way to structure the query the same way for numeric and char
fields. am I just imagenning this? thanks.

I was planning to install Sybase EX on a Linux host. Since the product
is free, how does one get patches and updates after it is installed?
Sybase's bare bone basic support contract is $2200. Do I have to have
shell out 2K+ per annum to get patches and updates?

As a follow up to my previous question. Does anyone have any
experience with sybmigrate? I found it perusing the Sybase site. I'm
not sure how robust it is, but the tables I have to migrate from 2K to
something bigger are many 10's milliion rows.

looking for more info refering  SCSYBTHETIC CURSOR  to use ti in my
store
procedure.
I checked in  T-SQL  Guide  on sybase 12.5.x    but  I did not fin any

Dear Users
Can anyone help me solving the follwoing problem
We are trying to fetch data from sybase system through vb.net using
DSN connection. we are using ODBC driver "sybase system 11 ver