Thursday, March 13, 2008

A gbscmd query to list situation description

Here is a simple EIB query that will list situations along with situation description text. You can execute the query using gbscmd. Hope you find it useful.

If you have security disabled
gbscmd executesql --server ddcaptiv01 --sql "SELECT SITNAME, TEXT FROM O4SRV.TSITDESC" --table O4SRV.UTCTIME

If you have security enabled
gbscmd executesql --server ddcaptiv01 --user --password --sql "SELECT SITNAME, TEXT FROM O4SRV.TSITDESC" --table O4SRV.UTCTIME

Related Info

To learn more about gbscmd, please checkout the following article.

gbscmd v2.1

No comments: