DSXchange

Not in the schema file. That is a transformation; you would specify it in a Modify or Transformer stage.

Do you get any useful advise from the command oerr -24806 ?

Runtime Column Propagation (RCP) is a technique for dealing with dynamic metadata in DataStage jobs. You can find more information in the Parallel Job Developer's Guide or in the IBM Information Center

The AddMonths routine works for any date.

The following approach will work from the command line. cd $ProjectDirectory . $DSHOME/dsenv $DSHOME/bin/dssh "SELECT JOBNO FROM DS_JOBS WHERE NAME = '<<Job name>>';" $DSHOME/bin/dssh "SELECT NAME FROM DS_JOBS WHERE JOBNO = '<<Job number>>';" The column heading and summary report...

Two techniques are easy; there are others. 1. Create an explicit Failure trigger. This takes precedence over other forms of error handling, even if it only runs into a Sequencer. 2. Follow your command with a command that does return a zero exit status. This technique assumes that you can get the ou...

-1 indicates that "routine_TEST" is either not a valid job name (note that job names are case sensitive) or is not compiled. Therefore the job cannot be attached to the caller.

If the routine is written as a Transform Function, it can be run from its own Test utility (thus "stand alone" as per your requirement). Of course this is not really suitable as a long term solution. No matter which approach you take, you need to invoke calls from the DataStage API, partic...

You did get successfully connected (the log event shows the version number of MySQL, which has been retrieved from the database).

The SELECT statement that you then sent to MySQL has caused a fatal error to be generated, or there has been a network problem. You have some more diagnosis to do.

That's not how it works. Premium membership is how DSXchange is funded. If people undermine that mechanism, then the site will cease to exist. We do NOT want this to happen.

Why not get one for yourself? It's not expensive; less than $0.30 (Rs 12) per day. The benefits are well worth it.

No.

Decimal cannot contain character data, and "+" is a character.

The sign is stored by setting/resetting the sign bit, and the machine takes care of that for you.

Or you can make the field type VarChar and THEN you can store the sign.

You can't have both.

And that, I feel, is the answer to your original question.

Are you sure that you can't import them, or is it only that the web service provider doesn't accept them in a SOAP request?

Have you tried importing WSDL from another provider? (The one you're using has some strange "standards".)

Is your OshMonitor process running?

I assume so, because you say this behaviour manifests in some jobs but not all. What's different about these jobs?

I don't know, but imagine that it would. The thing about a vector is that every element has the same data type.