I have a table (id, name) as such:
Data:
id    name
==   =====

I am writing a script that calls a stored proc using ISQL.  In certain
cases I want to return -1 if the desired output is not there.  I tried
using a 'return' statement in my stored proc, but when I tried to
capture the return status in shell using '$?' it still gives a 0.

I have a table Rates(date,maturity,rate) in which are downloaded rates
for different maturity points, say 1YR, 2YR, 3YR and so on.  I wish to
write a query that would provide me if there were more or less maturity
points downloaded between two days.

I'm new to Sybase from Oracle.  Does Sybase have anything equivalent to
materialzed views?  If not want is the best practice for creating views with
huge amounts of data? Other than indexing the tables.
Thanks for help.

Hi I saw various postings related to error 5702.
Usally the problem is solved by upgrading the sybase version as this is
a bug in previous versions. But my case is opposite.
I have a C app. that is creating a cursor on a table and calling a

Could anybody let me know any GUI sybase tool for data manipulation and
viewing all database schema (tables, sp etc) like Toad in Oracle?

               This may be very basic but i still would like to ask
this.
I have a table with a timestamp field that gets updated by the DB
engine.

I'm trying to bcp into a 12.5 Sybase table in tempdb the syslogins file
which was bcp'd out of another server.  I keep getting the following
error in regards to the password column -
CSLIB Message:  - L0/O0/S0/N36/1/0:

I'm using DBD::Sybase to connect locally to databases on a RH 9 box. One
dsn looks like
dbi:Sybase:database=xxxxx;server=SYBASE;charset=iso_1
and another looks like

I'm new to Sybase.
I'm an Oracle/Pro*C developer.
It seems there is 2 ways to access Sybase database in C : Open Client
and Embedded SQL.

I try to keep a Sybase ASE 12.5(Linux) serve a client application
program (Win 2000 or XP) and the users experience poor database server
performance whent the client application uses a query of the following
kind.

Ok, i managed to connect to database server using open-client. can
execute query and all of that but still i can't use our front end to
connect to our server. this is what i got when i do this:
$ wine oursystem.exe

I'm sure that what I'm doing wrong is stupid...
But the Sybase help is ... no help... thanks in advance!
ALTER TRIGGER "admin"."TRG_TABLENAME_DELETE_ACTIVITYCOST" BEFORE DELETE
ORDER 1 ON "admin"."TableName"

(apologies if this is too OT for this group)
It appears there may be a viewer application for Powerdesigner, which
would let others view Powerdesigner files without needing the whole
application.

I have tested a stored procedure that SELECT INTO tempdb..myAppTable in
development as an user who has dbo rights.  Hence, the table can be
referenced as tempdb.dbo..myAppTable.
However, when the same stored procedure is run in production as a user