SQL Activity keywords for the FIELDID option of the DISTRIBUTE command.
The following sections show the FIELDID options that are available for SQL Activity keywords.
| Keyword | Description |
|---|---|
| SQLPREPE | Prepare statements elapsed time. |
| SQLPREPT | Prepare statements TCB time. |
| SQLOPENE | Open statements elapsed time. |
| SQLOPENT | Open statements TCB time. |
| SQLSELCE | Select statements elapsed time. |
| SQLSELCT | Select statements TCB time. |
| SQLINSRE | Insert statements elapsed time. |
| SQLINSRT | Insert statements TCB time. |
| SQLUPDTE | Update statements elapsed time. |
| SQLUPDTT | Update statements TCB time. |
| SQLDELTE | Delete statements elapsed time. |
| SQLDELTT | Delete statements TCB time. |
| SQLFETCE | Fetch statements elapsed time. |
| SQLFETCT | Fetch statements TCB time. |
| SQLCLOSE | Close statements elapsed time. |
| SQLCLOST | Close statements TCB time. |
| SQLDMLE | Any DML statements elapsed time. |
| SQLDMLT | Any DML statements TCB time. |
| SQLDDLE | Any DDL statements elapsed time. |
| SQLDDLT | Any DDL statements TCB time. |
| SQLDCLE | Any DCL statements elapsed time. |
| SQLDCLT | Any DCL statements TCB time. |
| SQLANYE | Any SQL statements elapsed time. |
| SQLANYT | Any SQL statements TCB time. |