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

merging and updating a trailer with documnt set record count


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

New User


Joined: 20 Jun 2012
Posts: 5
Location: india

PostPosted: Thu Jun 21, 2012 5:36 pm
Reply with quote

hi,
i have two files which have this kind of records..
file 1:
10000 abcde
10010 defgh

10000 fsdfsdfs
10010 fsfsdfs

00099 000002(trailer with record count.. only one field is counted which has the imp information or a whole document set is counted in the trailer)

file2:
10000 ahghgdk
10010 dhajhjshk
10000 hdjehkd
10010 ksdkakldal
10000 jhdejhdjhe
10010 hdjhsdhd
00099 000003

i have to merge these files and get an output with the the updated record count ie 000005.... using icetool... i have merged and all but i cant get my record count updated....
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Thu Jun 21, 2012 6:43 pm
Reply with quote

Hello,

Please post the complete expected output from the sample input data. Many people here use the word "merge" incorrectly.

Why must you use ICETOOL?
Back to top
View user's profile Send private message
rajithanair01

New User


Joined: 20 Jun 2012
Posts: 5
Location: india

PostPosted: Thu Jun 21, 2012 7:32 pm
Reply with quote

my output should be like::
10000 abcde
10010 defgh
10000 fsdfsdfs
10010 fsfsdfs
10000 abcde
10010 defgh
10000 fsdfsdfs
10010 fsfsdfs
00099 000005

icetool is according to the requirement
Back to top
View user's profile Send private message
rajithanair01

New User


Joined: 20 Jun 2012
Posts: 5
Location: india

PostPosted: Thu Jun 21, 2012 7:58 pm
Reply with quote

all the files mentioned here are VB files
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Thu Jun 21, 2012 8:02 pm
Reply with quote

Hello,

The "output" does not appear to have the entries from input2 icon_confused.gif

I suspect you could forget icetool (why this is a "requirement" is beyond me*) as all you should need is to concatenate the 2 input files and write a new output file with a new trailer. The input trailers (00099) would be OMITed when read.

* the requirement should be for getting the needed output, not the tool used.
Back to top
View user's profile Send private message
rajithanair01

New User


Joined: 20 Jun 2012
Posts: 5
Location: india

PostPosted: Thu Jun 21, 2012 8:14 pm
Reply with quote

10000 abcde
10010 defgh
10000 fsdfsdfs
10010 fsfsdfs
10000 ahghgdk
10010 dhajhjshk
10000 hdjehkd
10010 ksdkakldal
10000 jhdejhdjhe
10010 hdjhsdhd
00099 000005

sory i copied it wrong... n i cant question the requiremnts... that is something the higher authorities can question on....
and trailer is not counting the direct records... can anyone tell me if we have to count document sets rather than record counts how can we do that??

i just need a trailer with the updated count in my output file.... HOpe my question is clear now?????
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL

PostPosted: Thu Jun 21, 2012 8:31 pm
Reply with quote

rajithanair01 wrote:
n i cant question the requiremnts... that is something the higher authorities can question on....

Bat puckey. If you have any education or ability, you can at least say to your team lead, "It seems to me that it would be more efficient if tool X were used rather than tool Y". To the left, if you scammed your way into a job that you're utterly unqualified for and now don't dare open your mouth for fear that you'll be discovered, fired, and blacklisted, we have neither the ability or the desire to help you.
Back to top
View user's profile Send private message
Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Thu Jun 21, 2012 9:44 pm
Reply with quote

rajithanair01,

1. What is the LRECL and RECFM of file 1 and File2 ?
2. What is the desired LRECL and RECFM of output file ?
3. How do you identify the trailer record? Specify the position and format of the trailer identifier.
4.What is the position and format of the count field on the trailer record?
5. Since you mentioned your input files are VB , please consider the RDW when specifying the positions.
Back to top
View user's profile Send private message
rajithanair01

New User


Joined: 20 Jun 2012
Posts: 5
Location: india

PostPosted: Tue Jul 03, 2012 6:13 pm
Reply with quote

@Akatsukami
thnks for ur suggestions and excessively valuable commnts....
icon_neutral.gif
@Skolusu- i found the solution to my problem by myself... thnks fr the help... icon_smile.gif
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL

PostPosted: Wed Jul 04, 2012 11:07 pm
Reply with quote

rajithanair01 wrote:
@Akatsukami
thnks for ur suggestions and excessively valuable commnts....
icon_neutral.gif

Take them to heart, dear, otherwise you'll spend your career as an underpaid drudge. In 35 years, I've found that specifying the tool to be used is appropriate only for low-level coders (who take logic written by senior programmers and turn it into COBOL) and data entry clerks. In my designs, I've generally told my analysts (who are, to be sure, far more experienced and able than the typical querent on this board) "You may use A and/or B to implement this application; X, Y, and/or Z will be acceptable if you can justify their use as providing features that preferred languages do not".
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 How to split large record length file... DFSORT/ICETOOL 8
No new posts To get the count of rows for every 1 ... DB2 3
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts FINDREP - Only first record from give... DFSORT/ICETOOL 3
No new posts To find whether record count are true... DFSORT/ICETOOL 6
Search our Forums:

Back to Top