If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?
RBS,
1 14068If the COND parameter is specified in both the JOB and EXEC statements, which one will take precedence? If JOB takes priority and if all the conditions evaluate to false, then will the conditions on the EXEC step be evaluated next?
4 19471If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?
2 12498Suppose a proc step has a DD statement like //ABC DD DSN=TEST.FILE1,DISP=SHR DSN=TEST.FILE2,DISP=SHR and the above DD name is overridden from the JCL as given below //procstepname.ABC DD DSN=TEST.FILE3 - Will the DD statement now have just TEST.FILE3 or it will be TEST.FILE3 and TEST.FILE2? Suppose if it is overridden twice like //procstepname.ABC DD DSN=TEST.FILE3 //procstepname.ABC DD DSN=TEST.FILE4 Will this give a JCL error? If not, what will be final output?
2 13018a. Can the OPTIONAL clause in COBOL only be coded for input files? b. If it is coded for files opened in OUTPUT, I-O or EXTEND mode, will it give a compilation error? c. If there are no compilation errors and if such files are not coded in the JCL, will the OPEN statement run fine when these files are opened? d. How will a WRITE statement work for the above files?
2 13586If the proc stepname is excluded while overriding the COND, TIME, REGION and PARM parameters while calling the proc, will the override only apply to the first step in the proc or all the steps for all the above parameters?
2 12691There are 2 steps in a JCL. If the first step abends due to system or user abend and the second step has COND specified as EVEN or ONLY, will this step still be executed inspite of the abend in the previous step?
2 10281What is basic difference between "DIRECTORY" and "PDS" in IBM MAINFRAME.How to define a DIRECTORY and what is the structure and defination for the same?
2 14330Hi Folks, In the Map, one field is having attribute FSET. I want to FSET OFF of that field through program. Can any body let me know the process? Thanks Praveen
3 8491If -1 is moved to length for more than one field on a map, where will the cursor be positioned?
6 10082
what is the probability of a complete system distortion under high end low performing multiprocessor job?
What is the use of symbol // in jcl?
What is the purpose of store statement?
how can you check if a file is empty using jcl?
What is dynamic transaction backout?
Can we use DISP=SHR in output file in JCL
Name and explain the location modes?
What does the 'cebr:cics' transactions do?
We can use PASS with permanent datasets also. THEN Which is the condition in which we may use PASS (instead of KEEP) with permanent data sets, while there is no need to specify UNIT and VOL for them like temporary data sets (in cas we use KEEP for permanent data sets) ?
Can you define attribute byte?
What is a run unit in idms?
Name some translator and compile options and explain their meaning?
Define predicate?
How do you eliminate duplicate values in db2?
Which mode is used to operate the sequential file?