Reformat the dataset

KS · New User Joined: 28 Feb 2006 Posts: 91 Location: Chennai

I need to reformat a dataset.

Following is the data in my dataset1.

Dataset1:

Date - xxxx/xx/xx
Page - xx
Todays report details

xxx xxx xxxxxxxxxxxx xxxxxx xxxx xxxxx
-------------------------------------------------------

xxx xxx xxxxxxxxxxxxx xxxxxxx xxxx xxxxx
xxx xxx xxxxxxxxxxxxx xxxxxxx xxxx xxxxx
xxx xxx xxxxxxxxxxxxx xxxxxxx xxxx xxxxx
xxx xxx xxxxxxxxxxxxx xxxxxxx xxxx xxxxx
xxx xxx xxxxxxxxxxxxx xxxxxxx xxxx xxxxx
xxx xxx xxxxxxxxxxxxx xxxxxxx xxxx xxxxx

I need these data to be written to another dataset2.It should have th following details only :

Dataset2:

xxx xxx xxxxxxxxxxxxx xxxxxxx xxxx xxxxx
xxx xxx xxxxxxxxxxxxx xxxxxxx xxxx xxxxx
xxx xxx xxxxxxxxxxxxx xxxxxxx xxxx xxxxx
xxx xxx xxxxxxxxxxxxx xxxxxxx xxxx xxxxx

Can you please help?

Regards,
Neena

krisprems · Posted: Mon Jul 09, 2007 8:12 pm

KS

If you are sure that the actual data starts from 4th or 5th or nth line then you can use STARTREC feature in SORT and copy the required information.

like

Frank Yaeger · Posted: Mon Jul 09, 2007 8:16 pm

You need to be more specific about what the data looks like and what you want.

It appears that you just want the data records, not the headings, but it's difficult to tell for sure since you show 6 data records in the input file but only 4 data records in the output file. Do you really want to remove some of the data records? If so, based on what "rules"?

We can use DFSORT's OMIT statement to remove the records you don't want, but we need to specify exact conditions for the records to be removed, e.g. 1,4,CH,EQ,C'Date'. To do that, we need to know what the records actually look like. So please show an example of your input records and expected ouput records with the actual values. Also, give the RECFM and LRECL of the input file.

Are the blank records you show actually in the data set? If not don't show them in the new example.

KS · New User Joined: 28 Feb 2006 Posts: 91 Location: Chennai

KS · New User Joined: 28 Feb 2006 Posts: 91 Location: Chennai

Hi all..

Thanks for your reply.
Above is the dataset.

I want to remove the DAte,PAge and the topic header and write to a different dataset.

Kindly help

Regards,
KS

krisprems · Posted: Mon Jul 09, 2007 9:04 pm

KS

Since you want to skip first 3 lines, you can use this sort card

KS · New User Joined: 28 Feb 2006 Posts: 91 Location: Chennai

i tried the above code but am not getting the result
am geeting an error

I gave like this

//S025T EXEC MSSORT,MODE=TEST
//SORTIN DD DSN=DATASET1,DISP=SHR
//SORTOUT DD DSN=DATSET3,DISP=SHR
//SYSIN DD *
SORT FILEDS=COPY,STARTREC=4

i got and abend.what is the mistake am doing?

i got the following error :

SORT STATEMENT : SYNTAX ERROR
PLEASE HELP.

William Thompson · Posted: Mon Jul 09, 2007 10:12 pm

krisprems · Posted: Mon Jul 09, 2007 10:22 pm

KS
try this

KS · New User Joined: 28 Feb 2006 Posts: 91 Location: Chennai

thats all the error its throwing .

KS · New User Joined: 28 Feb 2006 Posts: 91 Location: Chennai

Its working fine..
Thank you so much.

Thanks to one and all who replied.

Regards,
KS

Frank Yaeger · Posted: Tue Jul 10, 2007 1:03 am

Krisprems,

You're getting the syntax confused for different control statements.

The OPTION COPY or SORT FIELDS=COPY statement has SKIPREC=n and STOPAFT=n.

The OUTFIL statement has STARTREC=n and ENDREC=n.

Please, please test your control statements before you post them so we don't have to have a series of "try this - it doesn't work - try this" posts which just confuse people.

Frank Yaeger · Posted: Tue Jul 10, 2007 1:06 am

krisprems · Posted: Tue Jul 10, 2007 10:30 am

Frank

Frank Yaeger · Posted: Tue Jul 10, 2007 8:37 pm

Oh, I see. I didn't realize those lines weren't part of the input (the poster could have said that). I wish people would explain what they want clearly to avoid confusion.