IBM Mainframe Forum

Is the following possible through DFSORT/ICETOOL ?



What it does is
- Fetches one row for each salesman
- Profit should be most current positive numeric or zero .

Hello and welcome to the forum,

What does "current" mean?

The sort doesn't "fetch" - it reads all of the records and acts on them depending on the code. . .

Thanks !

'Most current' refers to the largest sales-num for each sales represantative .

What I need is the output should display the profit for each salesman for the largest sales-num .
But if the profit associated with largest sales-num is negative then look for any positive profit for that salesman .
If no positive profit found display 0 .

There's a lot of missing/confusing information here.

What is the starting position, length and format of each field?

Does the Sales-Num field really only have 1 digit? If not, what does it really look like?

Does the Salesman-Id field really only have 1 digit? If not, what does it really look like?

But if the profit associated with largest sales-num is negative then look for any positive profit for that salesman .

Well, Sales-Num 1 for Sales-Id 1 has +500 profit, so that's "any positive profit" but you show the +300 profit instead. Is the rule really that you want a positive profit for the highest Sales-Num or something else? Explain your rules more completely.

Also, give a more extensive example of input and expected output with real/more values.

SALES-NUM is actually a date in original file .So let's call it Sales-Date .
Salesman-Id is 6 char long .
profit is 11,2 which can be positive or negative .
File is FB .
Output should show the the most current positive profit for each saleman or zero if none of the profits is positive .


Input
------------------------------------------------------
SALES-DATE | SALESMAN-ID | PROFIT
------------------------------------------------------
091231 | BXC101 |+500
100131 | BXC101 |+300
100228 | BXC101 |-700
100131 | BXC102 |-200
100228 | BXC102 |-300
100131 | BXC103 |-200
100228 | BXC103 |+400


Output
------------------------------------------------------
SALES-DATE | SALESMAN-ID | PROFIT
------------------------------------------------------
100131 | BXC101 |+300
100228 | BXC102 |0
100228 | BXC103 |+400

Date Format for Sales- Date is yymmdd

Well, you answered some of my questions.

What is the starting position, length and format of each field?

profit is 11,2 which can be positive or negative .

How can +500 fit into 2 bytes - is it a packed decimal (PD) field or a fixed-point (FI) field or what?

Also, if the first two fields are each 6 bytes long, now can the third field start at position 11?

Again, what is the starting position, length and format of EACH field?

Well, Sales-Num 1 for Sales-Id 1 has +500 profit, so that's "any positive profit" but you show the +300 profit instead. Is the rule really that you want a positive profit for the highest Sales-Num or something else? Explain your rules more completely.

???

Also, give a more extensive example of input and expected output with real/more values.

???

I'm happy to help, but I don't see any reason why I should have to guess at what you want.

Hello,

SALES-NUM is actually a date in original file .

And why was this not initially mentioned?

Indeed, why was the entire topic done so far off the mark?

Just because there are people who are happy to help, is no reason to be so incomplete/inconsistent. If you are unwilling to put the least amount of effort into posting what you want, why should others waste time they could use far more productively (i.e. doing their own work, helping others, etc)?

mainframe_novice,

Since it isn't clear what your fields actually look like, I'll show you how to do this with my own definition for the fields. Hopefully, you can adapt it to your real definition of the fields. Let's say the input fields are:



Here's a DFSORT/ICETOOL job that will give the results you asked for:



OUT would have:



Note that you will need the Nov, 2009 DFSORT PTF to use JOINKEYS. If you don't have this PTF installed, ask your System Programmer to install it. For more details on this PTF, see:

http://www.ibm.com/support/docview.wss? ... g3T7000174

Thanks Frank .Appreciate your help !
It worked .

Excellent. Thanks for the feedback.