we are developing a JDBC based SOA application with a Sybase ASE server
as DB. jConnect is version 5.5.
In the following code snippet
 Statement stmt = this.getDbConnection().createStatement();

I am having a problem with compressed multiple database dump to tape.
am using the following sequence for taking the dump:
dump database smiadb to "/dev/rmt/1un" file = smiadb, capacity
400000000 with init, compression = 1

BEGIN
------
select a from x , y where x.d=y.d and x.w=y.w
-------

How do you show all the tables using NAvSQL?  I'm more familiar with
"select * from cat;" in SQL plus?  Are there any reference guide for
NavSQL-- thank you.

How do I capture and process the results set returned from one stored
procedure within a second stored procedure?
For example if sp1 returns 10 rows, how would I be able to code sp2 to
exec sp1 and use those 10 rows to perhaps populate a temp table?

In the Bad Old Days, using ALTER TABLE to drop/modify columns was not
fully supported and people were warned away from using it in case
things went bang / tables got corrupted etc.
Now it's a supported feature in 12.5.x (maybe earlier than that, I

while using ESQL, is there any way to get the value for the number of
rows affected for my SQL? i mean, if the result returns 2 rows, i need
to get the value 2, or if there is no matching, need to get the value 0.

Following are some quick questions?
1. How much RAM we need to assign (for Sybase) to install Sybase
(Windows OS) to our new db server?
2. Is there some type of default RAM setting that I can go with that

I want to make a replica of my current database with a new name in ASE
15.0. I am new to sybase. Pls suggest me a solution.
Thanks
Sasank

Would someone please take a look at this query, and let me know if
there is an easier/better/nicer way to obtain a picture of current
users that are blocking other users.
select

Is Full Outer Join is supported by Sybase ASE 12.x? If yes, can someone
please explain me what syntax is to be used?
Thanks.

'not sure if anyone can help here; I'm cross-posting to both a Perl & a
Sybase forum ....
I've used Sybase::Xfer (a Perl 5.8.6 module) to transfer data between
ASE 12.5.3 databases for months, in slightly varied applications with

I need to insert a set of values into table_2 and these values are read
from table_1. This insertion now goes only if an identitycolumn does
not match an existing value.
For example

I am looking to get some pricing or Sybase ASE, Rep Server and IQ
Management tools.  Any input on the below would be greatly appreciated.
Quest
Does Quest have management tools for ASE, Rep Server and IQ?

i'm using JAVA with jconnect 6.0 on an IQ 12.5 server to perform a
query which involve a timestamp column.
The value is equal to '2006-07-10 00:21:50.71'.
if i do my query like :