Today a coworker taught me how to figure out what database instance I am using when using the isql command line tool connecting to Sybase. This involves two query statements: select dbid from master..sysprocesses where spid = @@spid The above statement will display the dbid of the database instance you are using. Next using this [...]
Posts Tagged ‘sql’
How to figure out what DB instance you are using when using isql (Sybase)
Posted: December 9, 2011 in Database, TechnologyTags: isql, sql, Sybase
0
Here is a sql statement that identify duplicate records.
I encountered the following error message and not sure what I could do with it initially. “DB2 SQL error: SQLCODE: -401, SQLSTATE: 42818, SQLERRMC: >=” After a search online, I found the following document. This is very helpful. I hope DB2 would just include the description in the error output.
