DSXchange

Example: did you use user-defined SQL at some point then revert to generated SQL (or vice versa). Both are stored, both are exported into the DSX file even though only one is used.

Returning to the original question, the first problem is knowing what "properly loaded" means. Come up with a definition of that, and you will almost certainly, as a by-product, come up with a means of verifying that it has occurred. Converting that means into DataStage componentry is wher...

When's the interview?

There is no limit on the number of stage variables until you run out of memory. I have seen jobs with a couple of hundred stage variables (legitimately) that worked fine.

For that matter, what do you believe RCP is supposed to do?

Use a Column Import stage to parse the comma delimited values into separate columns and Pivot that.

mandyli wrote:What is location for dsprcservices file?

In versions 6.0 and later it is in the DataStage server engine directory.

OK, you're probably going to need a fairly complex expression to effect the conversion from local time to UTC if the solution needs to be general, or use a constant offset for a limited result. (Incidentally, how is Indian Standard Time (4.5 hours offset) represented?) The rest should just be decomp...

Yes, that's minutes. 48 minutes each, on average.

There's a lot of work to do to compare every object and every relationship.

It's useful to restart DataStage after dsenv changes so the dsrpcd picks up the changes (and therefore dsapi_server and dsapi_slave processes become aware of them).

You can see the entirety of my entry (it's short enough not to be affected by the premium size cutoff) and it IS a parallel solution.

Which ISO standard specifies that format? What is "0Z"?

ISO 8601 (date and time formats) specifies YYYY-MM-DD HH:MM:SS with optional fractional seconds for a timestamp).

Conversion is only relevant if the target is a string data type.

It's been a long time...

BASIC Transformer, Iconv(string[1,2], "MX0C")

1. Batches are intended to be created in Director by operators who do not have the developer role. Therefore the dedicated name and the inability to change the same. You can copy the job control code into a new server job and call that whatever you like (provided your name does not begin with "...