DSXchange

How many rows are you extracting? Do you have user defined sql?
Are you performing any functions in the user defined sql?

I dont think it is throughout, maybe at the source, but it has to be defined varchar at both the input and output of the sort stage.

I guess its more like the type of design a developer prefers. To me, a transformer present in the design indicates that some sort of transformation is going on. I guess thats why it was a reflex reply to get rid of the transformer.

If no transformation is required then lose the transformer.
Use of flat file depends upon the amount of data you have. It might be helpful in case of restartability.

If it is a reserved word, use it in double quotes. You should be fine then.

I personally never ran into a problem like that, but hereswhat i was able to find.
I hope it helps.

ORA-02291 error relates to RI. A foreign key doesn'nt exist for the natural key that you are trying to add. Its not a datastage error but a database error and rightfully so. The database as active RI and hence not allowing you to insert the value.

What is the sql type of this field
<Type>1.1982</Type>
Is it float or varchar? If varchar then its missing the ending quote as suggested by the error message. I think

Yes. The sort stage is expecting a numberic value and bumps on 'A1' which we both know is not numeric. Now either you need to fix your incoming data or have to go for a character sort, which might be different from what you are actually looking for , so, as Ken is asking, specify the value of A1 and...

Thats the status code of the dsjob command itself. It will not show up in the xml file, if thats wht you are worried about.

I was aware of that command but it never occured to me that it is the magic wand that is needed. Thanks for the info.

Ok. This will get us no where. Did you pay attention to what Ken had asked?
Also, i am still waiting for your job design and what exactly are you doing in it.

I will tell you. Close your eyes and click on thispost.
Remember the key is to close your eyes, or else it wont work

Dont change it. Specify that column as varchar. Or you will lose that data.

Ultramundane , where have you been all this time. You are right eval does work. You rule dude.