What are ISOLATION LEVELS? Where do we need to specify them in compiling JCL (Exactly which statement and what is syntax for it)?
2 9485TIME parameter in JOB statement or EXEC statement specifies What type of time (CPU time or execution time)?
CTS,
5 1548915. Secondary indexes can be used with following databases a. HSAM,HISAM,HIDAM b. HIDAM, HISAM c. HDAM, HISAM, HIDAM d. All the above
2 8182What are the special considerations of the PROCOPT field based on the type of operation your program performs
3 8254What are the ways to mapping external control block? a. ENTRY b. PROCEDURE DIVISION USING c. CALL ‘DLITCBL’ d. ALL ABOVE e. A & B
EDS,
4 11292Write the format of program starting from identification division for checkpoint restart logic.
1 7708Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
IBM,
2718I am new to rexx db2 ,can anyone help me by expalinin how to code the db2 queries using rexx,and also plz send some link and examples using db2 queries.
3 11751
Receive consists of buffer option in it. What is the significance of this option?
What is dl/i?
Explain the hierarchy levels in jcl?
Kindly specify the pic clause for the hhmmss type of data fields?
What are 77 levels used for?
What is multi row fetch in db2?
explain how do you define a gdg in vsam?
Portfolio analysis application is an example of?
What is the maximum number of columns in a db2 table?
What are the objectives of dbms in ims?
1) SORT FIELDS=(20,4,CH,D,10,3,CH,D) OUTREC FIELDS=(7:20,4,C' FUTURE ',20,2,10,3,1Z,1,9,13,7, 24,57,TRAN=LTOU,6X'FF') This example illustrates how a fixed-length input data set can be sorted and reformatted for output. The SORTIN LRECL is 80 bytes. The reformatted output records are fixed length with a record size of 103 bytes. SOLRF (the IBM-supplied default) is in effect, so unless the SORTOUT LRECL is specified or available, it will automatically be set to the reformatted record length of 103. in the above example i have some doubts that a) sort fields=(20,4,CH,D,10,3,CH,D) -what exactly it does and this fields related to output record fields or input record fields b)outrec used to refprmat the records after sorting that means could please reply me as soon as possible Thanks. Venkat
Name the lockable units in DB2?
What is house keeping in assembler?
What is data manager?
How jcl is used for testing batch programs?