I am trying to create a SP (AIX,DB2 v7.2) ,
CREATE PROCEDURE ENVI_sp (IN KEY_ char(25),
OUT data_ varchar(255))
EXTERNAL NAME 'david!test111'
RESULT SETS 1 NOT FENCED
LANGUAGE C PARAMETER STYLE DB2DARI;
select * from envi;
I run this script as:
db2 -td@ -vf stpro.sql
I get error:
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "CREATE PROCEDURE ENVI_sp (IN KEY_ char(25)"
was found following "BEGIN-OF-STATEMENT". Expected tokens may include:
It is first time I am trying to create a SP, I appreciate if somebody let me know step by step to create a simple SP (give me a simple sample).