some interview questions regarding cics-db2

srimsc_ibmmainframes · New User Joined: 17 Feb 2004 Posts: 19 Location: pune

plz answer the following questions which were asked in an interview

1.for each cics pgm the translator inserts some kind of data for internal houskeeping what's that data(i think DFHEIBLK N DFHCOMMAREA)

2. What is CURRENT DATA parm in BIND?

3. After changing the existing MAP which is already being used by some pgm what should b done?

4. 02 ws-field pic x(20)
move 'infile' to ws-field
------------
procedure division
open input ws-field

so here can we open the file successfully in input mode?

should we declare ws-field in FILE-CONTROL?

5. what info does the trailer contain?
a.end of run,count of records
b.high values
c.low values....

thanx in advance

sivatechdrive

Hi friend

here are some answers for ur queries

1.------------
Command Level Language Translator(Translator) produces 2 outputs the Translator Listing (SYSPRINT) and Temporary Dataset (SYSPUNCH).
SYSPUNCH is the input Dataset for the Compiler or Assembler.
DFHEIB copy book will be inserted into the Translated output automatically and EXEC CICS commands are commented, after the Comments, move Statement and some Calls for Command Interface Programs are inserted.

2.-----------------------------
Use this bind option to force block fetch for ambiguous queries
DB2 uses two different methods to reduce the number of messages that are sent across the network when fetching data with a cursor
http://publib.boulder.ibm.com/infocenter/dzichelp/index.jsp?topic=/com.ibm.db2.doc.apsg/bjnqmstr332.htm

3.-----------------------------
if we change the existing map ,we also need to change the corresponding application program & get the new copy using CEMT

4.-------------------------------
we get the error as u cannot pass the
file name through a variable
Syntax:
OPEN mode file-name

mostly filestatus 35
we need to declare the file "infile" in
file-control & also in filesection

Regards
siva