balance field declaration in icetool while xtraction



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

balance field declaration in icetool while xtraction

Postby ramesh reddy » Mon Aug 01, 2011 11:47 am

i am extracting accts using icetool the bal field amt not coming properly...
field name declared as CURRENT-BAL PIC S9(13)V99 COMP-3
while xtraction i declared as HEADER('CURNT BAL') ON(302,08,PD,C4) in icetool.
this declaration giving the result is 0.00,but acct having some balance.

plz help.....
ramesh reddy
 
Posts: 9
Joined: Fri Jan 28, 2011 7:50 pm
Has thanked: 0 time
Been thanked: 0 time

Re: balance field declaration in icetool while xtraction

Postby dick scherrer » Mon Aug 01, 2011 12:19 pm

Hello,

You need to post some of the input data (in hex). You don't need to post entire records unless they are small, only the problem field(s).

If the records are variable length, did you add 4 for the rdw?
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: balance field declaration in icetool while xtraction

Postby ramesh reddy » Mon Aug 01, 2011 1:35 pm

hi dick,
thanks for reply.
my input file records r fb length,
i am writing a report using icetool ...the report records are must have the balance..those records are pulling into the report.
plz give the syntax how to code that one...
ramesh reddy
 
Posts: 9
Joined: Fri Jan 28, 2011 7:50 pm
Has thanked: 0 time
Been thanked: 0 time

Re: balance field declaration in icetool while xtraction

Postby NicC » Mon Aug 01, 2011 7:13 pm

How about showing us the control statements that you are using and, as Dick requested, some of the data - displayed in hex. Use the code tags to keep your code and data aligned. Code tags are [ code] and [/ code] (without the embedded spaces that I put in there.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: balance field declaration in icetool while xtraction

Postby Frank Yaeger » Tue Aug 02, 2011 1:47 am

CURRENT-BAL PIC S9(13)V99 COMP-3

That declaration is indeed for an 8-byte PD field. So ON(302,08,PD,C4) would be correct. If it's NOT, then either the field does NOT start in position 302 or it does NOT actually match that declaration.

To find out, you can use ON(302,08,HEX) to see what the field really looks like in hex.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post