SQLCODE -450 for stored procedure

spoorni · New User Joined: 29 Nov 2007 Posts: 20 Location: india

I have a stored procedure which has been working in some other regions. When i bring the same code down to development and just recompile it and try to run it, i get a -450 failure. I have read that this error would be due to the change in length of linkages. I have checked all the linkages and they have the same lengths in the 2 regions. Coudl there be anything else I could check?

Mickeydusaor · Posted: Fri Jan 16, 2015 3:41 am

miss match in the prod and devl DB2 tables because one of the fields is longer than the tables defined length.

spoorni · New User Joined: 29 Nov 2007 Posts: 20 Location: india

No, nothing has changed on any table. Mutlitple people have checked multiple times.

Rohit Umarjikar · Posted: Fri Jan 16, 2015 9:46 pm

www-01.ibm.com/support/knowledgecenter/#!/SSEPEK_10.0.0/com.ibm.db2z10.doc.codes/src/tpc/n450.dita
ibmmainframes.com/about52472.html
ibmmainframes.com/about48612.html

Have you not looked at these links from Google? You needs to actually give us the complete description of the error and not just SQLCODE. So see if these links helps you to correct the length of that input parm correct.