DSXchange

Has anyone heard when IBM plans on making the Administrator class for Version 8 available.

Their training schedule only list the Vers 7.5 admin class. I thought this class would have been available by now..oops I almost forgot this is IBM's product now.

One of our developers who is using 2 monitors ran to an unexpected error message while trying to edit in the Transform stage: "an unexpected error has occurred in a call to the stage Server column object. (EditDerivation) :?: It took us a while to figure out the source of this error message, as...

Thanks guys for the input have a great weekend.

Thanks Ernie for the quick reply. I have version 8 upgrade on my project plan for the summer, we tried to export and do a dsx compare using utra-edit's compare option, but it listed every timestamp differences it found, a real mess. Knowing that it is available in version 8 will make my darkside dev...

Some of our programmers who have coverted to DataStage from the mainframe darkside have asked if there is a way to compare DataStage jobs. For example compare the Datastage job in production against same job in Test and have any code differences list out, as they were able to do in the darkside. :ro...

Remove duplicate stage can retain first or last duplicate record.

ERROR - it takes less time to do things right than it does to explain why you did it wrong.

Avoid DS Error - Don't Log IN

If you read a persistent dataset using SAME partitioning, the
downstream stage runs with the degree of parallelism used
to create the dataset, regardless of the current
$APT_CONFIG_FILE / specified node pool.

I hope this help

Corret That works as well, just though I would give him the long version to Ray's point, Not heavy user, gets longer version no short cuts.

In Director/ Tools/ Message Handler Management, you can set it for the specific job or for the project,

Thanks for your help I got it to work.

I added the APT_MAX_TRANSPORT_BLOCK_SIZE to the job properties set it to 1 mb and did not specify any field length.

charlie

In the Job Properties numrecs_to_retrieve

Hi Sud,

Did that, no matter what varchar size-999999-is put in no more than 400 records can be loaded w/o and error.

Version EE 7.5.2 I'm trying to load through web services a xml page into 1 field defined as a varchar. This only works when the rec read limit is set to 400 records, anything greater fails-'field size too small', longvarchar fails as well. Does anyone know if this a default setting that can be chang...

The source field and target field attributes that you displayed are correct, most times TD will generate this error if the value of the field is not numeric, NULL or some other bogus data value.

Put some NUlltoZero or Space handling logic in the Transform for these fields.

charlie