Extract the data's from Dataset into two datasets
Posted: Tue Mar 28, 2017 2:07 pm
Dear all,
Hope all are doing great.
I am having a dataset which contains the 100 records.
I want to split this dataset into two dataset.
Input dataset:
Am passing value to JP0 as 22.03.2017 and sort card as below
Am getting syntax error while executing the above sort.
Output dataset:
I want output dataset as below
Is it possible to format the output like with include statement?
Thanks in advance.
Sorry for any mistake in the question.
Hope all are doing great.
I am having a dataset which contains the 100 records.
I want to split this dataset into two dataset.
Input dataset:
=COLS> -1----+----2----+----3----+----4----+----5----+----6----+----7----+
000001 +--------------------------------------------
000002 1_| XXX | 22.03.2017 | 0
000003 2_| YY | 21.03.2017 | 0
000004 3_| ZZZ | 20.03.2017 | 1
000001 +--------------------------------------------
000002 1_| XXX | 22.03.2017 | 0
000003 2_| YY | 21.03.2017 | 0
000004 3_| ZZZ | 20.03.2017 | 1
Am passing value to JP0 as 22.03.2017 and sort card as below
SORT FIELDS=COPY
OUTFIL FILES=01,INCLUDE COND=(54,10,CH,EQ,JP0)
OUTFIL FILES=02,INCLUDE COND=(75,1,CH,EQ,C'1')
OUTFIL FILES=01,INCLUDE COND=(54,10,CH,EQ,JP0)
OUTFIL FILES=02,INCLUDE COND=(75,1,CH,EQ,C'1')
Am getting syntax error while executing the above sort.
Output dataset:
I want output dataset as below
=COLS> ----+----1----
000001 XXX 22.03.2017
000001 XXX 22.03.2017
Is it possible to format the output like with include statement?
Thanks in advance.
Sorry for any mistake in the question.