Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Reformatting output record!

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

New User


Joined: 10 Jun 2008
Posts: 24
Location: india

PostPosted: Mon Feb 16, 2009 2:46 pm    Post subject: Reformatting output record!
Reply with quote

Hi,
I have a requirement. And this goes as,
94 files containing one record each with each file having a different field layout and length. Now the requirement is to reformat the entire fields of a record from all files into a single record(predefined layout).

Is there any way that i could be going on?

Say,
File #1.
ABCD 1234 56 -- length 12 FB

File #2,
EFGHI 67 ZM *&*6G -- length 18 FB

Now the output file should be reformatted as,

1234 EFGHI ABCD ZM 67 56 6G*&*6G
Back to top
View user's profile Send private message

gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Mon Feb 16, 2009 4:27 pm    Post subject:
Reply with quote

Hi,

are you kidding, do you really expect someone to work out your predefinded layout ? 94 files with each having a different layout ?

Maybe I'm missing something.



Gerry
Back to top
View user's profile Send private message
pravinj

New User


Joined: 10 Jun 2008
Posts: 24
Location: india

PostPosted: Mon Feb 16, 2009 4:46 pm    Post subject: Reply to: Reformatting output record!
Reply with quote

Hey! I am just asking you guys the approach that i should be going on!

Because the constraints that i am facing under each design approaches are,
1) Design approach #1: It was to concatenate all files, number the records (each record corresponds to a record from each file) and then based on the sequence number i could extract from position for the input record and move it to predefined location. But this fail, as the input file length differs.

2) So i had to follow on with seperate step for each file, even then i won't be able to place the records from different files on to the same line.

The requirement is like fixing the pieces from different files into a predefined position of an output file(each with their own record length - differs)
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Mon Feb 16, 2009 5:14 pm    Post subject: Re: Reply to: Reformatting output record!
Reply with quote

pravinj wrote:
But this fail, as the input file length differs.
Take a look at a potential TOOL approach Here......
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Feb 16, 2009 10:20 pm    Post subject:
Reply with quote

Hello,

Quote:
I am just asking you guys the approach that i should be going on!
Even recommending an approach may be more than we can do with the info provided so far. . . There does not seem to be a "rule" for combining the 2 files shown. I have no idea to approach 92 such files.

Maybe if a better requirement definition is posted we can make more useful suggestions. What are the "rules" for combining data from the multiple files?
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
No new posts Record Not found in AlX but record re... mukun264 COBOL Programming 5 Fri Mar 24, 2017 9:28 am
No new posts Count the length of the record & ... sreekusr DFSORT/ICETOOL 4 Thu Mar 23, 2017 7:52 pm
No new posts Problem reading GTF trace output danik56 ABENDS & Debugging 7 Thu Mar 16, 2017 1:02 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
No new posts IMS DB-How to update a record (a sing... Nic Clouston IMS DB/DC 9 Thu Mar 09, 2017 4:38 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us