CURSOR SQLSERVER => DATASTAGE

kumar_s · Post by **kumar_s** » Mon Sep 18, 2006 7:53 am

So what is the problem? :wink:

incognico · Post by **incognico** » Mon Sep 18, 2006 9:05 am

The problem is that i m a novice with datastage.

How can i take this request with datastage ?
Have you a exemple ?

I have a cursor in sqlserver, he is used in severals request if you see.
I don't know build a cursor in datastage.

Thank's for your help

Nick

DSguru2B · Post by **DSguru2B** » Mon Sep 18, 2006 10:12 am

Cursors are local to databases. You cannot build a curson in datastage (as far as i know) but you can surely implement the same logic within datastage job(s). My advice to you is, sit down with a cursor expert, get detailed psuedo code as to what the cursor is exactly doing and then translate that to a datastage job. Once you have the psuedo code, you can post it here and maybe someone will help you design the job.
Regards,

kumar_s · Post by **kumar_s** » Mon Sep 18, 2006 6:00 pm

Do you want to call this from datastage or you want to build the logic in datastage?

incognico · Post by **incognico** » Tue Sep 19, 2006 12:56 am

kumar_s wrote:Do you want to call this from datastage or you want to build the logic in datastage? ...

So i have move the post on parallel forum, but i want to build the logic in datastage.

Thank's for your help.

Nick

kduke · Post by **kduke** » Tue Sep 19, 2006 7:45 am

Nick

I think Ray is assuming that because you marked your profile as parallel then you want to build a PX or parallel job and not a server job. Both are part of DataStage. PX which is also called parallel is the newer part of DataStage development. It can be many times faster than a server job. It takes longer to develop a PX job and is less intuitive but the payoff is performance.

So this forum and the PX forum are about DataStage. The job designs are limited to the type of job either PX or server therefore our answer change based on the type of job. That is why Ray wanted to move this question to the PX forum. We tend to answer even if the question was in the wrong forum. We really do not like it if the question is posted in the totally wrong forum like ProfileStage. I hope this helps.

incognico · Post by **incognico** » Tue Sep 19, 2006 8:37 am

ok no problem
I understand.
Thank's

kumar_s · Post by **kumar_s** » Tue Sep 19, 2006 6:47 pm

Convert all the statement with in the cursor in the SQL into a single record set in Datastage, may be by using single or multiple jobs. User Transformer, for all you typecasing, case condition, If then else check... If it is PX job, leverage the filter, SWITCH for these purpose.
Now cursor can be tranformed to either lookup or a Join/Merge based on your requirement.