DSXchange

You don't need to worry about the osh executable just yet. Your problem was that the file system on which "/usr/IBM/InformationServer/Server/Datasets" resides ran out of space when populating the reference data set. You need your resource disk to include (possibly more directories yielding...

What you have there is four space characters. Space characters could in no way be regarded as forming a legal decimal number.

Is RCP enabled (a) at project level and (b) in the job properties?

That's fine, so long as you edit the values file (including saving changes and closing the file) before you kick off the DataStage job whose parameter set reads the values file.

Not sure what you're asking here. Is the question about a "values file" read by a Parameter Set?

If so, when do you want to make the change? Can you give an example?

There is one absolute. Once a job is running, values of that job's parameter can not legally be changed.

If you want them to start at the same time (plus or minus a second or two) you will need to write your own job control code with the two DSRunJob() calls adjacent. The code produced by a job sequence sets one job running before starting to set parameter values, etc. for the other.

Perhaps your "flatten" rule has missed one OCCURS clause? Please check. An OCCURS clause that normalizes is the most likely cause, in my opionion, for generating multiple records.

Any other messages? In particular, are you able to establish from the logged messages which operator (stage) generated the "key not found" message? How is your Join defined (that is, what are its key columns)?

They are unlikely to make it available for 7.x unless a business case can be made.

Get "them" to justify the requirement. As Sainath asked, WHICH columns will be required in the output on any particular run, and how are you expected to know that and to convey that information to the DataStage job? The RMM stage* has not yet been perfected.

* Read My Mind

rstemphowski wrote: RCP doesn't seem to be available as a viable option.

Why do you say this? Have you tried enabling RCP for this stage? If so, what result did you obtain?

How are you supposed to create DS/EE users (step b) before installing DS/EE on the ETL server?

Since you already know that the Seq() function returns the ASCII code associated with any character, the answer should be obvious. You need to create a routine that checks each character individually.

Then your DBA, may we suggest, needs to get some Oracle support.

You want to use that code? Fine, go for it.

But it will need some changes when you convert the Perl to C++, not least a function name by which it is to be invoked.