DSXchange

Ok, that number corresponds to a well-filled project. Perhaps the UV_SCHEMA entry is corrupted:

I think the issue is that the funnel stage doesn't have round-robin collection, so one needs to perform that ordering oneself, thus my recommendation to compute the order algorithmically in the job.

Ok, the next step:
This is to see if the VOC file of that project contains data.

You can't avoid that, the default values of a set are compiled into the job. Or go the route of using "$PROJDEF" for all parameter set default values, in which case you wouldn't need to recompile.

Various methods exist, here are some, in no particular order - make the whole job one transaction; either everything or nothing gets loaded - as part of the load/write to the database you add a field with date/time of load or a unique identifier, upon re-run read the DB and ignore any with that iden...

No, there is no command that will let you do this. Your best bet is to take a .dsx or .xml export and process that. What do you mean by "get the derivation part in one go"?

Not all lines will have 2 columns. You need to declare just one column per line, then parse the contents in your job.

swarnkar wrote:bash-3.00$ ./dsenv

is wrong, execute ". ./dsenv" the leading ". " is very important.

"Pathed" filenames use OPENPATH while VOC filenames use OPEN. Which is being used in your routine?

The assumption was that you had already run ". ./dsenv" after the "cd $DSHOME", since this is the prerequisite for all DataStage shell commands. Please do so and re-run the commands.

lol, I had to look it up the first time I saw it used (in the W3C standards) and like the term and use it wherever I can; which is probably why I never make it past the first date...

That was an interesting post, donny. You managed to answer some questions that weren't asked but avoided answering any of the questions that were...

First of all, you need to constrain your run to 1 node. Then add a column to all three streams, using the algorithm "@INROWNUM*3+{n}" where {n} has a different value in each stream, 0, 1 or 2. Then use a sort funnel to get your ordering.

Also define your NLS settings for DB2 and DataStage and what you consider a cleanup to be (removing them, mapping them to other characters, etc.).