if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)
3 7364Please 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.
2 4801consider the fallowing 77 stat pic 9. 88 male value 1,2,3. 88 female value 4 through7. what will be the value of stat a) set male to true. b) set female to true.
5 7335what will be the output when a)pic 9(6)value 000178 is moved to pic ***,***. b)pic 9(5) value 57397 is moved to pic $$,$$9.
5 6947I 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?
1 4806
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Differentiate between cs and rr isolation levels? Where do you specify them?
What is the difference between external and global variables in COBOL?
Mention the types of job control statements?
Explain the difference between a schema and a subschema in idms?
how would you create a temporary dataset? And where will you use them?
What is cursor with hold option in db2?
What is dbd?
IF I mention stop run in CICS what happens?
How does jcl specify the job to the operating system?
How IBM framework work?
what is use of dsn parameter in dd statement?
What is the function of dbctl?
difference between tsq and tdq?
Explain how can the submitting users racf authority be overridden in a job stream?