While i am trying to create an SQL Stored Proc i get that error
*** Begin "DSNTPSMP" at 2004-06-06 10.36.20
*** DB2 V7R1 SQL Procedure Processor DSNTPSMP 1.14 (PQ61699 2002-08-23)
action = BUILD
routine_name = oprdbad.Proc1
routine_src = CREATE PROCEDURE oprdbad.Proc1 ( ): LANGUAGE SQL: MOD ...
bind_opts = PACKAGE(TEST) ACT(REP) ISO(CS)
comp_opts = NOTEST(block,noline,nopath)
precomp_opts = MAR(1,80)
prelink_opts =
link_opts =
alter stmt =
input_dsn =
buildschema =
buildname = DSNTPSMP
Subroutine: Validate_DDlist
Subroutine: Validate_Noexist
Subroutine: Set_Input_Source
Subroutine: Write_source_dsn
*** PSM parsed source follows ***
CREATE PROCEDURE oprdbad.Proc1 ( )
LANGUAGE SQL
MODIFIES SQL DATA
COLLID TEST
WLM ENVIRONMENT WLM_DB2_TEST
ASUTIME NO LIMIT
RUN OPTIONS 'NOTEST(ALL,*,,VADTCPIP&10.14.8.76:*)'
-------------------------------------------------------
-- SQL Stored Procedure
-------------------------------------------------------
Subroutine: Convert_to_C
*** Convert precompile rc= 8
Language conversion warnings and/or errors, rc=8
Subroutine: Abort
PSM precompile is not successful, cannot continue
Label: Finis
Subroutine: Open_PSMOUT