View previous topic :: View next topic
|
Author |
Message |
gayathrinag
New User
Joined: 16 Oct 2008 Posts: 37 Location: chennai
|
|
|
|
Hi All,
I have the below requirement.
Emp.No;Sal
101;10000
102;20000
103;10000
I want these fields to be in tab separated. Instead of ";" i need to have tab.
Can anybody help me in this.
Thanks |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
Back to top |
|
|
sqlcode1
Active Member
Joined: 08 Apr 2010 Posts: 577 Location: USA
|
|
|
|
gayathrinag,
Can you have ';' in the data? If not, see if below helps...
Code: |
//STEP0100 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD *
101;10000
102;20000
103;10000
/*
//SORTOUT DD SYSOUT=*
//SYSIN DD *
OPTION COPY
OUTREC IFTHEN=(WHEN=INIT,
FINDREP=(IN=C';',OUT=X'05'))
/*
//*
|
OUTPUT
Code: |
101.10000
FFF0FFFFF4444
1015100000000
------------
102.20000
FFF0FFFFF4444
1025200000000
------------
103.10000
FFF0FFFFF4444
1035100000000
------------
|
Thanks, |
|
Back to top |
|
|
|