wht happens if cond=true ? pls give me with an example ?
Answers were Sorted based on User's Feedback
Answer / shailendra
that individual step in which this cond parameter mentioned
this will not execute (bypass this step)
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / muttaiah
I guess there is no such Cond value as True..
We have only Even & ONly for Cond parameter but not True.
Please clarify the question
| Is This Answer Correct ? | 0 Yes | 1 No |
Write a jcl to execute a job by 7 a.m on Jan 20,1986 ?
is there any way to execute more than one proc in the same exec statement at the same time..?
what is the general use of PARM? Give an explanation about the system defined parameters that could be passed through this PARM like XREF,LIST,LET,APOST,RENT etc..
describe the dd statement,its meaning,syntax and keywords?
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.
Give the syntax of job specifying jcl statement.
What is the difference between joblib and jcllib statements
Please go thru the below points and let me know how to code this. 1. Sort the input dataset for the condition : Starting position is 37,length of the field is 13 based on character and in the ascending order , starting from position 25 length of 12 ,character and in the ascending order. Use a temporary dataset to hold the sorted file. 2. Use the temporary file created in the above step as the input for the next step. The next step is to execute a program and produce an output file. Use the temporary file created in the above as work file 1 and the output of the file to be created in this step work file 2.Also, pass a parameter to the program that is to be executed in this step. The parameter should have the current date in YYYYMMDD format. For the sake of convenience, you can use the below Job Name : Sample1 Input DSN : PCABDT11.CABD.TEST.INPUT Temporary DSN : Sort1 Output DSN : PCABDT11.CABD.TEST.OUTPUT Program Name : SAMPLE Thanks in Advance for your response.
How do you create a temporary dataset?
How do you skip a particular step in a proc/JOB?
I have a Symbolic Parameter which can have a value say 01 or 02 etc. Now consider i have another Symbolic parameters which is used to get 3 digit code of months (JAN, FEB, etc) but for that i need to check the first symbolic parameter's value and provide its corresponding month's name in the second symbolic parameter. Say IF sym1 = 01 then sym2='Jan' ENDIF etc... In JCL, IF condition is used for RC, ABEND purposes of a step etc. When i use Symbolic parameter in IF clause it is showing Error message. Is there a way to get the above result possible in JCL. If you could provide me with an example, i would understand it better.
Explain how can the attributes of one sms dataset be copied to another dataset?