Sybase | Forum profile

More simple version for the above sql that I can think of is finding the max diff on the salary based on the id. : ID SALARY 1 50 1 100 2 50 2 150 3 200 4 500 Result should look like & in the descending order: ID SALDIFF 2 100 1 50

Can you view the database dump? loada database <dbnam> from <filename> with listonly

hi, When I run the script below ,occur one error. bash-2.05$ dbisql -nogui -onerror exit -c "eng- iqtest;uid=DBA;pwd=SQL;links=tcpip{host=10.90.1.21 1;port=2688}" <<EOF >select top 1 * from table1 ; >EOF (DBA)>select top 1 * from table1 ; (DBA)> Execution time: 0.067 seconds The result returned is non-deterministic. SQLCODE=122, ODBC 3 State="01000" Line 1, column 1...

I guess you should put the EOF at the end where your all SQL statements end.

I guess you should put the EOF at the end where your all SQL statements end.

Hello, I have a system running on ASE 15.0.2, no ESD's loaded. Few weeks ago sybase shutdown, the root cause has been identified to be a memory leak in that happens every time RSA keypairs are generated. There is a correction for this fault in ESD4 but unfortunately I will not be able to load this ESD in quite long time. This is a fact even if I dont like it. Now Im looking for some work arounds that can be used for the server. 1....

Hello, I have a system running on ASE 15.0.2, no ESD's loaded. Few weeks ago sybase shutdown, the root cause has been identified to be a memory leak in that happens every time RSA keypairs are generated. There is a correction for this fault in ESD4 but unfortunately I will not be able to load this ESD in quite long time. This is a fact even if I dont like it. Now Im looking for some work arounds that can be used for the server. 1....

I need to bcp out from a sybase table but only need a subset of the columns, not all the columns and then bcp them into a MS sql server table. Does a format file work in this case? If so, how do you creat this format file? Also, if I bcp out the entire table from Sybase without skipping columns, is there anything I can do on the SQL server end to eliminate some of the sybase columns when I bcp in? thanks,

Select a.ID, (a.MaxSal - b.MinSal) as SalDiff From ( Select ID, Max(Salary) as MaxSal From SalTest Group By ID ) a, ( Select ID, Min(Salary) as MinSal From SalTest Group By ID ) b where a.ID = b.ID order by SalDiff desc

Easiest way would be to create a view of the columns you want, then BCP out the view.