DSXchange

Allowing multi-instance execution won't help. Do the two files have the same structure? If yes, then you can use multiple File properties in the Sequential File stage. If not you will need separate Sequential File stages, or the ability to use the Schema File property to load the data one file at a ...

... and it will always be there for numeric data types.

Note, in James's reply, that you need to convert to string to get rid of this space.

Your specification is hard to understand. Presumably you must always output four fields. So what do you want to use to replace NULL where it occurs? Also is your source a text file or something else?

Welcome aboard. Apart from the Derivation Substitution facility for varying expressions, there is no regexp support in the Transformer stage. Try Convert(Convert("0123456789", "", InLink.TheString), "", InLink.TheString) The inner Convert() removes all numeric character...

You should certainly check the licensing of your xlC_r compiler.

Entering the command with its help option or with no option gives a syntax summary but I still can't read anything in that about how to import. $ orchdbutil ##I IIS-DSEE-TFCN-00001 16:06:36(000) <main_program> IBM WebSphere DataStage Enterprise Edition 8.5.0.5746 Copyright (c) 2001, 2005-2008 IBM Co...

Also this is not a good long-term strategy, using TCL. From version 8.5 much of what you can currently get using TCL is no longer available by that method, because the metadata are stored in the common metadata repository (XMETA if you called it that).

It can be done in TCL but each job's and each sequence's structural information is stored in a separate table, so you'd still need to construct a means of iterating through all job/sequence names in DS_JOBS: a non-trivial task.

Is this an Information Analyzer question?

You can use BCI functions from a routine to load data into Oracle.

Search DSXchange for examples.

Have you executed the correct bind command on the DataStage server machine?

Prove it.

Did you try my suggestion of using a text file (or even a Peek stage) to eliminate non-Oracle causes of the problem?

Create a reject link from the stage that is writing the rejects, and send that link into a text file.

The BASIC Transformer stage is not a regular Orchestrate operator, so its internal details are not available to the job monitor for parallel jobs.

Apart, of course, from the mismatched variable names.