converting records



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

converting records

Postby mahesh77 » Fri Jul 03, 2009 2:42 am

Hi Frank,

this is my first posting, i read few manuals u mentioned abt DFsort,icetool, and a doubt poped up in my mind, can we convert records and put charges on customer's bill,suppose assume working in a banking domain and there are two files in it, accounts payable , accounts receiavable , can we put the amount field in records on to a customer bill, can we do it using Icetool..........
mahesh77
 
Posts: 17
Joined: Fri May 29, 2009 5:27 pm
Has thanked: 0 time
Been thanked: 0 time

Re: converting records

Postby dick scherrer » Fri Jul 03, 2009 3:28 am

Hello and welcome to the forum,

Please post some sample data from each input file and the output you want when this sample data is processed.

Explain any rules that need to be applied.

Mention the recfm and lrecl of each file.
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: converting records

Postby Frank Yaeger » Fri Jul 03, 2009 4:48 am

Mahesh77,

Welcome to the help board. As Dick says, you have to explain your requirement with a good example before anyone can help you. We don't know what your data looks like or what you want to do with it unless you tell us. In addition to the information Dick mentioned, please also give the starting position, length and format of all relevant fields.
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

Re: converting records

Postby mahesh77 » Fri Jul 03, 2009 7:43 am

Frank and dick,

i cant provide u any tech info abt my doubt, b,coz its jus a doubt which suddenly poped in my mind, ok jus assume there is account's receivable{ where there is some amount value which the customer has to pay for the bank , and it has to be inserted into customer bill.....} ok assume it has 10000 customers and say input record is 80 bytes long acct no is of 12 digits , name 25 bytes, gender 1 byte,35 bytes address, 7 bytes amount receivable....my question is how , can we inseert only the amount value on to the customer bill using Icetool?
mahesh77
 
Posts: 17
Joined: Fri May 29, 2009 5:27 pm
Has thanked: 0 time
Been thanked: 0 time

Re: converting records

Postby dick scherrer » Fri Jul 03, 2009 8:52 am

Hello,

Invent some input(s) records and show the output you want from that invented input. You don't need a high volume of data, but you need to provide enough to demonstrate the requirement.

Suggest you reduce the account number to 5, name to 10 bytes or so and the same with the address. It doesn't need to be a keying exercise, just a bit of data that clearly shows the what you want to do :)
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: converting records

Postby Frank Yaeger » Fri Jul 03, 2009 7:50 pm

how , can we inseert only the amount value on to the customer bill using Icetool?


I don't know what you mean by this. Insert where? Do you just want to extract the one field from the input record into the output record? If that's what you want to do then you could use an OUTREC statement like this:

    OPTION COPY
    OUTREC BUILD=(p,m)


where p is the starting position of the field in the input record and m is its length.

If you want to do something else, you need to explain clearly what you want to do.

Perhaps the best thing would be for you to read through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:

http://www.ibm.com/support/docview.wss? ... g3T7000080
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