Candle-lite DB2 - Manual (Page 63)

Customizing OMEGAMON II 63
Using the Callable Interface
5 Press the Process SQL key.
Step Action
GoTo Options Tools Help
+------------------------------------------------------------ mm/dd/yy 8:47:27
| SQL Call Being Executed System: D41A
|
+--------------------------------------+--------------------------------------+
| Thread: Plan . . . . . : DSNESPCS | Attach: TSO Userid . . : RBRIN3 |
| Connid . . . . : TSO | Region ASID . :
|
| Corrid . . . . : RBRIN3 | |
| Authid . . . . : RBRIN3 | |
+--------------------------------------+--------------------------------------+
| Lines 1 to 15 of 15 |
+-----------------------------------------------------------------------------+
|SQL call is active, call information is as follows :
|
| |
|Thread Status = IN-SQL-CALL SQL Request Type = DYNAMIC |
|Total SQL Reqs = 2 SQL Call Type = OPEN CURSOR |
|SQL DBRM Name = DSNESM68 SQL Statement Number = 00193 |
|Collection ID = DSNESPCS |
| |
| SELECT A.PLNAME, SECTNO, STMTNO, CARD |
| FROM SYSIBM.SYSSTMT A, |
| SYSIBM.SYSPLAN B, |
| SYSIBM.SYSTABLES C |
| WHERE A.PLNAME = B.NAME |
| AND A.STMTNO > C.CARD |
| ORDER BY SECTNO DESC, STMTNO ASC |
| |
+-----------------------------------------------------------------------------+