Call To DB2 Store Procedure fails
Posted: Mon Jun 04, 2007 11:00 am
I developed a DB2 Stored Procedure call to get the max_row_id + 1 from DB2 and it was working. Now when I place the Stored Procedure call in another PX job...the job fails on the Stored Procedure call. If I remove the call to the Store Procedure the job runs OK.
What is strange is that other previous PX jobs that references the store procedure call still works..Only new one fail. Any ideas?
Here are the error message I am now getting below
sp_calc_row_id,0: Error: Arithmetic overflow [dscapiop.C:1891]
Error occurred in call to ORPHCallActivePluginRun() with input link '0'
thanks
dtatem..
What is strange is that other previous PX jobs that references the store procedure call still works..Only new one fail. Any ideas?
Here are the error message I am now getting below
sp_calc_row_id,0: Error: Arithmetic overflow [dscapiop.C:1891]
Error occurred in call to ORPHCallActivePluginRun() with input link '0'
thanks
dtatem..