inserting record in to an empty file using sort

raak · Posted: Fri Aug 18, 2006 10:46 am

hi

this is my query.. i have aa empty flat file in to which i want a single record to be inserted. this record is say XXXXX.

i tried the following in my sort card

SORT FIELDS=COPY
OUTFIL OUTREC=(C'XXXXX')

my sortin and sortout will be the same flat file to which i want this record to be inserted.
i tried the above method, but its not working..

can anyone suggest me how to do this ?

thanks in advance

murmohk1 · Posted: Fri Aug 18, 2006 11:14 am

Hi,

OUTREC is useful for reformatting the input record. Since your sortin (input) file is empty, I feel 'outil outrec' is useless.

Put your record as INSTREAM data to SORTIN like below -

//sortin dd *
your record
/*
//sortout dd dsn=your flat file......

Correct me, if Im wrong.

Thanks,
Murali Mohan K

raak · Posted: Fri Aug 18, 2006 11:28 am

HI murali

what you said is correct.. u can pass the data as instream.. but this is not allowable according to the coding standards followed in our shop.. that is why i wanted a sort card to do this..

any suggestions anyone....................

sril.krishy · Posted: Fri Aug 18, 2006 12:44 pm

Hi,
Put your data in a file and use that one insted of Instrem data.

Thank you
Krishy

raak · Posted: Fri Aug 18, 2006 1:03 pm

no sir

i want the data to be written using a sort card only...
is there any option in sort card to do that... thatz my question

sril.krishy · Posted: Fri Aug 18, 2006 1:45 pm

I believe it is not possible to copy a record(s) as you are expecting thru SORT.Either you need to use the instream data or you need to have the data into a file to insert the record(s).

Thank you
Krishy

Frank Yaeger · Posted: Fri Aug 18, 2006 10:05 pm

raak,

What is the RECFM and LRECL of your file?

raak · Posted: Mon Aug 21, 2006 11:17 am

LRECL is 80 and RECFM is FB.

Frank Yaeger · Posted: Mon Aug 21, 2006 8:34 pm

raak,

Here's a DFSORT job that will do what I think you're asking for:

raak · Posted: Tue Aug 22, 2006 5:39 pm

thanx ...its working fine..

anyway i found out one more method.. this is also working...

SORT FIELDS=COPY
OUTFIL HEADER1=(C'XXXX',76X),REMOVECC

is there any problem in using this one ?
anyway thanx for the helping hand sir....

Frank Yaeger · Posted: Tue Aug 22, 2006 7:42 pm

You may actually run into problems using COPY rather than SORT when you have the same data set for input and output. With SORT, the input and output are NOT open at the same time so problems won't occur. With COPY the input and output are open at the same time so problems can occur. For that reason, you really should use SORT rather than COPY when you have the same data set for input and output, and that's why I used a SORT statement rather than a COPY statement.

Since your file is initially empty, you can probably get away with using COPY, but I'd still suggest using SORT when you have the same data set for input and output as it's a good habit to get into.

Whether you use HEADER or TRAILER to insert the record doesn't matter.

sril.krishy · Posted: Tue Aug 22, 2006 11:54 pm

Hi Frank,
Thank you for providing a new learing !

Thanks
Krishy