IBM Mainframe Forum

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..........

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.

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 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?

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

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:



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