Answer / kk

hi,

Using dfsort

//step10 exec pgm=sort
//sirtin dd dsn=userid.qulifier.psname,disp=shr
//sortout dd dsn=userid.qulifier.psname,disp=shr

sort fields=(starting position,length,cha,asc/dsc)
stopaft=10

now u get result sortout ps.

Answer / balasukumar

//SORTIN DD DSN=INF1
//SORTOT DD DSN=OTF
//SYSIN DD *
SORT FIELDS = COPY
SKIP=0
STOPAFT=10
/*

Answer / haleema

Keep first 10 sorted output records.
SUBSET FROM(IN1) TO(OUT1) OUTPUT KEEP FIRST(10)USING(CTL1)
//CTL1CNTL DD *
SORT FIELDS=(11,5,CH,A)
/*
Do this using ICETOOL job.

Answer / srinivasa yadav

//sysin dd *
sort fields=(starting postion,length,data-type,order)
skip rec=0
stop rec=10
/*

and also we can use file-aid tool. in file-aid
there is an option 3.3

Answer / girish kumar

just write like this

sysin dd *
sort fields=copy
stop after=10
/*
//
i tryed it's working

What is the DD statement for a output file?

3 Answers  

---

My JCL have five steps & I created new versions of GDG in first step through fourth step & fifth step I was refered Step one GDG version. My JCL got abend at 4th step and how I can restart my JCL Please let me know the answers. //STEP1 EXEC GDG1(+1) DISP=(NEW) //STEP2 EXEC GDG1(+2) DISP=(NEW) //STEP3 EXEC GDG1(+3) DISP=(NEW) //STEP4 EXEC GDG1(+4) DISP=(NEW) //STEP5 EXEC GDG1(+1) DISP=(OLD)

11 Answers   HCL, IBM, L&T, TCS,

---

describe the dd statement,its meaning,syntax and keywords?

1 Answers  

---

What is GDG and what is the maximum limit of versions that can be created?

9 Answers   Convergys,

---

If Name is NOT given for a JOB statement, then will it give error or installation will supply it for the JOB ?

1 Answers   IBM,

---

---

IN DFSORT sum fields=none is usec to remove duplicates.how to write the duplicates in another dataset?

2 Answers  

---

How can a fb file convert to vb file using sort program?

0 Answers  

---

What do you understand by the terms: joblib and steplib?

0 Answers  

---

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,

---

what is the difference between return code and maxcc?

2 Answers   iGate,

---

how to resolve soc-7 ? please tell me

3 Answers   IBM,

---

how to code instream data in procedure?

3 Answers  

---