DSXchange

Yea, try using this stored procedure call from the OCI stage corresponding to the version of Oracle you are using.

You need to be a charter member in order to see his reply as his replies are premium content and only visible to charter members.
The command he wanted you to run was Also, dont forget to tell us what it said.
Cheers.

Sure, thanks for your time ogmios. Really appreciate it.
The error message i posted in my previous post, is this due to the fact that i have different servers for DS and UDB, or this error is because of some property that i failed to specify correctly
Thanks once again for all your help guys

I tried running a job which reads data from the sql server and loads it into UDB via the db2/udb load stage. the design is simple and straight forward. SQL --------> XFM ----------> DB2/UDB Load Stage The job is aborting. The director is giving me the following fatal error message. CopyOfCGIProducer...

Hmm, tell me more.
You are right, our DS server is on the Sun and UDB on AIX box. So if i understood you correctly, additional setting is required on both the servers for the db2/udb load stage to function. Now that doesnt sound good
Can you identify those settings for me?
Thanks for your help,

I dont mind table level locking at all. As far as I know, only I will be loading that table. No other application will be doing so. :lol: So i guess i am fine with that, my main concern is, by using the DB2/UDB Load stage, will i be doing more harm then good? To be really honest, i have never used t...

I would like to know more about the db2 load stage. Has anyone ever used it before? I have a requirement to BCP 10 million records from sql server to udb. My architecture team wants me to run a proof of concept to get a feel of the performance via the db2 load stage. Personally, i do not like the id...

Learnt a new thing
Thanks Ray.

To my understanding: Your Src: NO ........... TYPE 1 ....................A 1.................... B 1.................... C 1.................... D Create Temp with metadata like this NO ... Type1...Type2...Type3...Type4 1 ..... A......... B .........C ......... D Map the each of them to the temp fil...

If your lookup file has the Date key only then it would give only the first two records. Not the last two.

ray.wurlod wrote:We expect shortly to announce availability of a beginners' class in writing server routines. (This is already available from my personal business, we're working on offering it through DSXchange.)

What I should have mentioned is "The expected upcoming class"[

Sorry for the miscommunication. What I as trying to say is that, if you are using server jobs to develop this logic, the what I would suggest is that have two outputs after you have done the Delta( the change in records) and each of them going to the target table. Write a user defined SQL so that on...

Ray, Out of curiousity, is this handler custom built or a customized add-in.?

Check your data, is it padded with spaces or not. Try trimming the driver and the lookup.

To learn Basic coding, your best place to start off with is the Basic Reference Manual. And joining Rays class would be worth it.
Good luck.