DSXchange

Easy way to do it is to create a SERVER job with a HASHED file stage feeding an output link. Set the filename to RT_LOGnn and then go VIEW-DATA. You may have to setup a few column names, one being defined as a key.

We had a similar issue involving a lookup. Solution was to use a transformer with function NullToZero() on the lookup column.

The first line of your message is of concern. ( Which: no DSAppWatcher.sh in (/usr/lib64 ... ) Which path are you running this from? I'm getting the following from ibm/infosphere/InformationServer/Server/DSODB ./bin/DSAppWatcher.sh -test DSODB is turned ON in the DSODBConfig.cfg file. Link Monitorin...

Tells me I've been previously registered, and drops me out.

Are you using /EXEC option? Check out http://www.ibm.com/support/knowledgecen ... mmand.html

Generic and RCP? That's novel. I guess you are able to affect your oracle select statement? If so, you could always convert your Timestamp upfront using the to_char function. e.g. select to_char(TIMESTAMP '1999-01-15 8:00:00 -8:00') as TZ from dual‏;

I know this is an old post, but our solution is to change the input datatype from a decimal to a varchar

Syntax at UNIX reads:
DSJobReport 1;/tmp;

Also runs with:
DSJobReport 1;/tmp/;

This is opposed to IBM's suggestion at http://www-01.ibm.com/support/docview.w ... wg21627331

Could it be that you are running on one node, or the transformer is set to run sequentially?

Quick question: Are you keeping the type as decimal in your job?

This is a classic server job using a type 1 hashed file. It will generate any amount of files you like.

Try sorting in the ODBC stage.

You could build up the output string in a stage variable and release it with a constraint. e.g.

stagevar1 : if in.COL1 = 'A' then in.COL2 else stagevar1 : ',' : in.COL2

Set single varchar output column to stagevar1 and constrain in.COL1 = 'D'

Run in sequential mode.

We had a similar problem recently using ODBC connector against i-series non-journalised tables. The fix here was to set ODBC setting 'Isolation level' to Default.

There should be a "like" button for snappy replies like Craig's above.