DSXchange

I'd use a stage variable to accumulate the list. Generate a constant "key" column and use LastRecordInGroup() as a constraint, or use a downstream RemoveDuplicates stage set to "Keep Last". You could use a Pivot stage and a Column Export stage, but that'd be using a sledgehammer ...

These are two representations of the same value. They will compare equal.

I actually meant for you to show us what you'd tried in regard to reading the table names from a file.

Again no. Read the manuals about what each of these stage types do.

You want to perform a pivot. Therefore use a Pivot stage.

"Table not found" is very different from "table exists but has no rows to process". DataStage will abort in the former case but will happily process those zero rows in the latter case. Check again that you have spelled the table/alias name correctly, that the alias does actually ...

OK, show us what you've tried, describe why and how it is not performing as expected, and describe how you've gone about your troubleshooting. Armed with all that information, we may be able to assist.

Click Search in the menu at the top of the page. Prefer an exact match search.

It IS possible to read the table names from a file.

You can add environment variables. There are lots of them that are not there "out of the box". It's not set in stone.

DSXchange offers a DVD-based training class "Programming with DataStage BASIC" which is an authoritative source on how to write routines. See http://www.dsxchange.net for more information.

Define "is not supported" or "is not working" in each case. What are your expected vs actual results? Are any error messages being generated and, if so, what are they? Finally, how are your default values configured? (For example is the output from the Lookup stage in case #2 mar...

It is not. Your output requires neither vectors nor subrecords, which are what the restructure stages are intended to manipulate.

Only by writing your own function.

You can do it in a BASIC Transformer stage using the Fmt() function or the Oconv() function.

I don't think so. Contemplate the error message itself "Cannot open ls". What does that suggest to you?

Can dsjob use an authorisation file? (I'm not currently in a position to check.)

Welcome aboard. Can you please provide a URL for where "IBM posts" this information?