DSXchange

Have you bothered to read the Parallel Job Developer's Guide section on the Random() function yet?

Trim the leading zeroes. There's no need to be concerned about converting data type. Use the three-argument version of the Trim() function.

Generate the SQL query externally and pass it to the DB2 Connector as a job parameter.

Suggestion: don't PUSH It's only five hours since your original post. Some people are actually asleep at this time. Or is that unacceptable to you? If you need an urgent response, sign up with your official support provider for priority service. Even then, after handing over wads of currency, I doub...

Is the interim precision environment variable set?

Copy the stream and use a Head stage to extract the first row. It can be parsed appropriately downstream of that.

Given that you already are in a Transformer stage, why not just use an additional output link? This could even feature a constraint driven by a job parameter that indicates whether or not you want to capture data and, if so, how many rows.

Or you can use a server Sequential File stage in a server Shared Container in your parallel job.

Any column being returned from the outer side of an outer join should be made nullable. Then you can deal with the nulls in a downstream stage.

And what, pray tell, is the "inverse of concat"? (Hint: it's not "tacnoc".)

Pretty straightforward. Strip off the microseconds, if non-zero subtract 1 and re-attach. If microseconds are zero use 999999 and subtract 1 from the seconds (perhaps using TimestampFromSecondsSince() function) before re-attaching.

12 and 15 are octal values. The Char() function requires decimal arguments.

This is a known limitation of the ODBC driver for MYSQL; it does not handle arrays. Therefore array size must be 1.

And you'll need to specify a second argument for the Oconv() function applied to the date component, not the two components. Nor do you require a 12-hour clock in a timestamp, so lose the "H" from "MTHS". So what you really need is something like Oconv(Iconv(DSLink4.LOG_DT,"...

Welcome aboard.

Yes, what you seek to do is possible via a query on the DS_JOBS table.

Search DSXchange for example queries.