DSXchange

Too slow. The DSLinkCount macro has to begin an interrogation of the repository for every row processed. The link row count is already available in @OUTROWNUM (or @INROWNUM if an input link).

You're not right. Not all databases support fully serializable transactions. In any case, record level locking (read committed) should suffice for your needs.

There are actually 19 types of hashed file. Two are dynamic, seventeen are static. The term refers to whether or not internal "table space" manasgement is automatic or not. Both static and dynamic hashed files are supported by all versions of DataStage.

Please mark the thread as Resolved using the green button at the top of the page, and make a post indicating what the actual solution was. This will assist future searchers.

Split the records in a Transformer stage based on action type. The three outputs wil Insert, Update or Delete using the appropriate database stage.

Decimal data type is always converted to string (including in View Data) with leading and trailing non-significant zeroes. If you don't want them, you have to get rid of them, typically using a Trim() function.

Don't use quoted identifiers.

There's probably a check box (or property, depending on precisely which stage type you're using) that allows you to enable/disable quoted identifiers (table names, column names, etc.) in the generated SQL.

ejazsalim wrote:My requirements does not allow me to create new entry into the .ODBC.INI file for every database in the server.

Tough. There's no other way to do it.

The DSN can be a job parameter.

Right click on the Columns grid. The menu thus revealed allows you to customise the appearance of the Columns grid, including what will and will not be displayed.

Sreedhar wrote:I am using the ls -l

Don't.

Use ls without the -l

Char() is only good up to 255. For values above this you need UniChar().

NullToValue() is a Transformer stage function. The equivalent in a Modify stage is handle_null(). The manual is wrong.

Do you want to get rid of it, or merely to hide it in the Columns grid?

Create a "range lookup" using user-defined SQL in one of the database stages. Use an ODBC stage which supports multiple row return.

Read my post again - I believe your ls command truncated the file name. Use an ls command without the -l option to see what I mean.