Could you tell me what I did wrong. I created my (very first) stored prosedure succesfully and then called it from command line, again succesfully. All worked fine. Then I tried to call it from application and got error message:
..[DB2/LINUX] SQL10010N The specified library, "CREATE_MYVIEW", was loaded, but the function "CREATE_MYVIEW" could not be executed.