Specify the CICS command used to read a VSAM record starting with prefix F. Code all the relevant options?

Correct Answer: EIBRCODE

Correct Answer: You must code EXEC CICS ASSIGN with the OPENID option

Correct Answer: PCT (Program Control Table) - Defines each transaction containing a list of valid transaction identifiers (transid) where each transaction is paired with its matching program PPT (Program Processing Table) - Contains a list of valid program names and maps and whether a current version is in the CICS region or needs to be brought in as a new copy FCT (File Control Table) - Contains a list of files known to CICS, the dataset name and status (closed/open, enable/disabled) TCT (Terminal Control Table)- A list of the terminals known to CICS

Correct Answer: If any one want to restrict Trans-ID to single user, enter trans-id with ENQ It won't allow any one else to use the same trans-id

Correct Answer: The LOAD command retrieves an object program from disk and loads it into main storage - it's primarily used for a constant table that will be available system-wide

Correct Answer: Use the SORTWK01, SORTWK02, dd names in the step Number of sort datasets depends on the volume of data being sorted, but a minimum of 3 is required

Correct Answer: Open for INPUT, OUTPUT, I-O, EXTEND 1INPUT : for read only purpose 2OUTPUT : for write only purpose 3EXTEND : for appending records 4I-O : for read and write(using EXTEND) purpose

Correct Answer: Syntax: SORT file-1 ON ASCENDING/DESCENDING KEY key USING file-2 GIVING file-3 USING can be substituted by INPUT PROCEDURE IS para-1 THRU para-2 GIVING can be substituted by OUTPUT PROCEDURE IS para-1 THRU para-2 file-1 is the sort workfile and must be described using SD entry in FILE SECTION file-2 is the input file for the SORT and must be described using an FD entry in FILE SECTION and SELECT clause in FILE CONTROL file-3 is the outfile from the SORT and must be described using an FD entry in FILE SECTION and SELECT clause in FILE CONTROL file-1, file-2 & file-3 should not be opened explicitly INPUT PROCEDURE is executed before the sort and records must be RELEASEd to the sort work file from the input procedure OUTPUT PROCEDURE is executed after all records have been sorted Records from the sort work file must be RETURNed one at a time to the output procedure

Correct Answer: DB2 precompiler (if embedded sql used), CICS translator (if CICS program), COBOL compiler, Link editor If DB2 program, create plan by binding the DBRMs

Correct Answer: Supply the DD cards just as you would for files referred to in the main program