DSXchange

Look in the second log entry for the job run (where the environment variables' values are displayed). Check that NLS_LANG and LANG_C are both set.

The comparison operators yield no information about "contains". Index() is the more efficient, Matches would also work.

Can not be done with a Hashed File stage, since the hashing algorithm uses the primary key, the whole primary key and nothing but the primary key to locate the record. What you seek to do can be done with a UV stage that refers to the hashed file. Performance won't be all that great without an index...

The If..Then..Else construct here is a conditional expression (not a statement) and therefore must return a value irrespective of the result of the test expression. The concept of "no operation" is irrelevant. You will notice in the Then and Else parts there are value-generating expressions, not exe...

Not this time. You can detect and escalate, but you can not promote.

There isn't. You can demote them to warnings or suppress them using a message handler, but you can not prevent them.

There are plenty of examples, which you could find in a search. You use a UNIX editor, such as vi, to create a script that executes the appropriate command (for example sqlplus for Oracle) to issue the SQL statement against the database. Use a chmod command to add execute permission to the script.

So what's the problem?

A Sequencer can only make an "any or all" decision on its inputs. There's naught that can go wrong with it.

I suspect you mean "job sequence".

Split the inserts and updates into separate streams. The rule you currently have in place is "try to insert the row, wait for a success/failure of that then, if the failure was due to the row already existing, try to update the same row". All this waiting adds up. Redesign your job to detect (via a ...

Etiquette Note We don't do "urgent" here. This is an all volunteer site. We post as and when we can, and don't get paid for it. If you want urgent, sign up with your support provider for premium service and learn the true cost of "urgent". Memory consumption can be monitored with Windows Task Manag...

Yes. You can apply a Len() function to the (converted-to-string variant of) each column, and/or use the known length of fixed-size data types. Where are the data coming from? You may be able to use the UNIX wc command.

It's not possible to diagnose with just the traceback, which is all you've posted. Can you please advise of any other errors/warnings, post the generated osh, and be specific about the changes to DB2 - in particular are the table partitionings different from before?

Right click on the date column in the grid, and select Edit Row from the menu. (This is the same as double click, but removes some of the mystery.)

Among the column properties accessible in this dialog are the ones you require.

Is it not possible to compare two timestamps directly? Since they are of the same data type, surely any comparison operator will return a true/false result?

You need to load the character maps in the Administrator client. From the General tab there is an NLS button that opens the dialog for loading maps and locales. Be aware, however, that there is no way to convert Russian characters to English. What NLS does is to change the encoding of the Cyrillic c...