When you use the CIUSPAP1 stored procedure you can view or delete resource information for a CICS® TS application definition.
EXEC SQL
CALL CIUSPAP1 (calltype, appname, version1, version2, version3, operation, message, return-code);
There are several input parameters that help you to manage CIUSPAP1 processing and several output parameters that inform about the process completion and errors, if any.
Parameter name | Input/Output | Type | Description |
---|---|---|---|
calltype | INPUT | CHAR(4) | Type of call |
appname | INPUT | CHAR(64) | Specifies the application name (this parameter is used for all calltypes other than LIST). |
version 1 | INPUT | INTEGER | Specifies a Major Version of Application (this parameter is used for all calltypes other than LIST). |
version 2 | INPUT | INTEGER | Specifies a Minor Version of Application (this parameter is used for all calltypes other than LIST). |
version 3 | INPUT | INTEGER | Specifies a Micro Version of Application (this parameter is used for all calltypes other than LIST). |
operation | INPUT | CHAR(64) | Specifies the operation name (this parameter is optional and can be used for all calltypes other than LIST). |
message | OUTPUT | CHAR(300) | Specifies a message buffer. Contains error info in case of List call type or result of procedure execution in case of Delete call type. |
return-code | OUTPUT | INTEGER | Return code |
calltype |
Description |
---|---|
LIST | List of Applications for which CICS IA has collected data. |
DEL | Deletes all resources that are associated with the Application. |
RES | Lists all resources that are associated with the Application. |
CICS | Lists all CICS resources that are associated with the Application. |
DB2 | Lists all DB2 resources that are associated with the Application. |
IMS™ | Lists all IMS resources that are associated with the Application. |
MQ | Lists all WebSphere® MQ resources that are associated with the Application. |
NAT | Lists all Natural resources that are associated with the Application. |
Return code | Description |
---|---|
0 | CIUSPAP1 procedure has completed successfully. |
4 | Any SQL Exception or SQL Warning occurred, in this case ERROR-MESSAGE contains the message with explanation of exception/warning. |
8 | One of the following conditions
exists:
|
CALLTYPE='LIST'
Set
the other input parameters can be to null values.