DSXchange

Please elaborate on how this will yield source, source table, target and target table.

4friends wrote:go to command prompt and type LIST DS_AUDIT (OR) DS_JOBS

1. dsjob has a -param name=value option; use as many of these as required.

2. I would probably create a master job sequence to do the decision making, rather than a script-based approach.

DataStage, it seems to me, is way too enthusiastic to mark columns as Unicode, even when the database from which table definitions are imported differentiate between Char and NChar, VarChar and NVarChar. It should manage these more gracefully (no Unicode for Char and VarChar).

You've missed out on the step that involves updating the "internal" information pertaining to the relationship between table definition and job. In the Columns grid right click and choose to have the extra grid columns displayed, and in the Administrator (if you haven't done so already) check the bo...

Surely you can just use some combination of SUBSTRING and concatenation to produce your desired result in a SELECT statement? In ANSI SQL this would be SELECT SUBSTRING(DATESTR FROM 7 FOR 4) || SUBSTRING(DATESTR FROM 1 FOR 2) || SUBSTRING(DATESTR FROM 4 FOR 2) FROM tablename

string[12] is not sufficient to store all int64 values.

Can you be more precise about what you are attempting to achieve, in particular what is supposed to happen if the BigInt contains more than 12 digits?

There are 8000 values between 0.01 and 80.00 if the increment is 0.01. You need to set your rows to generate property appropriately.

Try removing all references to Unicode (at least for this column) throughout your job design, to see whether it is string vs ustring that is the culprit.

Abburi, you are thinking of the Transformer stage, not the Modify stage. Elavenil, in another post I discussed the inviability of using job parameters in Modify stage. Note also that the Modify stage positional argument is zero based, therefore the first two characters in a string are 0 and 1. So yo...

Left() is a string function and [] (substring operator) is a string operator - you would need to convert the integer to a string to be able to use either Left() or [substring] notation.

The argument to a Modify stage specification must be the name of an input column - you can not use job parameters here. Create the column upstream of the Modify stage - perhaps using a Column Generator stage. Note that it is the date format string that is in square brackets - the input column name i...

IBM's stated plan is to provide a new tool that more closely integrates with "traditional" source code control systems, such as ClearCase. This is because lots of "us" had been asking for check-out/check-in capability, which does not exist in Version Control. However this could not be made ready for...

Look at the generated OSH and at the score to determine that the modify operator has been inserted. You can emplace an explicit Modify stage to handle incoming nullable columns.

Did you make sure that nothing was locked in DB2?

You have internal corruption in your DS_JOBOBJECTS hashed file. This is catastrophic. Make a copy of it, then (as superuser) run the fixtool program against it. This will report the same backward link (blink) error. It may report other errors. Run fixtool again, this time with the -fix option. It wi...