WhereScape Forum: db2 cursor load compile error

Message

   The Set Merge option with cursor load appears to generate invalid code. I get the following compile error on the load of the second stage table:

--E--line 209-- [IBM][CLI Driver][DB2/SUN64] SQL0590N Name "V_RESULT_CURSOR" specified in context "UPDATE_OWNER_HERD_004_STAGE" is not unique. 

--E--line 209-- LINE NUMBER=209. SQLSTATE=42734
If I change the name of the cursor for the second load, then it compiles ok.

Author	Message
Gerry Schuil RED Users LIC Joined: 17 November 2008 Location: New Zealand Online Status: Offline Posts: 58	Topic: db2 cursor load compile error Posted: 11 September 2009 at 12:57pm
	The Set Merge option with cursor load appears to generate invalid code. I get the following compile error on the load of the second stage table: --E--line 209-- [IBM][CLI Driver][DB2/SUN64] SQL0590N Name "V_RESULT_CURSOR" specified in context "UPDATE_OWNER_HERD_004_STAGE" is not unique. --E--line 209-- LINE NUMBER=209. SQLSTATE=42734 If I change the name of the cursor for the second load, then it compiles ok.
	IP Logged

aaron WhereScape Consulting WhereScape Software Limited. Joined: 13 October 2005 Online Status: Offline Posts: 600	Posted: 11 September 2009 at 1:38pm
	Isn't it just the 2nd allocate that needs to be removed rather than renaming ? Also for merge, looks like the final results are only showing for the last source table not the sum of each of the tables :-(
	IP Logged

Gerry Schuil RED Users LIC Joined: 17 November 2008 Location: New Zealand Online Status: Offline Posts: 58	Posted: 11 September 2009 at 2:10pm
	You're right. Removing the 2nd allocate takes care of the problem. To get the sum of the inserts, change the 2nd SET to: SET v_insert_count = v_insert_count + v_rows_committed;
	IP Logged

Support WhereScape Support Wherescape Support Joined: 01 September 2005 Online Status: Offline Posts: 3109	Posted: 11 September 2009 at 3:48pm
	We will remedy both these inssues in a future release
	IP Logged

Support WhereScape Support Wherescape Support Joined: 01 September 2005 Online Status: Offline Posts: 3109	Posted: 01 October 2009 at 8:55am
	These issues have been resolved in version 6.0.6.0 CLOSEDITEM RED-1281
	IP Logged

Ask a question or Report a Bug
WhereScape Forum : Make a Posting : Ask a question or Report a Bug