DSXchange

Do an exact search here for "Controller problem: Unhandled failure".

Build the list of columns first, setting a stage variable to "col" when empty and ",col" when not. After all have been checked append " is null" to it if it is not empty when you add it to the output row or use "No null column" if it is.

Fixed your examples for you. You need to use

It's still a vertical pivot, it's just that you have no stage to automate that in Server jobs. However, there are techniques (generally involving a transformer and stage variables) that have been documented here quite a number of times. Rather than me typing it all in again, please do an exact searc...

That's the one. Don't forget you'll need to shut down DataStage before making any change to uvconfig and then run uvregen before restarting it.

Help us understand what "missed" means here. The records that failed one or more lookups? Were rejected by the target stage?

I don't recall the setting name but you can bump it up past the default of 15. Or you can switch to the "string math" functions like sadd which will not have that limitation.

Exactly. Everything still works and the jobs run the same it's just that you don't have access to the "design time" information - you have nothing to open in the Designer.

When your script uses dsjob what "wait" option does it use? Is it "-wait" or "-jobstatus"?

Ah yes, my old alias.

Why not just ask in your post? I'm sure the people who suggested it would be happy to tell you how to do that if you are unsure.

There's a difference between starting and starting to return records.

1.How to parameter jobs without code modifications for file creation everytime?? Ray may have undestood this question but I have no clue what you are asking. Are you asking if you can add parameters to a job without modifying the job itself? Again wondering what exactly "code" means in th...

Please clarify what you mean by "DataStage code". Tt seems you are not including the actual jobs in that statement but rather all of the ancillary supporting objects like scripts, source files, etc? Is that true?

Perhaps something like?

INDEX('ALPS', (if expression = '' then '~' else expression),1)