IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to reconstruct comma-delimited records


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
avaneendra_linga

New User


Joined: 13 Dec 2006
Posts: 73
Location: Hyderabad

PostPosted: Fri Feb 01, 2008 10:42 am
Reply with quote

Hi,

My inputfile LRECL is 300 & FB and file is like

"1234'',100.4676,"USD","730857AA7","US730857AA79","6/15/2014",
"pNT0",5.1250000000,"EUR","B0A0HFU03","XS0181273342","1/27/2014",
"NT00",0.0000000000,"USD","852863AB5","US852863AB56","2/15/2015",
"NT11",0.0000000000,,,"852863AB5","US852863AB56","2/15/2015",

I need only the 1st & 5th fileds in output. i need output like this

1234 US730857AA79
pNT0 XS0181273342
NT00 US852863AB56
NT11 US852863AB56

Thanks,
Avan
Back to top
View user's profile Send private message
krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Fri Feb 01, 2008 10:55 am
Reply with quote

Look at "Deconstruct and reconstruct CSV records " in Smart DFSORT Tricks at

http://www.ibm.com/servers/storage/support/software/sort/mvs/tricks/
Back to top
View user's profile Send private message
avaneendra_linga

New User


Joined: 13 Dec 2006
Posts: 73
Location: Hyderabad

PostPosted: Fri Feb 01, 2008 5:37 pm
Reply with quote

HI Kris,

My mainframe is not supporting PARSE. Please give any other options
Back to top
View user's profile Send private message
krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Fri Feb 01, 2008 6:05 pm
Reply with quote

avaneendra_linga wrote:
HI Kris,

My mainframe is not supporting PARSE. Please give any other options
Are ur fields in the i/p file at fixed positions?
If not then its not possible!!
Are u using SYNCSORT or DFSORT?
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Fri Feb 01, 2008 10:29 pm
Reply with quote

Quote:
My mainframe is not supporting PARSE


You mean your sort product does not support PARSE. If you have DFSORT, then you need z/OS DFSORT V1R5 PTF UK90007 or DFSORT R14 PTF UK90006 in order to use PARSE. This PTF has been available since April, 2006. Ask your System Programmer to install it (it's free).
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Join multiple records using splice DFSORT/ICETOOL 5
No new posts EZT program to build a flat file with... All Other Mainframe Topics 9
No new posts JCL sortcard to print only the records DFSORT/ICETOOL 11
Search our Forums:

Back to Top