DSXchange

Probably using

I think you can only do this with fixed OCCURS, not with OCCURS DEPENDING ON.

You wish.

Actually, the Courtyard by Marriott chain seems now to be putting food, rather than booze, in the minibars, but either way that will be a personal expense.

Is the requirement to look up all detail records for a particular order number? If so, you can not do this with a hashed file stage unless you have some mechanism for generating the line numbers before you get to do the lookup. Your alternative is to use a UV stage, or ODBC stage, with the multiple ...

Then don't! Or test for an argument in an unassigned state and do something about it.

Is it "display" information or "design" information? This will radically affect the answer.

Can you try it with CALL ?

Is "default" in the Nvl function a hard coded value or a variable? If it's a variable, does it have a value assigned on every possible path through the code? Check out the Assigned() or Unassigned() function - I always build one of these into routines that someone else may call, so as to check for a...

Possibly this is running on the MVS (mine's very slow) edition?

Does your particular SQL support a CASE construct?

Another possibility is a Column Generator stage.

Or even this post which is one of three in which you ask the same question and where an answer has been given.

Duplicate post

Please refer to this post

There is nothing within a job sequence that allows you to access a table. A job sequence processes no data whatsoever; it prescribes the flow of control. Probably your best solution is to construct a job (a server job would do) to retrieve the values then use something like that job's user status ar...

How do you expect to compare with the next row when you haven't even read the next row yet???

The best you can do is to store the previous row's value and compare when POST comes through. You need your data sorted for this to work properly, of course.