How to: |
To invoke a NATURAL CICS transaction, you issue a Data Manipulation Language (DML) request, also known as a TABLE command, an SQL SELECT statement, or an EX command. (DML is the WebFOCUS internal retrieval language.) For information about the Data Manipulation Language, see the Stored Procedure Reference manual.
EX [app_name_space/]synonym 1=parm1_val,..., N=parmN_val EX [app_name_space/]synonymparm1_name=parm1_val,... , parmN_name=parmN_val EX [app_name_space/]synonym [, parm1_val [,...[, parmN_val]]]
where:
Is the apps directory name under which the synonyms are stored. This value is optional.
Is the user friendly name of a repository entry that represents the object to be executed in the vendor environment.
Is the name of the parameter taken from the input metadata description.
Are the parameter values that match the input metadata description.
Note:
SET EXORDER=PGM/FEX EX IWAYIVPD 11111111, 11211111
TABLE FILE synonym PRINT [parameter [parameter] ... | *] [IF in-parameter EQ value] . . . END
where:
Is the synonym of the NATURAL CICS transaction you want to invoke.
Is the name of a parameter whose values you want to display. You can specify input parameters, output parameters, or input and output parameters.
If the transaction does not require parameters, enter an * in the syntax. This displays a dummy segment, created during metadata generation, to satisfy the structure of the SELECT statement.
Indicates that you want to display all indicated parameters.
Is used if you want to pass values to input parameters.
Is the name of an input parameter to which you want to pass a value.
Is the value you are passing to an input parameter.
TABLE FILE IWAYIVPD PRINT PERSONNEL_ID NAME BIRTH SALARY IF PERSONNEL_ID_FROM EQ '11111111' IF PERSONNEL_ID_TO EQ '11211111' IF SALARY NE 0 END
SQL SELECT [parameter [,parameter] ... | *] FROM synonym [WHERE in-parameter = value] . . . END
where:
Is the synonym of the NATURAL CICS transaction you want to invoke.
Is the name of a parameter whose values you want to display. You can specify input parameters, output parameters, or input and output parameters.
If the transaction does not require parameters, enter an * in the syntax. This displays a dummy segment, created during metadata generation, to satisfy the structure of the SELECT statement.
Indicates that you want to display all indicated parameters.
Is used if you want to pass values to input parameters.
You must specify the value of each parameter on a separate line.
Is the name of an input parameter to which you want to pass a value.
Is the value you are passing to an input parameter.
SQL SELECT PERSONNEL_ID, NAME, BIRTH, SALARY FROM IWAYIVPD WHERE PERSONNEL_ID_FROM = '11111111' AND PERSONNEL_ID_TO = '11211111' AND SALARY != 0; END
iWay Software |