DSXchange

First question to ask is whether the Oracle BLOB and DB2 BLOB are compatible.

If they are, treat them as Long VarChar data type. Use appropriate CAST or conversion functions in user-defined SQL.

Welcome aboard.

There's negligible overhead. You get an extra dot (plus invocation ID if used) in the job name as executed. Purging job logs becomes a little trickier.

Why are you contemplating such a "standard"? There are lots of jobs that won't benefit from being multi-instance.

Rather than Time(), you can use System(12) to return the number of milliseconds since midnight. Note: you need to have $OPTIONS TIME.MILLISECONDS asserted. Microseconds are not possible using DataStage BASIC, though you might be able to invoke a system routine. However, not all operating systems sup...

All correct. You may find it beneficial to use a User Variables activity to change the delimiter character in the list.

You can not change a sequence parameter value once the sequence has started. Use User variables or Activity variables to populate the job parameter values.

This is a common shell technique called "escaping". Since "," (for example) is meaningful in the shell, "\," tells the shell to 'escape' that special meaning and treat the next character as itself literally.

Use a BASIC Transformer stage (or a server job).

Do you know how to specify xpath and repeating elements? If not, a search here and in Ernie's blog will be an excellent learning experience.

Can we call you "auto" for short?

Read Eric's answer again, carefully. This is UNIX, not Windows. Files in the current directory are NOT automatically executable. You need either to incorporate the directory pathname in your command search path (that is, the PATH environment variable) or to specify the command itself via a full or r...

The second person possessive pronoun in English is spelled "your". It is not "u r". DSXchange is not a mobile phone; there is no requirement to use SMS-style abbreviation. Strive, instead, for a professional standard of written English. Among other things, this makes things easi...

Read the file of file names using an Execute Command activity using the cat command. In a User Variables activity convert the line terminator characters into - for example - commas so that you have a comma-delimited list. Use this comma-delimited list in a Start Loop activity. A job within the loop ...

Try this variation: The second argument asserts that the high order bit can be set.

Did you migrate the routine's executable (or compile the routine in production)? What other error messages were logged? When you reset the job, is there a "from previous run..." event logged and, if so, what does it reveal?

Two jobs in a sequence. The first job queries all_tables and stores a delimited list of table names in its user status area. This is used as the list of things to process in a Start Loop activity. The second job within the loop performs the count queries, being passed the table name as StartLoop.$Co...