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
How can the attributes of one sms dataset be copied to another dataset?
what disp parameter we mention for creation of temporary dataset so that we can use it in later steps?
How to pass the parameter in parm using linkage section ? (syntax)?
Explain how can an in-stream dataset be terminated?
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
What are steplib and joblib?
How do you submit a job for execution?
How do you create a temporary dataset?
Explain how can the disposition of sysout datasets be set for an entire jobstream?
How to code these statements in JCL: CLEANUP INITIAL(NO) RESTART(NO) DYNALLOC(NO) job definition..?
Brief description of inline procedure of jcl.
when does a dataset go uncataloged?
by using cond parameter maximum 8 cond can be coded in single cond means ?explain
Is automatic restart possible in jcl? If yes, how?
What are the difference between jcl and jes?