Describe the EXEC statement, its meaning, syntax and keywords?
Answers were Sorted based on User's Feedback
Answer / mrunmaya
Guest I think in the syntax there should be stepname instead
of jobname.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / guest
The EXEC statement identifies the program to be executed via
a PGM= program name keyword. Its format is //jobname EXEC
PGM= program name. The PARM= keyword can be used to pass
external values to the executing program.
| Is This Answer Correct ? | 3 Yes | 1 No |
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above. 1 What is the maximum number of tables that can be stored on a Partitioned Table Space ? 1 what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names Accenture 5 Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code? 6 When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing? 2 how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE IBM 7 max number of columns in a db2 table? 6 What is package versioning? Please give an example. 1 What is the picture clause of the null indicator variable? 6 How do you filter out the rows retrieved from a Db2 table ? 1 What is DB2 (IBM Database 2)? 3 Can any one tell me about Restart logic in DB2.
How to copy VSAM files without using REPRO
i have 5 steps to execute in that i want to skip 3nd step and start execute from forth step how can u do this.
Is acct parameter mandatory?
Step 1 RC 4 Step 2 Step 3 I want to know the COND parameter which can be coded in step 2 or 3. Step 2 should be executed based on Step 1 RC and Step 3 should not be executed based on step 1's RC
I have 15 flat files. each record in the files have the monthly salary for 12 months with the employee number. Now I want to concatenate the 15 files such that for the employee numbers that are common the o/p file should have only one record and the salaries should be concatenated to that record. How can we do it with JCL?
i want to see the jobs in skeleton queue in diff region. (eg. 7 regions are running means , i want to see all the jobs in 7 regions which are in skel queue using 1 command)
HOW TO CONVERT VARIABLE BLOCK TO FIXED BLOCK ?
The disp in the JCL is MOD and the program opens the file in OUTPUT mode. What happens ? The DISP in the JCL is SHR and the program opens the file in EXTEND mode. What happens ?
Explain about REXX
What happens if both JOBLIB and STEPLIB is specified ?
A PROC has five steps. Step 3 has a condition code. How can you override/nullify this condition code?