![](/images/new-backgrounds/1263700/263700125x1.webp)
Using the Callable Interface
Step |
|
|
|
|
| Action |
|
|
|
|
|
|
|
|
|
|
|
|
|
| |||
5 | Press the Process SQL key. |
|
|
|
|
|
|
| |||
|
| 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 | = | 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 |
|
|
|
| ||||||
|
|
|
|
|
|
|
|
|
| ||
| + |
|
|
|
|
|
|
| + | ||
|
|
|
|
|
|
|
|
|
|
|
|
Customizing OMEGAMON II | 63 |