Copy data from one file to other using SORT

sreekanth1984 · New User Joined: 23 Mar 2010 Posts: 22 Location: Bangalore

Hi,

I have a requirement where I need to copy data from one flat file other flat file using SORT statement. Before copying the data I have to check record count in the input file. If the record count is greater than 1 then I should copy data from input file to output file.I could get the record count using SEQNUM, but I am not able to compare the count with 1. Please provide me sort steps to acheive this.

Please let me know any details required.
Thanks
Srikanth

dbzTHEdinosauer · Posted: Tue Nov 09, 2010 3:11 pm

only detail i would like to have is
why did you not search the forum?

this type of thing (actually exact requirement)
has been discussed before,
since the originating process did not delete the file in the first place.

one question: what kind of output file are you to have if there is only 1 record in the input file?

sreekanth1984 · New User Joined: 23 Mar 2010 Posts: 22 Location: Bangalore

This requirement is posted only after extensive search is done in the forum....

And for the question raised, in case of input file contain only one record I don't want to write anything to output file.

Thanks
Srikanth

dbzTHEdinosauer · Posted: Tue Nov 09, 2010 3:21 pm

our definitions of 'extensive' differ.

sreekanth1984 · New User Joined: 23 Mar 2010 Posts: 22 Location: Bangalore

Can anyone please provide solution for this.....?

expat · Posted: Tue Nov 09, 2010 3:45 pm

You can use IDCAMS to determine if two or more records exist in the file, and then conditionally execute the sort step to perform the copy.

Not sure if your sort product will be able to do this in just one step, but then we do not know the sort product or release level that is installed at your site.

enrico-sorichetti · Posted: Tue Nov 09, 2010 3:51 pm

sreekanth1984 · New User Joined: 23 Mar 2010 Posts: 22 Location: Bangalore

Thanks Expact, I could do this using IDCAMS. Through IDCAMS I could check for input file is empty or not. But I want to check no. of records in the file for specific count like if the no. of records in the input file is 5 then I should copy data from input file to output file. Hence I looking for the SORT card to accomplish this...

enrico-sorichetti · Posted: Tue Nov 09, 2010 4:13 pm

Skolusu · Posted: Tue Nov 09, 2010 11:30 pm

sreekanth1984,

use the following DFSORT JCL. The first step sets a return code of 4 if there is just 1 record and return code of 0 if it has more than 1 record. The second step actually copies the file based on the return code.

sreekanth1984 · New User Joined: 23 Mar 2010 Posts: 22 Location: Bangalore

Thanks Skolusu. I have run the JCL mentioned for different input files containing single record, more than one record and for some empty files. In each case STEP0100 is executing with cond code 000. step0200 is executing in all the cases as condition mentioned is false and copying all the input records to output reocrds.

I have mentione Output file in the SORTOUT statement of STEP0200, which was SYSOUT=* in the JCL provided by you.

The JCL provided is not serving my requirement.

Please let me know for any corrections.

Thanks
Srikanth

dick scherrer · Posted: Wed Nov 10, 2010 10:52 am

Hello,

Post all of the informational messages including message ids for a run that does not do what you want.

Skolusu · Posted: Wed Nov 10, 2010 10:33 pm

gcicchet · Posted: Thu Nov 11, 2010 9:25 am

Hi Kolusu,

I noticed with your example that you are reading the entire file to identify whether more than 1 record exists in the input file, ie. if the file has millions of records there seems to be many unnecessary reads.

Would this be a better option

sreekanth1984 · New User Joined: 23 Mar 2010 Posts: 22 Location: Bangalore

JCL used:

In the previous post I have given STARTREC=1,ENDREC=200 which is changed as STARTREC=2,ENDREC=2 and the outputs are below.

Apologies for incorrect data provided in the previous post.

dick scherrer · Posted: Thu Nov 11, 2010 10:15 am

Hello,

You do realize you are not using DFSORT . . . You are using Syncsort.

Topic moved to proper part of the forum.

d

dick scherrer · Posted: Thu Nov 11, 2010 10:16 am

Hi Gerry,

Good catch

d

gcicchet · Posted: Thu Nov 11, 2010 10:52 am

Hi Srikanth,

try this for SYNCSORT

expat · Posted: Thu Nov 11, 2010 11:50 am

Why oh why do I bother to ask for the information that identifies the sort product and release level. It usually gets ignored and people end up wasting their valuable time working on inappropriate solutions because the OP is just too dumb or lazy to respond to questions designed to eliminate this.