I am writing a program which logs in to a sybase database and then
fires SQL queries ( only select queries ). Right now i am using  "SA"
login to fire the queries. In practical scenerio i wont be able to get
SA login/password. So i need to logon as a user which has at least read

Where is the best place to find a Sybase DBA that would work on a
contract requiring periodic performance tuning, database administration,
etc.?  We haven't enough work to keep a DBA busy full-time, but we also
haven't the in-house skill to expertly manage our Linux-hosted 12.5.x ...

I am writing a vb.net autoprocess using Sybase ASE 12.5.2. Therough the
program i am trying to insert certain data into a sybase table through
a stored procedure.
The problem is when i execute the stored procedure from back end with

I am trying to execute a dynamic query as follows
begin
declare @tablename char(46)
declare @query char(1000)

Hello Sybase users,
I would like to convert following sql to stored proc that I code in
java.
select * from my1, my2 where my1.id=my2.my1id

Can anyone tell me a single query from where i can get the user defined
tables in "parent-then-child" order. Means i want to list all the user
defined tables(that does not have foreign keys first) and then all the
tables with foreign keys.

Does anyone have a definitive answer on the difference between Sybase
ASE for Solaris and the Small Business Edition of the same product. I
know it limits connections to 256 and Engines to 4, but are there any
functional differences.

Current spec server is ASE 11.9.2 on HP/UX 10.20.  Old hardware of
HP9000 K380 (4 x 266MHz and 1GB RAM).
Provisional new spec server is ASE 15 on HP/UX 11i.  New hardware of
HP9000 RP7420 (6 x 1.1GHz and 10GB RAM)

Dear Michael (or anyone else at Sybase),
I see you are a Team Developer. So probably you can provide indication
for the following important issue.
Someone, on the other sybase newsgroup, has rightly observed that I am

I just checked the our databases using db_check.sh.
It turns out that the following db's are 100 % used:
master    type data/log
model     type data/loge

  I am trying to gain understanding of xp_cmdshell. How does this
affect the sybase that is sitting on Unix server. Does this only matter
if the sybase is running on windows?
any suggestions or link would be appreciated. Thank you

The following code is used in PowerBuilder 8.01 to set a pointer to the
Sybase OpenClient software and define the SQLCA object.
type prototypes
FUNCTION boolean SetEnvironmentVariableA ( string szName, string

I am new to this group and looking for a good tutorial to start with
sybase. I would like to know about how to execute the queries within a
script. Please help.
Thanks in advance,

Hope someone can help with a query that I'm trying to implement for
Sybase ASA 9.  This will eventually end up as a view from which other
reports will be generated.
I have an orders table, from which I need to calculate a column that

running into a problem trying to change the database context with 'use
database' ... I've read a couple of threads but unable to see a
definitive answer .. anyone able to help ?
When I run the script the first print returns 'master' (good) but the