DSXchange

Please delete duplicate post. Pattern matching in the Transformer stage uses a different style from either SQL or regular expression wildcards. You can use a diaeresis (...) as the wildcard. For example: InLink.TheString Matches "A..." Or InLink.TheString Matches "B..." You can a...

Is this a different project? If so, please check that these options are enabled in the Administrator client: in the project properties General tab check the "Enable job administration in Director" check box.

And a set table is the default, is it not? Therefore horserider's DDL will create a set table which will enforce uniqueness of keys.

You can also set it system-wide using Control Panel > System > Advanced (Environment). This may require you to re-start Windows.

There is an MQ Series stage. It has its own manual, which is the only source of reference material for the stage. Ideas about its use can be had by searching DSXchange.

These problems do seem to be coming out of Oracle. Can you successfully access the same tables through other clients, like sqlplus or TOAD ?

You may need to get Oracle support or your DBA involved. There seem to be Oracle internal errors there.

Did you consider using a lookup_int16_from_string() function in a Modify stage? There is no equivalent in a Transformer stage. The table definition in the function can include a default value - I suggest 0.

Have you done everything in that document? It's as clear as anything you're going to get here. DataStage is, as far as DB2 is concerned, just another client application. Therefore, DB2 client software must be configured on the server machine. If you plan to use ODBC, then you also have to set up an ...

Is there not an automatic "jointly unique" constraint added when you include PRIMARY KEY in a CREATE TABLE statement?

In a Routine, the SLEEP 300 statement will wait five minutes (its argument is in seconds). NAP has an argument in milliseconds.

No. A Package contains released jobs only.

Why are you doing this? The need for Packages was deprecated in about version 3.3.

And there will be other records in DS_JOBOBJECTS if the job is non-empty - hence my question. The cleanup can be done from a script, but you need to delete the records from the DS_JOBOBJECTS table before deleting those from DS_JOBS. For example: $DSHOME/bin/dssh "DELETE FROM DS_JOBOBJECTS WHERE...

Set up the XML metadata first. You may wish to use a style document, you may wish to edit the XML metadata manually to specify namespaces and the paths that describe the XML structure. Read the text file with a Sequential File stage, pass it through a Transformer stage (so you can Monitor), then thr...

Three sequences.

Same as you would do it if you didn't have DataStage.

Please post the exact error message (all of it) rather than assuming.