How to figure out what DB instance you are using when using isql (Sybase)

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 dbid to find out the name:

select name from master..sysdatabases where dbid = [dbid]

Thanks to Bob for this cool trick!

Duplicate records

Here is a sql statement that identify duplicate records.

DB2 SQL Error codes

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.