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 […]Read more "How to figure out what DB instance you are using when using isql (Sybase)"
Here is a sql statement that identify duplicate records.Read more "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.Read more "DB2 SQL Error codes"