var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Error Compiling Stored Procedure
I am still new to DB2 stored procedures and i am having endless problems creating one. I am using command center and i did run a fixpack.
First i had problems with my termination character, that is now fixed thanks to this forum, now i have a new error whils creating this simple sp.
create procedure sp_tmp ( in p_in varchar(10), out p_out varchar(10) )
set p_out = p_in;
The error message is:
SQL0035N The file "P8204124.msg
" cannot be opened.
The message file "<name>" could not be opened.
Binding or precompilation has been terminated.
Ensure that the system can access the file.
Any idea what this could mean?
Thank you in advance for your help.
What OS are you running on? What I suspect is that the
user you are using to create the SP does not have proper rights
to the directory where DB2 puts the SP files. If you are
using Linux, use the instance owner for creating SPs.
i got the problem, on linux, the instance users tmp directory didnt have the correct rights....
now, how to call a sp from a trigger...