Error while Calling SP from OCI Stage

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Hope you might have as well tried call SP_CID_EXTRACT_CUST_DATA_FIX1();
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Top
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Else I ll need to dig into the jobs that we call SP in Before/after SQLs.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Top
oacvb
Participant
Posts: 128
Joined: Wed Feb 18, 2004 5:33 am

Post by oacvb »

Thanks for your suggestion Kumar. First I tried that option and resulted the same issue.
Top
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Did you try prefixing the stored procedure with the user ? In other words, fully qualifying the stored proc. name?
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”