Stored Procedure "PIPPO" - Distribution Options (using Data Studio)ĬURRENT_PATH BY SQUIRREL SELECT CURRENT_PATH FROM SYSIBM.SYSDUMMY1 GRANT EXECUTE ON PROCEDURE "PIPPOOWN"."PIPPO" TO PUBLIC GRANT EXECUTE ON PROCEDURE "PIPPOOWN"."PIPPO" TO "USERWEB" GRANT EXECUTE ON PROCEDURE "PIPPOOWN"."PIPPO" TO "PIPPOOWN" WITH GRANT OPTION GRANT EXECUTE ON PROCEDURE "PIPPOOWN"."PIPPO" TO "PUBLICB" Stored Procedure "PIPPO" - GRANT GRANT EXECUTE ON PROCEDURE "PIPPOOWN"."PIPPO" TO "ALL" SQLCODE=-440, SQLSTATE=42884, DRIVER=4.26.14 SQL Code: -440, SQL State: 42884īut if i use IBM DATA STUDIO with the same user and statements i get no error Now it gives the following error: NO AUTHORIZED PROCEDURE NAMED PIPPOOWN.PIPPO HAVING COMPATIBLE ARGUMENTS WAS FOUND. #Squirrel call driver#I downloaded "IBM Data Server Driver for JDBC and SQLJ (JCC Driver)" Version 11.5.4, then I configured it to use db2jcc4.jar If I use IBM DATA STUDIO or I use a DB2 AIX it works. 12:01:03,409 ERROR _sql.fw.util.DefaultExceptionFormatter - Exception occurred while formatting: nullĪt _2JCCExceptionFormatter.format(DB2JCCExceptionFormatter.java:93)Īt _sql.fw.(DefaultExceptionFormatter.java:68)Īt _.formatException(Session.java:1195)Īt _.SQLExecutionHandler.sqlExecutionException(SQLExecutionHandler.java:458)Īt _.handleError(SQLExecuterTask.java:621)Īt _.runDirect(SQLExecuterTask.java:264)Īt _.run(SQLExecuterTask.java:137)Īt _sql.fw.(TaskExecuter.java:82) I am running Error: Īnalisi della sostituzione letterale non riuscita per la chiamata della procedura a DB2 per z/OS. jdbc:db2://xx.xx.x.xx:50001/DB2XYX:retrieveMessagesFromServerOnGetMessage=true īut when I try this in Squirrel I get this error message. I append retrieveMessagesFromServerOnGetMessage=true to connection string for the database. I can call the stored procedure successfully from the DB2 command line I am trying to call a DB2 stored procedure from Squirrel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |