Answer / madhu s reddy

.
.
//SYSIN DD *
INREC FIELDS=(5,10,15,2,23,4)
SORT FIELDS=(11,3,ZD,A)
OUTREC FIELDS=(1,10)
/*
.
.

INREC option is used to select the part(s) of record from
input file for sorting(ie, vertical split of records).

OUTREC option is used to select the part(s) of record from
sort file and is copied into output file.

Answer / challa srinivas

In short,INREC i used before SORT and OUTREC is used after SORT.

In JCl which of this activities get executed if act002 abnormally terminates //job001 job ......... //act001 exec pgm=cobo01 //act002 exec pgm=cob02, cond=(01,le) //actoo3 exec pgm=cob03, cond=only //actoo4 exec pgm=con04

3 Answers   Patni,

---

If i have defined an temperory dataset in step2, how can i call back or use the same dataset in step5 of the same job

4 Answers   UST,

---

What is model dataset label(Model DSCB)?

1 Answers  

---

What do you know about jcl?

0 Answers  

---

Matching Logic in Jcl not in cobol.Could any one please answer this question

0 Answers  

---

How do you restart a step in JCL?

12 Answers   HSBC,

---

I've one sequential file, that file size is LREC=100 (File contain Records like 1 to 100). Now I was increase the file size is LREC=102. My question is I want insert 00 (Two Zeros) in to the new file (That output file looks like : 00123 up to 100). How will write the SORT card in JCL. Please let me know.

2 Answers   Syntel,

---

How to get the last but one duplicate record of the file using Sort?

2 Answers   Fidelity,

---

What is the use of IEBGENER ?

2 Answers   Cap Gemini, Wipro,

---

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.

2 Answers   Cap Gemini,

---

How to pass the temp dataset form one JOB step to another?

6 Answers   IBM,

---

what is the use of IEBGENER utility?

0 Answers  

---