karthi_ind
Active User
Joined: 24 Feb 2004 Posts: 131 Location: Chennai
|
|
|
|
hi
i hve a doubt. I hve a dataset in which records start with
1, 2 and 2 are thre, i want to retrieve only those records start with
1 and store in another dataset. How can i do ths ?
Can anyone help???
Col1 col2
1 df
2 dr
3 ew
1 rr
2 ss
1 pp
o/p will be ( in a new dataset)
Col1 Col2
1 df
1 rr
1 pp
thanks in advance
karthi G. |
|
sandip_datta
Active User
Joined: 02 Dec 2003 Posts: 150 Location: Tokyo, Japan
|
|
|
|
Karthi,
Following SORT will give you the result -
Code: |
//SORT01 EXEC PGM=SORT
//SORTLIB DD DSN=SYS1.SORTLIB,DISP=SHR
//SORTWK01 DD UNIT=SYSDA,SPACE=(CYL,(5,5),RLSE)
//SORTWK02 DD UNIT=SYSDA,SPACE=(CYL,(5,5),RLSE)
//SYSOUT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SORTIN DD DSN=Your Input file,DISP=SHR
//SORTOUT DD DSN=Your output file
//SYSIN DD *
SORT FIELDS=COPY
INCLUDE COND=(1,1,ZD,EQ,1)
/*
|
|
|