DSXchange

What is the data type of Value_Col? In particular check the extended properties and inform us whether it is of type uint (unsigned integer).

Check access to the project's VOC file. This needs to be writable if you are creating a hashed file using a UV stage or using a Hashed File stage and specifying "account" as the location.

No, process it once only into a staging area (Data Set). Then read from there with separate load jobs. The sequence could then also report on the success or failure of each of these.

Can you please mark the thread as Resolved using the green button at top?

The Stable Sort check box allows one to assert that the sort specified on the input link is (or is not) to be a stable sort.

That's basically the correct answer. The DB2/UDB Enterprise stage only supports DB2 on the same platform type. If you want to go to AS/400 or mainframe you need the DB2 API stage (which is why it still exists in parallel jobs). In version 8.1 the DB2 Connector stage allegedly works to other platform...

Thank you for sharing that, whatever it means.

Parallel job (as marked) or server job (as posted)? Probably the easiest way to do this is to read the file using a single field (data type VarChar) with a Transformer stage executing in sequential mode. The Transformer stage has three outputs with constraints based on the system variable @INROWNUM....

Usually categories are delimited by backslash, so you might need either to specify the argument with backslashes or, within your script, translate forward slashes to backslashes. For example category=$1 catpath=`echo $category | tr \/ \\` The command has to be executed while attached to a project di...

Performance - whatever you mean by it - is a simple supply and demand equation. You can run as many nodes as you like if each of them is doing hardly anything. But you can only run a tiny number of jobs that demand huge resources. A parallel job will create approximately N * (M + 1) + 1 processes, w...

Do you mind if your UNIX command invokes a database query? Because you are going to need a database query to determine the category contents.

Create an entry in the uvodbc.config file in your project directory if you want to limit that project to a subset of the available DSNs.

Use the test facilities in branded_odbc to check your work. Then use DS.CONNECT within dssh to test whether DataStage can use the DSN.

For whatever database your driver is for, yes. For other sources you may get a different character. For example Microsoft Access returns a backquote into this field. Whatever Get SQLInfo returns is guaranteed to work.

Please choose more meaningful subjects. No-one searching in future for help on backing up will even bother to look at this thread. My preferred method for backing up the design elements in a project is to take an export of the whole project, which ends up on my client machine, and allows easy parti...

There's a button captioned "Get SQLInfo" on the stage properties page. It will retrieve the correct syntax from the database server or ODBC driver. If you use generated SQL, that's all you need do. If you're using user-defined SQL, then it's all up to you.