Please help me....
I have two tables *trainee2* and *grading_result2*.
TRAINEE2[/B] HAS AN ATTRIBUTE *GRADE*, WHICH I USE A TRIGGER TO UPDAT
AFTER I DO AN INSERT INTO *GRADING_RESULT2*.

Hi, I'm trying to run a simple SQL command thus:
$ isql -i input_file -o output_file user@host:port.
I'm using Solaris 8 as the OS and ASE 12.5.3 as the SQL server.
When I run the above command, the output file is generated but is 0

I need to do a select count from all User  indexes in sybase, and I
don't know how, I do know that for table is
select name from sysobjects where type ='U' order by name
Go

has someone some experience about ASE backup (12.5.3 and 15) with linux
LVM or hpux LVM
snapshots and netapp snapshots (on iSCSI) ?
thanks

I have to find a way to check if the replication has been done well,
checking if all the rows were replicated. This is for one huge table
(billions of rows). I was thinking in writing some sp...
Do you have any advice/comment on how to do this?

Does anybody know free tool for remote monitoring database?
thanks

Help
May i update database 9.0.1. for linux to 9.0.2. or can only update to
9.0.1. newest patch?
thanks.

I recently added another data device 200mb
disk init name="disk_dev_4", physname="<SYBASE_ROOT>\data\disk_dev_4" ,
vdevno=4,size=102400;
alter database dbmods on disk_dev_4=200;

I have just added a new column on an existing table.
This column is getting updated at an average rate of 25,000 rows per
day.
The table is written to and read from by a Sybase Stored Procedure.  I

We can create objects name in a sybase database using reserved
keywords, if we enclose the keyword with square bracket. Ex:
We can not create a table with the name, 'table' but we can create a
table with the name [table].

If i want to round off column amount with datatype float of a table,
table1, how can i round it off?
e.g.
amount: 67032 => 67032

   I need to write a query to find out a set of missing number in a given
sequence.
Eg :  a Column in some table has the following data
Col1

select convert(numeric(16,2), 5.329),convert(numeric(16,2), '5.329')
returns
5.32     5.33
I would like to understand the logic behind this behavior, if any.

Our project has a large number of tables and we need some generic
method to truncate them all (dropping tables is out of the question),
the problem is that some of the tables are  partitioned and some
aren't. I can implement the feature above easily as a stored procedure

Hi, I'm connected to a DB server via a command prompt. I'm not sure how
this comand prompt is set up and I'm trying to figure out a way of
getting the (fully qualified) server name (or address) and the port
thru which I'm connected so that I can use this info to use a more user