Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
FIELDSEP=TAB - Help needed

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
gayathrinag

New User


Joined: 16 Oct 2008
Posts: 37
Location: chennai

PostPosted: Tue Jun 14, 2011 1:41 pm    Post subject: FIELDSEP=TAB - Help needed
Reply with quote

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
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10327
Location: italy

PostPosted: Tue Jun 14, 2011 1:47 pm    Post subject: Reply to: FIELDSEP=TAB - Help needed
Reply with quote

why not help Yourself by expanding the solution YOU were given here
http://www.ibmmainframes.com/viewtopic.php?t=54549&highlight=
Back to top
View user's profile Send private message
sqlcode1

Active Member


Joined: 08 Apr 2010
Posts: 578
Location: USA

PostPosted: Tue Jun 14, 2011 9:39 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. SORT trick needed bshkris SYNCSORT 6 Tue May 02, 2017 4:35 am
No new posts Help Needed with View Direct shailesh_do CA Products 2 Wed Jul 13, 2016 10:39 am
No new posts Information needed on using the COBAN... venugopal.dondla COBOL Programming 5 Thu Oct 08, 2015 3:34 pm
No new posts Help needed in Conditional statement ... vinu78 DB2 5 Tue Sep 15, 2015 10:14 am
No new posts Help needed to locate the changes wh... thesumitk TSO/ISPF 6 Fri Jun 12, 2015 6:21 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us