View previous topic :: View next topic
|
Author |
Message |
rajithanair01
New User
Joined: 20 Jun 2012 Posts: 5 Location: india
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
rajithanair01
New User
Joined: 20 Jun 2012 Posts: 5 Location: india
|
|
|
|
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 |
|
|
rajithanair01
New User
Joined: 20 Jun 2012 Posts: 5 Location: india
|
|
|
|
all the files mentioned here are VB files |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
The "output" does not appear to have the entries from input2
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 |
|
|
rajithanair01
New User
Joined: 20 Jun 2012 Posts: 5 Location: india
|
|
|
|
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 |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
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 |
|
|
Skolusu
Senior Member
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
|
|
|
|
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 |
|
|
rajithanair01
New User
Joined: 20 Jun 2012 Posts: 5 Location: india
|
|
|
|
@Akatsukami
thnks for ur suggestions and excessively valuable commnts....
@Skolusu- i found the solution to my problem by myself... thnks fr the help... |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
rajithanair01 wrote: |
@Akatsukami
thnks for ur suggestions and excessively valuable commnts....
|
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 |
|
|
|