CREATE PROCEDURE DB2ADMIN.PROCEDURE1 ( IN a SMALLINT,
OUT b SMALLINT )
P1: BEGIN
select count(*) into b
from jjj
where c=a;
END P1
创建 存储过程 返回 -7032。
[IBM][CLI Driver][DB2/NT] SQL7032N未创建 SQL 过程 "PROCEDURE1"。诊断文件为 "P1172760.log"。SQLSTATE=42904
请问一下这个怎么解决呢?
jjj的模式是db2admin ,
-- LOG FILE P1172760.log FOR PROCEDURE DB2ADMIN.PROCEDURE1
-- DB2_SQLROUTINE_PREPOPTS=
-- PREP/BIND MESSAGES FOR D:\IBM\SQLLIB\function\routine\sqlproc\SHOP\DB2ADMIN\tmp\P1172760.sqc
行消息 P1172760.sqc
--------------------------------------------------------------------------
SQL0060W"C" 预编译程序正在执行。
SQL0091W预编译或绑定已结束,有 "0" 个错误和 "0" 个警告。
-- CONTENTS OF D:\IBM\SQLLIB\function\routine\sr_cpath.bat
-- CONTENTS OF D:\IBM\SQLLIB\function\routine\sqlproc\SHOP\DB2ADMIN\tmp\P1172760.BAT
@echo on
set SQLROUTINE_FILENAME=P1172760
set db2path=D:\IBM\SQLLIB
-- COMPILATION COMMAND:
nmake /f D:\IBM\SQLLIB\function\routine\sqlproc.mak
-- CONTENTS OF D:\IBM\SQLLIB\function\routine\sqlproc\SHOP\DB2ADMIN\tmp\P1172760.def
LIBRARY P1172760
EXPORTS _pgsjmp@8
pgsjmp=_pgsjmp@8
-- COMPILATION MESSAGES FOR D:\IBM\SQLLIB\function\routine\sqlproc\SHOP\DB2ADMIN\tmp\P1172760.c
-- C COMPILATION ERROR CODES: 0 0 1
D:\IBM\SQLLIB\function\routine\sqlproc\SHOP\DB2ADMIN\tmp>set SQLROUTINE_FILENAME=P1172760
D:\IBM\SQLLIB\function\routine\sqlproc\SHOP\DB2ADMIN\tmp>set db2path=D:\IBM\SQLLIB
D:\IBM\SQLLIB\function\routine\sqlproc\SHOP\DB2ADMIN\tmp>nmake /f D:\IBM\SQLLIB\function\routine\sqlproc.mak
'nmake' 不是内部或外部命令,也不是可运行的程序
或批处理文件。
-- END OF LOG FILE (SQLCODE: -7032)
有啊,
-- LOG FILE P0533081.log FOR PROCEDURE ADMINISTRATOR.PROCEDURE1
-- DB2_SQLROUTINE_PREPOPTS=
-- PREP/BIND MESSAGES FOR D:\IBM\SQLLIB\function\routine\sqlproc\SAMPLE\ADMINISTRATOR\tmp\P0533081.sqc
行消息 P0533081.sqc
--------------------------------------------------------------------------
SQL0060W"C" 预编译程序正在执行。
SQL0091W预编译或绑定已结束,有 "0" 个错误和 "0" 个警告。
-- CONTENTS OF D:\IBM\SQLLIB\function\routine\sr_cpath.bat
-- CONTENTS OF D:\IBM\SQLLIB\function\routine\sqlproc\SAMPLE\ADMINISTRATOR\tmp\P0533081.BAT
@echo on
set SQLROUTINE_FILENAME=P0533081
set db2path=D:\IBM\SQLLIB
-- COMPILATION COMMAND:
nmake /f D:\IBM\SQLLIB\function\routine\sqlproc.mak
-- CONTENTS OF D:\IBM\SQLLIB\function\routine\sqlproc\SAMPLE\ADMINISTRATOR\tmp\P0533081.def
LIBRARY P0533081
EXPORTS _pgsjmp@8
pgsjmp=_pgsjmp@8
-- COMPILATION MESSAGES FOR D:\IBM\SQLLIB\function\routine\sqlproc\SAMPLE\ADMINISTRATOR\tmp\P0533081.c
-- C COMPILATION ERROR CODES: 0 0 1
D:\IBM\SQLLIB\function\routine\sqlproc\SAMPLE\ADMINISTRATOR\tmp>set SQLROUTINE_FILENAME=P0533081
D:\IBM\SQLLIB\function\routine\sqlproc\SAMPLE\ADMINISTRATOR\tmp>set db2path=D:\IBM\SQLLIB
D:\IBM\SQLLIB\function\routine\sqlproc\SAMPLE\ADMINISTRATOR\tmp>nmake /f D:\IBM\SQLLIB\function\routine\sqlproc.mak
'nmake' 不是内部或外部命令,也不是可运行的程序
或批处理文件。
-- END OF LOG FILE (SQLCODE: -7032)
谢谢你啊,