DSXchange

Yup. Wanted to bring that to your attention. Please let us know once your done, something like this is a beauty.
Thanks Ray.

ray.wurlod wrote:Comparing the two DSX files with diff does show you what's changed.

You read my mind. But ftp'ing the files every time is a pain.

I am putting this in my favourites bucket

You can write a C function to get this done which intakes a char* as its argument, takes each character one by one, converts it to its ascii value and appends to a result variable. At the end, return your result variable. Make sure you allocate memory for all pointers used and free them before your ...

IBM .

You can do it with the Join or lookup stage. Read about those stage on the exact way on "how to do it"

Is the error reproducable? Anyways, search on keywords "Layer type is BASIC run machine"

ray.wurlod wrote:

Izack wrote:What is the use of Stored Procedure Stage ?

To invoke a stored procedure (d'oh!) for every row processed.

I cant stop laughing now.

I know there is an option for that in DB2 bulk load stage. I am not sure about the OCI Load stage.
Let me rephrase my statement, "for some DataBases, the Load stage does the dropping and re-building of indexes"

ray.wurlod wrote:When "they" complain, the response is that it's the cost of stupidity.

Read my footer quote

Ray, I highly doubt we can do that for the message file and the command files created by the DB2 Bulk load.

You can do it inside the transformer. Something like

Did you give any format for StringToDate(). If not then give the following format.

Where do you want to do that, in DataStage? or in a database stage?

Thanks for sharing it with us, a much simpler solution.
Great.