DSXchange

DataStage will do this conversion Implicitly with compatiable values.

ArndW wrote:I got my ID for Pearson and (not surprisingly) the exam for DataStage is still airware - nothing in the IBM section about it at all.

Best of luck for your exams :D

parag.s.27 wrote:this is the job[/url]

I guess you may need to edit this post.

I do agree. Most of the case Force Compile helped me to get rid of issues with the incompatable data types (though defined correctly in Transformer) and expression related errors. But it looks like a issue with some library file (permission) error. But I may not be experienced enough to predict the ...

WaitforFile may not help you much. But use Execute command activity to find for this file. Since you need to find anywhere in the unix folder,use find / -name .done 2>/dev/null and use the Comand output in the Trigger to check for the output and trigger the rest of the stage. You can itrate this com...

richdhan wrote:Hi legendkiller,

Do a Force Compile and then run the job. If the problem still persists do as advised by Arnd.

HTH
--Rich

Compile itself checks and compiles the change in Transformer stage.

Do a lookup on City.
In the Conditon option of the reference data, check for country = Null.

The Internal Error and the error code was first striking in my mind. But i should have noted DSR_NLS error as well

Try This: JanOnlyHashedFile | | | |[RefLink] | Jan&FebSrcFile--------> Transformer------------------------------------>Output1 | |[Only Feb Constraint: IsNull(<RefLink>.<AnyColumn>)] |-------------------------------------------->Output2 Output 1 Will have All Account Numbers. Output 2 w...

Well... Search may help you.
Repeated search may help you much better.

Kumar was giving you the lowest level function function that you can use. This is not what I would do, but illustrates an approach you can take: OwnedPos = Index(YourString,'owned by ',1) ;** find keyword NextWord = Field(YourString[OwnedPos+10,99],' ',1) ;** find next word delimite...

Hi,
I hope this function would help to get your solution.

That was one of the post of last year. Now i dont even recall the job available in my project. I wish these reply could have been at six month back.

Multiple import simulteneously may agian eat up the memory.
Command line import can be tryed to import all the dsx from a folder after scheduling.

This was already found during trail period but not discussed.
Now it become all know secrete.