stevie
Active Member
Don\'t want to use a workfile
Hi everybody!
Can the following be done without using a workfile, and if so how:
I have a batch application that needs to break (level-break footer) on Parent Address Number from table F0150.
The Parent Address number is retrieved from a left-outer join between F42199 and F0150 (where say SHAN.F42199 is linked to AN8.F0150)
Now the problem is that not all Ship-to-addressnumbers in the F42199 can be found in the F0150. So, in that situation instead of taking the PA8 from the F0150, the PA8 is equal to SHAN
e.g.
IF BC Address Number - Parent (F0150) is equal to <NULL>
BC Address Number - Parent (f0150) = BC Address Number - Ship To (F42199)
End If
The problem as far as I can tell will be the Sequencing.
Stevie
Hi everybody!
Can the following be done without using a workfile, and if so how:
I have a batch application that needs to break (level-break footer) on Parent Address Number from table F0150.
The Parent Address number is retrieved from a left-outer join between F42199 and F0150 (where say SHAN.F42199 is linked to AN8.F0150)
Now the problem is that not all Ship-to-addressnumbers in the F42199 can be found in the F0150. So, in that situation instead of taking the PA8 from the F0150, the PA8 is equal to SHAN
e.g.
IF BC Address Number - Parent (F0150) is equal to <NULL>
BC Address Number - Parent (f0150) = BC Address Number - Ship To (F42199)
End If
The problem as far as I can tell will be the Sequencing.
Stevie