View previous topic :: View next topic
|
Author |
Message |
Sureet Mookherjee
New User
Joined: 08 May 2009 Posts: 19 Location: India
|
|
|
|
My requirement is to delimit the various fields in the output file with one carat(^).
Ex:
Emp No HICN No Name
0000000001^H0000001^Sureet
How to achieve this using outrec in jcl??? |
|
Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007 Posts: 1399 Location: IL, USA
|
|
|
|
Show us the some sample records with layout of input file....
Also which sort product you are using?
LRECL=? RECFM=? |
|
Back to top |
|
|
Sureet Mookherjee
New User
Joined: 08 May 2009 Posts: 19 Location: India
|
|
|
|
filelength is 1000 bytes and its syncsort that i am using |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
search the forums for "CSV" ( comma separated values )
the process will be the same, You will be using a "^" instead of a comma ","
just a hint... something along the lines .....
OUTREC FIELDS=(p1,l2,'^",p2,l2,'^',...,....pn,ln)
p1,p2,...,...,pn will be the input field position
l1,l2,...,...,ln ill be the input field length
check the manuals for the exact syntax
and test |
|
Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007 Posts: 1399 Location: IL, USA
|
|
Back to top |
|
|
Sureet Mookherjee
New User
Joined: 08 May 2009 Posts: 19 Location: India
|
|
|
|
Thanks for the reply Enrico |
|
Back to top |
|
|
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007 Posts: 496 Location: USA
|
|
|
|
Sureet,
Basing this solely on the small sample record you included in the original post, if each field has a single space between them, and there are no spaces within a field, then you may be able to use either FINDREP or ALTSEQ to change all the spaces to carats. This is a better approach if you do not know the exact positions of the spaces/carat replacement. |
|
Back to top |
|
|
|