Searching for "ING"

Q:

What are the steps you go through while creating a COBOL program executable?

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.

Report Error

View answer Workspace Report Error Discuss

Q:

How do you sort in a COBOL program? Give sort file definition, sort statement syntax and meaning.

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.

Report Error

View answer Workspace Report Error Discuss

Q:

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

Answer

EXEC CICS READ


DATASET('FILENAME')


INTO(data-area)


RIDFLD(data-area)


KEYLENGTH(1)


GENERIC


LENGTH(WK-LEN)


END-EXEC.

Report Error

View answer Workspace Report Error Discuss

Q:

What are different ways of Initiating Transaction in CICS?

Answer

The following are the ways of initiating a CICS transaction.


1. By entering Transaction Id


2. By Start command


3. By Return Trans Id (as in pseudo - conversation)


4. By Registering Tran ID in plt so that it will be automaticaly dusring CICS start


5. By ATI (Automatic task initiation)


6.PF & PA keys as defined in PCT

Report Error

View answer Workspace Report Error Discuss

Q:

What CICS command are used to read a VSAM KSDS sequentially in ascending order?

Answer

READNEXT reads the next record from a browse operation for any of the three VSAM files.

Report Error

View answer Workspace Report Error Discuss

Q:

In terms of DB2 indexing, what is the root page?

Answer

The simplest DB2 index is the B-tree and the B-tree's top page is called the root page. The root page entries represent the upper range limits of the index and are referenced first in a search. 


 

Report Error

View answer Workspace Report Error Discuss

Q:

When does the SQL statement gets executed when you use cursor in the application programming?

Answer

SQL statement gets executed when we open cursor


 

Report Error

View answer Workspace Report Error Discuss

Q:

File contains 5 records say D,E,F,C,A-I want to copy D and A records only by using file-aid?

Answer

Go to file-aid copy option.Enter the from dataset to be copied and to dataset to which you want to copy.go to options. Enter 0 at Initial records to skip field.Then enter 3 at the no of records to skip field and 1 to no of records to select.press enter and PF3.

Report Error

View answer Workspace Report Error Discuss