DSXchange

This confusion again !!! the job type is marked as parallel

No special reason that I can think of. If this happens again then you need to contact IBM and ask them the reason of why this is happening. Maybe due to the fact that its a hidden file. But even that does not make sense. Has this ever happened before with this file?

It was a typo, sorry guys. Well if that option is checked then as Craig asked, explain what is not working.

Your admin needs to give you that permission by going into DataStage Administrator, and checking the box that says "Enable Job administration in Job" inside the properties of your project.

As Kumar requested, more information is required. For all we know, the id might already exist in the table.

>##E TFIG 000000 13:58:44(009) <Sequential_File_16> At field "ZEPBORQTY": When validating import/export function: APT_GFIX_Decimal::validateParameters: Decimal "text" format is variable length and no external length is specified. Possibly you should specify an appropriate "width" property? External...

8.0 is for windows server only at the moment. For unix and all its flavours is due any time now.

ray.wurlod wrote:Including all foreign language representations?

Possibly. Nothing is impossible. Just needs time. Maybe some kind hearted soul will do that for us

One of the numeric values is larger than defined. Check it out and fix it.

Very vague question. Need requirements. What goes into what column and in what format.

Care to share the workaround?

Get a count and load them into a hashed file. Similarly do the same for the other database which will act as a source. Do a lookup and see which one matches and which ones are different.

That is indeed excellent advice. Another post going in my favourites. Thanks Ray.

I wrote two C functions to do the same. In one job you can call it and populate a value and in all your remaining jobs, you can call the second and get the value within the transformer. You can use it if you like. There are here.

I dont think you can control the execution in your case. Link ordering controls which link will be fired first but that option is only present with the transformer stage.