Learn about the correspondence between resource type and
command function for the monitored CICS® commands.
The TYPE (resource type) and FUNCTION (command) columns
have specific values defined by CICS IA at
the time the data is loaded into DB2®.
For
a list of the possible combinations of TYPE and FUNCTION values in DB2 queries, see Table 43.
For a list of the
possible combinations of TYPE and FUNCTION values in IMS™ queries, see Table 44.
For a list of the
possible combinations of TYPE and FUNCTION values in MQ queries, see Table 45.
Table 1. Type and Function
mapping for monitored commands using the API ATOMServices CICS resource option flagResource type |
Function |
CICS command
name |
RECORD |
BIF DIGEST |
BIF DIGEST RECORD |
Table 2. Type and Function mapping for monitored commands
using the SPI ATOMServices CICS resource
option flagResource type |
Function |
CICS command
name |
ATOMSERVICE |
CREATE |
CREATE ATOMSERVICE |
DISCARD |
DISCARD ATOMSERVICE |
INQUIRE |
INQUIRE ATOMSERVICE |
INQUIRE NEXT |
INQUIRE ATOMSERVICE NEXT |
SET |
SET ATOMSERVICE |
Table 3. Type and Function
mapping for monitored commands using the SPI BRFacility CICS resource option flagResource type |
Function |
CICS command
name |
BRFACIL |
INQ NEXT |
INQUIRE BRFACILITY NEXT |
INQUIRE |
INQUIRE BRFACILITY |
SET |
SET BRFACILITY |
Table 4. Type and
Function mapping for monitored commands using the SPI Bundles CICS resource option flagResource type |
Function |
CICS command
name |
BUNDLE |
CREATE |
CREATE BUNDLE |
DISCARD |
DISCARD BUNDLE |
INQUIRE |
INQUIRE BUNDLE |
INQUIRE NEXT |
INQUIRE BUNDLE NEXT |
SET |
SET BUNDLE |
BUNDLEPART |
INQUIRE |
INQUIRE BUNDLEPART |
INQUIRE NEXT |
INQUIRE BUNDLEPART NEXT |
Table 5. Type and
Function mapping for monitored commands using the SPI Corbaserver CICS resource option flagResource type |
Function |
CICS command
name |
CORBASRV |
CREATE |
CREATE CORBASERVER |
DISCARD |
DISCARD CORBASERVER |
INQ NEXT |
INQUIRE CORBASERVER NEXT |
INQUIRE |
INQUIRE CORBASERVER |
PERFORM |
PERFORM CORBASERVER |
SET |
SET CORBASERVER |
Table 6. Type and
Function mapping for monitored commands using the API Counters CICS resource option flagResource type |
Function |
CICS command
name |
COUNTER |
DEFINE |
DEFINE COUNTER |
DEFINE |
DEFINE DCOUNTER |
DELETE |
DELETE COUNTER |
DELETE |
DELETE DCOUNTER |
GET |
GET COUNTER |
GET |
GET DCOUNTER |
QUERY |
QUERY COUNTER |
QUERY |
QUERY DCOUNTER |
REWIND |
REWIND COUNTER |
REWIND |
REWIND DCOUNTER |
UPDATE |
UPDATE COUNTER |
UPDATE |
UPDATE DCOUNTER |
POOL |
DEF CTR |
DEFINE COUNTER POOL |
DEF DCTR |
DEFINE DCOUNTER POOL |
DEL CTR |
DELETE COUNTER POOL |
DEL DCTR |
DELETE DCOUNTER POOL |
GET CTR |
GET COUNTER POOL |
GET DCTR |
GET DCOUNTER POOL |
QRY CTR |
QUERY COUNTER POOL |
QRY DCTR |
QUERY DCOUNTER POOL |
REW CTR |
REWIND COUNTER POOL |
REW DCTR |
REWIND DCOUNTER POOL |
UPD CTR |
UPDATE COUNTER POOL |
UPD DCTR |
UPDATE DCOUNTER POOL |
Table 7. Type and Function
mapping for monitored commands using the SPI CSD CICS resource option flagResource type |
Function |
CICS command
name |
|
CSDENDBRRSRCE |
CSD ENDBRRSRCE |
CSDDISCONNECT |
CSD DISCONNECT |
GROUP |
CSDADD |
CSD ADD GROUP |
CSDALTER RESOURCE |
CSD ALTER RESTYPE |
CSDCOPY |
CSD COPY GROUP |
CSDCOPY GROUP TO |
CSD COPY GROUP |
CSDCOPY RESOURCE IN |
CSD COPY RESTYPE |
CSDCOPY RESOURCE AS |
CSD COPY RESTYPE |
CSDCOPY RESOURCE TO |
CSD COPY RESTYPE |
CSDDEFINE RESOURCE IN |
CSD DEFINE RESTYPE |
CSDDELETE |
CSD DELETE GROUP |
CSDDELETE RESOURCE |
CSD DELETE RESTYPE |
CSDGETNEXTGROUP |
CSD GETNEXTGROUP GROUP |
CSDGETNEXTRSRCE IN |
CSD GETNEXTRSRCE RESTYPE |
CSDINQIREGROUP |
CSD INQUIREGROUP GROUP |
CSDINQIREGROUP |
CSD INQUIREGROUP GROUP LIST |
CSDINQIRERSRCE |
CSD INQUIRERSRCE RESTYPE |
CSDINSTLALL |
CSD INSTALL GROUP |
CSDINSTLALL RESOURCE |
CSD INSTALL RESTYPE |
CSDLOCK |
CSD LOCK GROUP |
CSDREMOVE |
CSD REMOVE GROUP |
CSDRENAME RESOURCE |
CSD RENAME RESTYPE |
CSDSTARTBRGROUP |
CSD STARTBRGROUP |
CSDSTARTBRRSRCE |
CSD STARTBRRSRCE |
CSDENDBRGROUP |
CSD ENDBRGROUP |
CSDUNLOCK |
CSD UNLOCK GROUP |
CSDUSERDEFINE RESOURCE |
CSD USERDEFINE RESTYPE |
LIST |
CSDADD GROUP TO |
CSD ADD GROUP |
CSDAPPEND |
CSD APPEND LIST |
CSDAPPEND TO |
CSD APPEND LIST |
CSDDELETE |
CSD DELETE LIST |
CSDENDBRLIST |
CSD ENDBRLIST |
CSDGETNEXTLIST |
CSD GETNEXTLIST LIST |
CSDINQUIREGROUP IN |
CSD INQUIREGROUP GROUP LIST |
CSDINQUIRELIST |
CSD INQUIRELIST LIST |
CSDINSTALL |
CSD INSTALL LIST |
CSDLOCK |
CSD LOCK LIST |
CSDREMOVE GROUP |
CSD REMOVE GROUP |
CSDSTARTBRLIST |
CSD STARTBRLIST |
CSDUNLOCK |
CSD UNLOCK LIST |
RESOURCE |
CSDALTER |
CSD ALTER RESTYPE |
CSDCOPY |
CSD COPY RESTYPE |
CSDDEFINE |
CSD DEFINE RESTYPE |
CSDDELETE |
CSD DELETE RESTYPE |
CSDGETNEXTRSRCE |
CSD GETNEXTRSRCE RESTYPE |
CSDINQUIRERSRCE |
CSD INQUIRERSRCE RESTYPE |
CSDINSTALL |
CSD INSTALL RESTYPE |
CSDRENAME |
CSD RENAME RESTYPE |
CSDUSERDEFINE |
CSD USERDEFINE RESTYPE |
Table 8. Type and Function
mapping for monitored commands using the SPI DB2 CICS resource
option flagResource type |
Function |
CICS command
name |
DB2ENTRY |
CREATE |
CREATE DB2ENTRY |
DISCARD |
DISCARD DB2ENTRY |
INQ NEXT |
INQUIRE DB2ENTRY NEXT |
INQUIRE |
INQUIRE DB2ENTRY |
SET |
SET DB2ENTRY |
DB2TRAN |
CREATE |
CREATE DB2TRAN |
DISCARD |
DISCARD DB2TRAN |
INQ NEXT |
INQUIRE DB2TRAN NEXT |
INQUIRE |
INQUIRE DB2TRAN |
SET |
SET DB2TRAN |
Table 9. Type and Function
mapping for monitored commands using the SPI DJAR CICS resource option flagResource type |
Function |
CICS command
name |
DJAR |
CREATE |
CREATE DJAR |
DISCARD |
DISCARD DJAR |
INQ NEXT |
INQUIRE DJAR NEXT |
INQUIRE |
INQUIRE DJAR |
PERFORM |
PERFORM DJAR |
JVMPROF |
INQ NEXT |
INQUIRE JVMPROFILE NEXT |
INQUIRE |
INQUIRE JVMPROFILE |
Table 10. Type and
Function mapping for monitored commands using the API EVENT proc CICS resource option flagResource type |
Function |
CICS command
name |
EVENT |
SIGNAL |
SIGNAL EVENT |
Table 11. Type and
Function mapping for monitored commands using the SPI EVENT proc CICS resource option flagResource type |
Function |
CICS command
name |
EVENTBINDING |
INQUIRE |
INQUIRE EVENTBINDING |
INQUIRE NEXT |
INQUIRE EVENTBINDING NEXT |
SET |
SET EVENTBINDING |
INQUIRE CAPTURESPEC |
INQUIRE CAPTURESPEC |
EVENTPROCESS |
INQUIRE |
INQUIRE EVENTPROCESS |
SET |
SET EVENTPROCESS |
CAPTURESPEC |
INQUIRE |
INQUIRE CAPTURESPEC |
INQUIRE NEXT |
INQUIRE CAPTURESPEC NEXT |
Table 12. Type and Function
mapping for monitored commands using the API Exits CICS resource option flagResource type |
Function |
CICS command
name |
EXIT |
CALL |
(Call to TRUE) |
Table 13. Type and Function
mapping for monitored commands using the SPI Exits CICS resource option flagResource type |
Function |
CICS command
name |
EXIT |
DISABLE |
DISABLE PROGRAM |
ENABLE |
ENABLE PROGRAM |
EXTRACT |
EXTRACT EXIT |
Table 14. Type and Function
mapping for monitored commands using the FEPI API CICS resource option flagResource type |
Function |
CICS command
name |
FEPI |
EXTRACTF |
FEPI EXTRACT FIELD |
EXTRACTS |
FEPI EXTRACT STNS |
FREE |
FEPI FREE |
ISSUE |
FEPI ISSUE |
RECEIVE |
FEPI RECEIVE DATASTREAM |
RECEIVE |
FEPI RECEIVE FORMATED |
REQTCKT |
FEPI REQUEST PASSTICKET |
SEND |
FEPI SEND DATASTREAM |
SEND |
FEPI SEND FORMATTED |
START |
FEPI START |
FEPIPOOL |
ALLOCATE |
FEPI ALLOCATE POOL |
CONVERSE |
FEPI CONVERSE DATASTREAM |
CONVERSE |
FEPI CONVERSE FORMATTED |
EXTRACTC |
FEPI EXTRACT CONV |
Table 15. Type and Function
mapping for monitored commands using the FEPI SPI CICS resource option flagResource type |
Function |
CICS command
name |
FEPINODE |
INQ CONN |
FEPI INQUIRE TARGET |
INQ NODE |
FEPI INQUIRE NODE |
SET CONN |
FEPI SET CONNECTION |
SET NODE |
FEPI SET NODE |
FEPIPOOL |
ADD POOL |
FEPI ADD POOL |
DEL POOL |
FEPI DELETE POOL |
DISCPOOL |
FEPI DISCARD POOL |
INQ POOL |
FEPI INQUIRE POOL |
INSTPOOL |
FEPI INSTALL POOL |
SET POOL |
FEPI SET POOL |
FEPISET |
DISCPSET |
FEPI DISCARD POOL |
INQ PSET |
FEPI INQUIRE PROPERTYSET |
INSTPSET |
FEPI INSTALL PROPERTYSET |
FEPITGT |
INQ TRGT |
FEPI INQUIRE TARGET |
SET TRGT |
FEPI SET CONNECTION |
Table 16. Type and Function
mapping for monitored commands using the SPI File CICS resource option flagResource type |
Function |
CICS command
name |
FILE |
CREATE |
CREATE FILE |
DISCARD |
DISCARD FILE |
INQ NEXT |
INQUIRE FILE NEXT |
INQUIRE |
INQUIRE FILE |
SET |
SET FILE |
Table 17. Type and Function
mapping for monitored commands using the API Files CICS resource option flagResource type |
Function |
CICS command
name |
FILE |
DELETE |
DELETE |
ENDBR |
ENDBR |
READ |
READ |
READ UPD |
READ UPDATE |
READNEXT |
READNEXT |
READPREV |
READPREV |
RESETBR |
RESETBR |
REWRITE |
REWRITE |
STARTBR |
STARTBR |
UNLOCK |
UNLOCK |
WRITE |
WRITE |
Table 18. Type and
Function mapping for monitored commands using the SPI IPCONN CICS resource option flagResource type |
Function |
CICS command
name |
IPCONN |
CREATE |
CREATE IPCONN |
DISCARD |
DISCARD IPCONN |
INQUIRE |
INQUIRE IPCONN |
SET |
SET IPCONN |
Table 19. Type and
Function mapping for monitored commands using the API Journals CICS resource option flagResource type |
Function |
CICS command
name |
JOURNAL |
WAIT |
WAIT JOURNALNAME |
WAIT |
WAIT JOURNALNUM |
WRITE |
WRITE JOURNALNAME |
WRITE |
WRITE JOURNALNUM |
Table 20. Type and
Function mapping for monitored commands using the SPI Journals CICS resource option flagResource type |
Function |
CICS command
name |
JOURNAL |
DISCARD |
DISCARD JOURNALNAME |
INQ NEXT |
INQUIRE JOURNALNAME NEXT |
INQ NEXT |
INQUIRE JOURNALNUM NEXT |
INQUIRE |
INQUIRE JOURNALNAME |
INQUIRE |
INQUIRE JOURNALNUM |
SET |
SET JOURNALNAME |
SET |
SET JOURNALNUM |
Table 21. Type
and Function mapping for monitored commands using the SPI JVMServer CICS resource option flagResource type |
Function |
CICS command
name |
JVMSERVER |
CREATE |
CREATE JVMSERVER |
INQUIRE |
INQUIRE JVMSERVER |
INQUIRE NEXT |
INQUIRE JVMSERVER NEXT |
DISCARD |
DISCARD JVMSERVER |
SET |
SET JVMSERVER |
Table 22. Type and Function
mapping for monitored commands using the SPI Library CICS resource option flagResource type |
Function |
CICS command
name |
LIBRARY |
CREATE |
CREATE LIBRARY |
DISCARD |
DISCARD LIBRARY |
INQUIRE |
INQUIRE LIBRARY |
SET |
SET LIBRARY |
Table 23. Type and
Function mapping for monitored commands using the SPI MQCONN CICS resource option flagResource type |
Function |
CICS command
name |
MQCONN |
CREATE |
CREATE MQCONN |
INQUIRE |
INQUIRE MQCONN |
DISCARD |
DISCARD MQCONN |
SET |
SET MQCONN |
MQINI |
INQUIRE |
INQUIRE MQINI |
DISCARD |
DISCARD MQINI |
Table 24. Type and Function
mapping for monitored commands using the API Others CICS resource option flagResource type |
Function |
CICS command
name |
|
ADDRESS |
ADDRESS |
ALLOCATE |
ALLOCATE |
DOCTEMP |
CREATE |
CREATE DOCTEMPLATE |
DISCARD |
DISCARD DOCTEMPLATE |
INQ NEXT |
INQUIRE DOCTEMPLATE NEXT |
INQUIRE |
INQUIRE DOCTEMPLATE |
HANDLE |
PUSH |
PUSH HANDLE |
POP |
POP HANDLE |
STORAGE |
FREEMAIN |
FREEMAIN |
GETMAIN |
GETMAIN |
STORSHR |
GETMAIN |
GETMAIN SHARED |
UOW |
ROLLBACK |
SYNCPOINT ROLLBACK |
SYNC |
SYNCPOINT |
Table 25. Type and Function
mapping for monitored commands using the API Presentation CICS resource option flagResource type |
Function |
CICS command
name |
|
RECEIVE |
RECEIVE |
ROUTE |
ROUTE |
SIGNOFF |
SIGNON |
SIGNON |
SIGNOFF |
ABEND |
ISSUE |
ISSUE ABEND |
CONFRMTN |
ISSUE |
ISSUE CONFIRMATION |
COPY |
ISSUE |
ISSUE COPY |
DISCONNT |
ISSUE |
ISSUE DISCONNECT |
ERROR |
ISSUE |
ISSUE ERROR |
MAP |
PURGE |
PURGE MESSAGE |
RECEIVE |
RECEIVE MAP |
SEND |
SEND MAP |
MAPSET |
RECV MAP |
RECEIVE MAP MAPSET |
SEND MAP |
SEND MAP MAPSET |
PASS |
ISSUE |
ISSUE PASS |
PROCESS |
EXTRACT |
EXTRACT PROCESS |
RESET |
ISSUE |
ISSUE RESET |
SIGNAL |
ISSUE |
ISSUE SIGNAL |
TERMINAL |
WAIT |
WAIT TERMINAL |
TEXT |
SEND |
SEND TEXT |
Table 26. Type and Function
mapping for monitored commands using the API Presentation or the API
DTP CICS resource option flagResource type |
Function |
CICS command
name |
|
CONVERSE |
CONVERSE |
FREE |
FREE |
SEND |
SEND |
PROCESS |
CONNECT |
CONNECT PROCESS |
Table 27. Type and
Function mapping for monitored commands using the API Presentation
or the API Others CICS resource
option flagResource type |
Function |
CICS command
name |
|
ASSIGN |
ASSIGN |
Table 28. Type and Function
mapping for monitored commands using the SPI Programs CICS resource option flagResource type |
Function |
CICS command
name |
PROGRAM |
CREATE |
CREATE PROGRAM |
DISCARD |
DISCARD PROGRAM |
INQ NEXT |
INQUIRE PROGRAM NEXT |
INQUIRE |
INQUIRE PROGRAM |
SET |
SET PROGRAM |
Table 29. Type and Function
mapping for monitored commands using the API Programs CICS resource option flagResource type |
Function |
CICS command
name |
CHANNEL |
DEL CNTR |
DELETE CONTAINER CHANNEL |
GET CNTR |
GET CONTAINER CHANNEL |
LINK |
LINK PROGRAM CHANNEL |
MOV CNTR |
MOVE CONTAINER CHANNEL |
PUT CNTR |
PUT CONTAINER CHANNEL |
RETURN |
RETURN CHANNEL |
XCTL |
XCTL PROGRAM CHANNEL |
CONTAINR |
DELETE |
DELETE CONTAINER |
GET |
GET CONTAINER |
MOVE |
MOVE CONTAINER |
PUT |
PUT CONTAINER |
PROGRAM |
CALL |
Dynamic program call |
HANDABND |
HANDLE ABEND |
LINK |
LINK |
LOAD |
LOAD |
XCTL |
XCTL |
Table 30. Type and Function
mapping for monitored commands using the API Task Control CICS resource option flagResource type |
Function |
CICS command
name |
ENQNAME |
DEQ |
DEQ |
DEQSYS |
DEQ (scope is sysplex-wide) |
ENQ |
ENQ |
ENQSYS |
ENQ (scope is sysplex-wide) |
Table 31. Type and Function
mapping for monitored commands using the SPI TCPIPService CICS resource option flagResource type |
Function |
CICS command
name |
TCPIPSRV |
CREATE |
CREATE TCPIPSERVICE |
DISCARD |
DISCARD TCPIPSERVICE |
INQ NEXT |
INQUIRE TCPIPSERVICE NEXT |
INQUIRE |
INQUIRE TCPIPSERVICE |
SET |
SET TCPIPSERVICE |
Table 32. Type and Function
mapping for monitored commands using the API TD Queues CICS resource option flagResource type |
Function |
CICS command
name |
TD |
DELETEQ |
DELETEQ TD |
READQ |
READQ TD |
WRITEQ |
WRITEQ TD |
Table 33. Type and Function
mapping for monitored commands using the SPI Temp Storage CICS resource option flagResource type |
Function |
CICS command
name |
TS |
INQ NEXT |
INQUIRE TSQNAME NEXT |
INQ NEXT |
INQUIRE TSQUEUE NEXT |
INQUIRE |
INQUIRE TSQNAME |
INQUIRE |
INQUIRE TSQUEUE |
SET |
SET TSQNAME |
SET |
SET TSQUEUE |
TSMODEL |
CREATE |
CREATE TSMODEL |
DISCARD |
DISCARD TSMODEL |
INQUIRE |
INQUIRE TSMODEL |
TSPOOL |
INQUIRE |
INQUIRE TSPOOL |
Table 34. Type and Function
mapping for monitored commands using the API Transactions CICS resource option flagResource type |
Function |
CICS command
name |
TRANSID |
RETURN |
RETURN |
START |
START |
START |
START ATTACH |
START |
START BREXIT |
STARTREQ |
START REQID |
Table 35. Type and Function
mapping for monitored commands using the SPI Transactions CICS resource option flagResource type |
Function |
CICS command
name |
TRANSID |
CREATE |
CREATE TRANSACTION |
DISCARD |
DISCARD TRANSACTION |
INQ NEXT |
INQUIRE TRANSACTION NEXT |
INQUIRE |
INQUIRE TRANSACTION |
SET |
SET TRANSACTION |
Table 36. Type and
Function mapping for monitored commands using the SPI Transient Data CICS resource option flagResource type |
Function |
CICS command
name |
TD |
CREATE |
CREATE TDQUEUE |
DISCARD |
DISCARD TDQUEUE |
INQ NEXT |
INQUIRE TDQUEUE NEXT |
INQUIRE |
INQUIRE TDQUEUE |
SET |
SET TDQUEUE |
Table 37. Type and Function
mapping for monitored commands using the API TS Queues CICS resource option flagResource type |
Function |
CICS command
name |
CHANNEL |
START |
START CHANNEL |
TS |
DELETEQ |
DELETEQ TS |
READQ |
READQ TS |
WRITEQ |
WRITEQ TS |
TSAU |
DELETEQ |
DELETEQ TS (auxiliary storage) |
READQ |
READQ TS (auxiliary storage) |
WRITEQ |
WRITEQ TS (auxiliary storage) |
TSSHR |
DELETEQ |
DELETEQ TS (shared) |
READQ |
READQ TS (shared) |
WRITEQ |
WRITEQ TS (shared) |
Table 38. Type and Function mapping
for monitored commands using the API Web Services CICS resource option flagResource type |
Function |
CICS command
name |
SERVICE |
INVOKE |
INVOKE SERVICE |
WEB |
ENDBR |
WEB ENDBROWSE |
EXTRACT |
WEB EXTRACT |
READ |
WEB READ |
READNEXT |
WEB READNEXT |
RECEIVE |
WEB RECEIVE |
RETRIEVE |
WEB RETRIEVE |
SEND |
WEB SEND |
STARTBR |
WEB STARTBROWSE |
WRITE |
WEB WRITE HTTPHEADER |
WEBSRV |
CALL |
A web service call into CICS |
INVOKE |
INVOKE WEBSERVICE |
Table 39. Type and Function
mapping for monitored commands using the SPI Web Services CICS resource option flagResource type |
Function |
CICS command
name |
PIPELINE |
CREATE |
CREATE PIPELINE |
DISCARD |
DISCARD PIPELINE |
INQ NEXT |
INQUIRE PIPELINE NEXT |
INQUIRE |
INQUIRE PIPELINE |
PERFORM |
PERFORM PIPELINE |
SET |
SET PIPELINE |
URIMAP |
CREATE |
CREATE URIMAP |
DISCARD |
DISCARD URIMAP |
INQ NEXT |
INQUIRE URIMAP NEXT |
INQUIRE |
INQUIRE URIMAP |
SET |
SET URIMAP |
WEBSRV |
CREATE |
CREATE WEBSERVICE |
DISCARD |
DISCARD WEBSERVICE |
INQ NEXT |
INQUIRE WEBSERVICE NEXT |
INQUIRE |
INQUIRE WEBSERVICE |
SET |
SET WEBSERVICE |
Table 40. Type
and Function mapping for monitored commands using the API WSAddressing CICS resource option flagResource type |
Function |
CICS command
name |
CHANNEL |
BUILD WSACONTEXT |
WSACONTEXT BUILD |
GET WSACONTEXT |
WSACONTEXT GET |
DELETE WSACONTEXT |
WSACONTEXT DELETE |
WSACONTEXT |
BUILD |
WSACONTEXT BUILD |
GET |
WSACONTEXT GET |
DELETE |
WSACONTEXT DELETE |
WSAEPR |
CREATE |
WSAEPR CREATE |
Table 43. The possible combinations
of TYPE and FUNCTION values in DB2 queriesRESOURCE TYPE |
FUNCTION |
Dynamic |
EXECUTE IMMEDIATE |
CURSOR |
OPEN |
FETCH |
CLOSE |
ALLOCATE CURSOR |
TABLE |
SELECT |
INSERT |
DELETE |
UPDATE |
RENAME TABLE |
CREATE TABLE |
ALTER TABLE |
DROP TABLE |
VIEW |
CREATE VIEW |
DROP VIEW |
ALIAS |
CREATE ALIAS |
DROP ALIAS |
SYNONYM |
CREATE SYNONYM |
DROP SYNONYM |
PACKAGE |
DROP PACKAGE/PROGRAM |
STATEMENT |
PREPARE |
EXECUTE |
DESCRIBE |
INDEX |
CREATE INDEX |
DROP INDEX |
ALTER INDEX |
STOGROUP |
CREATE STOGROUP |
DROP STOGROUP |
ALTER STOGROUP |
TABLESPACE |
CREATE TABLESPACE |
DROP TABLESPACE |
ALTER TABLESAPCE |
DATABASE |
CREATE DATABASE |
DROP DATABSE |
ALTER DATABASE |
None |
EXPLAIN |
SET CURRENT SQLID |
SET CURRENT PACKAGESET |
SET CURRENT DEGREE |
SET HOST VAR |
INTOPEN |
GRANT |
REVOKE |
Remote SQL |
ROLLBACK |
LOCK |
COMMIT |
COMMENT ON |
LABEL ON |
CONNECT TO |
CONNECT RESET |
CONNECT |
IMPLICIT CONNECT |
TYPE2 CONNECT TO |
TYPE2 CONNECT RESET |
TYPE2 CONNECT |
SET CONNECTION |
RELEASE LOACATION && HV |
RELEASE CURRENT |
RELEASE ALL |
RELEASE ALL SQL |
RELEASE ALL PRIVATE |
SET CURRENT RULESS |
CALL STATEMENT |
DESCRIBE PROCEDURE |
ASSOCIATE LOCATORS |
FETCH ALLOC CURSOR |
CLOSE ALLOC CURSOR |
DESCRIBE ALLOC CURSOR |
DESCRIBE INPUT |
SET SPECIAL REGISTER |
Table 44. The possible combinations
of TYPE and FUNCTION values in IMS queriesRESOURCE TYPE |
FUNCTION |
PCB |
DELETE |
GET NEXT |
GET NEXT INP |
GET UNIQUE |
INSERT |
REPLACE |
PSB |
SCHEDULE |
Table 45. The
possible combinations of TYPE and FUNCTION values in MQ queriesRESOURCE TYPE |
FUNCTION |
BUFFER |
CONVERT |
CALLBACK |
MANAGE |
CONTROL |
MESSAGE
HANDLE |
CREATE |
CONVERT |
DELETE |
MESSAGE
PROPERTY |
SET |
INQUIRE |
DELETE |
QUEUE |
CLOSE |
GET |
OPEN |
PUT |
PUT1 |
INQUIRE |
SUBSCRIPTION |
REGISTER |
REQUEST |
|
STATUS |
Table 46. The possible combinations of TYPE and FUNCTION values in Natural
queriesRESOURCE TYPE |
FUNCTION |
ADABAS |
CALL |
PROGRAM |
CALL |