Search code examples
sqlstored-proceduresdb2aix

Stored procedure on AIX environment and DYNAMICRULES BIND


I'm writing a stored procedure (on AIX environment) and I need to activate "DYNAMICRULES BIND" selected.

CREATE OR REPLACE PROCEDURE jjjjjj_PROVA 
( IN p_input1   CHAR(2) )
    LANGUAGE SQL
         SPECIFIC jjjjjj_PROVA
         DYNAMICRULES BIND
P1: BEGIN   
  ...
  ...
END P1  

In the distribution phase I get the following error.

xxxxx.jjjjjj_PROVA - Distribuzione avviata.
Creazione di procedura memorizzata restituzioni SQLCODE: -104, SQLSTATE: 42601.
xxxxx.jjjjjj_PROVA: 12: An unexpected token "BIND
P1" was found following "DYNAMICRULES".  Expected tokens may include:  "<space>".. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.19.56
An unexpected token "BIND
P1" was found following "DYNAMICRULES".  Expected tokens may include:  "<space>".. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.19.56
xxxxx.jjjjjj_PROVA - Distribuzione non riuscita.
xxxxx.jjjjjj_PROVA - Rollback completato correttamente.

The same statement in the DB2 Z / OS environment is correct.

Tips?

Thank you!!


Solution

  • Use CALL SET_ROUTINE_OPTS('DYNAMICRULES BIND') statement before CREATE PROCEDURE in the same session.
    Customizing precompile and bind options for compiled SQL objects