I am not able to find the answer to the following query.
A table has three columns: Year, Quarter and Sales price.
Each year has four quarters and values for corresponding sales price
for each quarter is given. Populate the table and give the output as

Help,
I have this error message "THE TRANSACTION LOG IN DATABASE XXX IS
ALMOST FULL YOUR TRANSACTION IS BEING SUSPENDED UNTIL SPACE IS MADE
AVAILABLE IN THE LOG".

Is there a way to get JDBC Driver to throws SQLException in other language
then english?
If so what is the procedure.
Thanks,

I have 3 tables x,y,z all identical and indexed.
1) I create a view of x union y union z
2) I create table A containing data from x,y,z and index it the same
way as x,y,z

I've heard that when Sybase does a reorg, it creates a copy of the
table being worked on, loads this table via an insert..select
statement, drops and recreates the table, and then writes the data back
with another insert..select statement.

Under SunOS 5.1 and Sybase12.5,
I try to run a simple C test program which loads dynamically the CT-LIB
.so (libcs & libct)
But each time I run it, I  get the following error :

Some of our application people want some of the system tables (such as
sysprocedures) reorg'd.  Is there any benefit to having this done?
What are the caveats in doing this?
Patrick.

An identity gap is causing problems in one of my tables. And I also have
several foreign keys on other tables pointing to that defective id
column... Is there any way to repair this problem without having to remove
the foreign keys, repair the gap in all the involved tables and then

I get an error on a cursor fetching the result set of a stored
procedure :
"Cursor is not updatable: UNION is used in the query" on the OPEN
CURSOR command

Is there a way to, in Sybase, place a limit on the number of rows that
a single SELECT will return?  In MySQL, LIMIT can be used to do this.

I have the following 3 SQL statements that need to be combined, if
possible. The output of one feeds the input of the next. I need to view
all of the defined output fields (the output needs to be used in a
Crystal Report).

I'd like to know, how to find out whether a user is locked or not by the
attribute status in master..syslogins.
Is it as simple as it seems to be (224 = unlocked, 226 = locked) or is there
any clou about it?

I've installed Sybase Adaptive Server IQ 12.6 on my pc(windows XP
professional sp2)。
when I run Sybase Central Java Edtion, It prompt a error message like
this:

I use DbArtisan to connect to ASE databases.
But when I try to connect to Sybase IQ, I get : "ASA Error -131: Syntax
error near '(end of line)' on line 1"
What could be the reason ?

Say I have a tables that has two columns - column a and column b.  Both
support NULL values  I'd like to find all the rows where a <> a.
Unfortunately, NULL values seem to be confounding this.
If I do...