Answer Posted / poornima.t
NULL INDICATOR IS USED TO FIND OUT WHETHER
THE COLUMN IN THE TABLE IS NULL OR NOT NULL...
IN COLUMN IF THE VALUE IS NOT SPECIFIED THEN IT IS
TREATED AS NULL VALUE...
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
if we want to use a gdg which is already created by some job, then how to use the reference of the last generation in a jcl?
I have a cobol db2 program(PGM A) where other program (PGM B) will call this program and passes some 50 fields data to PGM A. PGM A has some layout in which it receives the data from PGM B. And this layout has been copied in the linkage section pf PGM A. After getting the data, PGM A writes the data in a flat file in the same layout which it receives from PGM B. PGM B is a simple COBOL pgm. Please provide a JCL to run these programs.
How do you submit a job for execution?
Name what parameter directs the output of the job log dataset?
How to compare two files in SYNCSORT and on the mismatch record should be deleted from second file.
What happens if both JOBLIB & STEPLIB is specified ?
I have 60 steps in the JCL and want to Execute Only First from PROC by overriding in JCL ?
Explain the function of dd disp parameter?
have in 100 records in a file i want to read first 3 records and skip next 3 records and agan i want to read 3 records and again i want to skip 3 records... run a loop from record one to 10 evaluate i/3 if comes even then skip else write to output file
What do we mean by 'Virtual storage' for a dataset and for a JOBSTEP ? What is the significance of the following statement for a programmer 'Virtual storage results in program addresses being independent of the addresses that actually exist in a computer' ?
what is use of dsn parameter in dd statement?
Is their any limit for data sets?
how you will the direct the data to spool using sysout option?
What is catelog procedure and how many catelog procedure to use in one job?
what disp parameter we mention for creation of temporary dataset so that we can use it in later steps?