How to Design a job

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
sundrop
Premium Member
Premium Member
Posts: 7
Joined: Thu Sep 13, 2007 9:04 am

How to Design a job

Post by sundrop »

I'm new to DataStage and have a how to question. I need to post some Invoice information to SAP using IDOCs. I have two sequential files. One with Invoice header information and the other with Invoice line items, freight items and tax items for an invoice. I need to determine if the Invoice has a freight item or a tax item to determine how to value a field.
Is there a way to read all the line items for a particular invoice first to determine if that invoice has a tax record or a freight record? Can this be accomplished using stage variable?
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Hello sundrop and welcome to DSXchange.

PX jobs allow a sequential file to be used as a lookup object. If you declare your Invoice Line items file as a lookup and use your invoice number and tax/freight record column value as lookup keys you can get your status and process the other data accordingly.
Post Reply