I have a file in which there is a field called claims

Deepti Bhopatkar · New User Joined: 11 Apr 2006 Posts: 8 Location: Pune

Hi ,

I have a file in which there is a field called claims and there are other fields. I have to put a comma after each value that occurs in claims feild?
I have to put this comma in all the lines except the last one.eg,

hikaps14 · Active User Joined: 02 Sep 2005 Posts: 189 Location: Noida

Hi,

i think this can be easliy done thru OUTREC if claims field is of fix length

eg claims field is of length =6

SYSIN DD *
SORT FIELDS=COPY
OUTREC FIELDS=(1:1,6,C',',8:7,73)

i dont know exactly how to skip this action for last record .
plz check this out if it helps u .

Thanks ,
-Kapil.

Deepti Bhopatkar · New User Joined: 11 Apr 2006 Posts: 8 Location: Pune

Hi ,

Let me modify the query .
1. The addition of comma can be done thru outrec.
2. The omission of last row can be achieved by STOPREC.
However the problem that now i am facing is that it is a productionised job and hence the count ( i.e no of records in the file ) will change daily ?
hence i cant hardcode any value for stoprec in the sortcard nor i can give any symobolic.

Hope this summarises the problem.

Thanks and Regards,
Deepti

rajandhla · Posted: Thu May 18, 2006 3:03 pm

Is the file contains key on which we can sort

Frank Yaeger · Posted: Thu May 18, 2006 8:58 pm

Deepti,

Here's a DFSORT job that will do what you asked for. I assumed your input file has RECFM=FB and LRECL=80, but the job can be changed appropriately for other attributes.