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
 
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 query to fetch record which has only ... maxsubrat DB2 12 Mon Dec 11, 2017 5:03 pm
No new posts Extract record for change in combinat... Trinadh DFSORT/ICETOOL 6 Thu Nov 23, 2017 3:32 pm
No new posts Extract Record using range of Data scorp_rahul23 DFSORT/ICETOOL 3 Wed Nov 15, 2017 11:54 pm
No new posts VBS and VB, COBOL syntax is the same ... natt.sut COBOL Programming 3 Sun Nov 12, 2017 6:36 am
No new posts Squeeze record left so that zeroes ar... Vignesh Sid SYNCSORT 5 Fri Nov 10, 2017 1:40 pm

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