DSXchange

Then make sure that the schema file includes Null Field Value properties either in the format string or in the column definitions. Or both.

You can acually "globally catalog" the routine. But this involves a number of steps and will not be supported by IBM, so any maintenance issues will be your own. Essentially the steps are as follows: copy the source code into a Type 19 file (create one if you don't have one - CREATE.FILE D...

The weight you see in the report is whichever weight ended up being used, the calcuated weight or the weight calculated including overrides. Negative weights are disagreement weights.

Slight variation. It controls how many DataStage client machines can be connected to the server at any one time. Each of these may have more than one client connected (up to ten, if I recall correctly). A real geek may well have more than one machine! And, if everyone is sharing the same login ID (n...

DataStage server is installed only on server1? That might explain why the conductor process executes there - it has to look after logging, which is done (optionally) to the local DataStage repository.

It means exactly what it says.

Your design specified some kind of option prescribing how to handle the index(es) but the table has no indexes.

I can not provide a cogent answer to these questions without seeing the changed configuration file.

Check that all services are running, particularly the WebSphere Application Server and the ASBAgent. That's where port number 31531 gets involved. Check, too, that the machine name nsads-dev can be resolved to an IP address (using ping is sufficient).

You can read the line as a single VarChar and parse that in a Transformer stage (probably the easiest). You could also parse it in a Column Import stage.

Character mapping must be consistent across all phases of the ETL.

Not at a DataStage machine at the moment, but doesn't the Oracle Enterprise stage have an option to use your own connection string?

Post your constraint expression.

Until you do we can't help you further.

mediawiz wrote:I mean without "http://"?

Change the third argument of the Field() function. Probably use If..Then..Else to determine whether "http://" is present.

Not having premium membership is a "problem" easily remedied.

You can't write to the file because it is read-only to the user ID under which the job is running. That's the problem you need to fix. It's not a DataStage problem.