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
 

 

merging and updating a trailer with documnt set record count

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
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    Post subject: merging and updating a trailer with documnt set record count
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

Site Director


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

PostPosted: Thu Jun 21, 2012 6:43 pm    Post subject:
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    Post subject:
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    Post subject: Reply to: merging and updating a trailer with documnt set re
Reply with quote

all the files mentioned here are VB files
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: Thu Jun 21, 2012 8:02 pm    Post subject:
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    Post subject:
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: 1738
Location: Bloomington, IL

PostPosted: Thu Jun 21, 2012 8:31 pm    Post subject:
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    Post subject: Reply to: merging and updating a trailer with documnt set re
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    Post subject:
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: 1738
Location: Bloomington, IL

PostPosted: Wed Jul 04, 2012 11:07 pm    Post subject:
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    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 Updating the counters after eliminati... PANDU1 DFSORT/ICETOOL 12 Mon Nov 21, 2016 9:47 am
No new posts How to update a portion of text in a ... Bill Woodger DFSORT/ICETOOL 25 Wed Nov 09, 2016 9:41 pm
No new posts Updating Cursor row withour using FOR... chandan.inst DB2 15 Tue Nov 08, 2016 11:17 am
No new posts abend sort based on count records in ... anatol DFSORT/ICETOOL 5 Mon Oct 17, 2016 10:10 pm
No new posts sort with previous record anatol DFSORT/ICETOOL 9 Thu Oct 06, 2016 2:36 am


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