db2 - Error in stored procedure -


Hello I am trying to write an archived procedure in ISERAR DB2 but there are errors.

pakretst.fttest2 (IN fExpression CHARACTER (10)) Language SQL SQL data sets dynamic result 1 start STMT VARCHAR (50); 

  Announce the X cursor for the slab; If ftExpression faucet is not set then stmt = 'select * to pakretst.uwftrtystp WHERE' + ftExpression; Else set stmt = 'select from pakretst.uwftrtystp' *; SL ready from Stmt; Open x; Return; End  ;

**** SQL State: 42618 Seller Code: -312 Message: [SQL0312] Convertible FTEXPRESSION is not defined or reason not useful. . . . : FTEXPRESSION that runs in the SAVL statement appears, but one of the following conditions exists: - There is no declaration for the variable. - **

I do not know that this is a simple error in transcription, but what you have here You have gone to the parameter list 

  (IN fExpression CHARACTER (10))

but 

  set stmt = 'Select * to pakretst.uwftrtystp WHERE' + ftExpression;   
 -  fExpression  vs  ftExpression  ...
at the point of use

Comments

Post a Comment