DB2 7.2 How to create a stored prodedure? (VC 6.0 has installed)

2006-08-22 02:02:00 317 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

DigitalOcean Kubernetes中RWX卷配置与NFS实战指南 ReadWriteMany（RWX）是Kubernetes中支持多节点并发读写的持久化存储访问模式，其底层依赖网络文件系统（如NFS）而非块存储，原理上需协调客户端挂载、服务端导出、内核协议栈及权限映射四层机制。技术价值在于实现日志共享、配置同步等跨Pod数据协同场景，但面临单点故障、协议一致性弱、UID/GID映射失配等工程挑战。在DigitalOcean托管K8s（DOKS）中，因默认StorageClass仅支持RWO块存储，必须通过外部NFS服务器+静态PV/PVC方式落地RWX。本文聚焦NFSv4 阅读详情

OS:Windowss XP
I has installed Visual C++ 6.0 in default path.
And, I has run the cmd for setup environment as follows:

-------------------------------------------
@echo on
set %DB2PATH%=C:\Program Files\SQLLIB
rem Setting the SQL PROCEDURE environment:
db2set DB2_SQLROUTINE_COMPILER_PATH="c:\Progra~1\Micros~1\vc98\bin\vcvars32.bat"
db2set DB2_SQLROUTINE_COMPILE_COMMAND="cl -Od -W2 /TC -D_X86_=1 -I%DB2PATH%\include SQLROUTINE_FILENAME.c /link -dll -def:SQLROUTINE_FILENAME.def /out:SQLROUTINE_FILENAME.dll %DB2PATH%\lib\db2api.lib"
@echo off
-------------------------------------------

Ref url: http://publib.boulder.ibm.com/infocenter/db2v7luw/index.jsp?topic=/com.ibm.db2v7.doc/db2ax/sampgm.htm

But, while I build a Procedure in IBM DB2 Stored Procedure Builder, errors occured.

The procedure is:
---------------begin procedure----------------
CREATE PROCEDURE DB2ADMIN.Proc1 ( )
LANGUAGE SQL
P1: BEGIN
insert into tbl_char (id) values ('2-testclp-1');
END P1
---------------end procedure----------------

And the error is:
---------------begin error----------------

DB2ADMIN.PROC1 - Create stored procedure returns -7032.

DB2ADMIN.PROC1:

*** BIND C:\PROGRA~1\SQLLIB\function\routine\sqlproc\VD00\DB2ADMIN\tmp\P5034130.sqc ***

LINE MESSAGES FOR P5034130.sqc

------ --------------------------------------------------------------------

SQL0060W The "C" precompiler is in progress.

SQL0091W Precompilation or binding was ended with "0"

errors and "0" warnings.

*** COMPILE C:\PROGRA~1\SQLLIB\function\routine\sqlproc\VD00\DB2ADMIN\tmp\P5034130.c ***

DB2_SQLROUTINE_COMPILER_PATH=c:\Progra~1\Micros~1\vc98\bin\vcvars32.bat

DB2_SQLROUTINE_COMPILE_COMMAND=cl -Od -W2 /TC -D_X86_=1 -I C:\Program Files\SQLLIB\include SQLROUTINE_FILENAME.c /link -dll -def:SQLROUTINE_FILENAME.def /out:SQLROUTINE_FILENAME.dll C:\Program Files\SQLLIB\lib\db2api.lib

@echo on

set SQLROUTINE_FILENAME=P5034130

set db2path=C:\PROGRA~1\SQLLIB

cl -Od -W2 /TC -D_X86_=1 -I C:\Program Files\SQLLIB\include P5034130.c /link -dll -def:P5034130.def /out:P5034130.dll C:\Program Files\SQLLIB\lib\db2api.lib

*** C:\PROGRA~1\SQLLIB\function\routine\sqlproc\VD00\DB2ADMIN\tmp\P5034130.def ***

LIBRARY P5034130

EXPORTS _pgsjmp@4

pgsjmp=_pgsjmp@4

C:\PROGRA~1\SQLLIB\function\routine\sqlproc\VD00\DB2ADMIN\tmp>set SQLROUTINE_FILENAME=P5034130

C:\PROGRA~1\SQLLIB\function\routine\sqlproc\VD00\DB2ADMIN\tmp>set db2path=C:\PROGRA~1\SQLLIB

C:\PROGRA~1\SQLLIB\function\routine\sqlproc\VD00\DB2ADMIN\tmp>cl -Od -W2 /TC -D_X86_=1 -I C:\Program Files\SQLLIB\include P5034130.c /link -dll -def:P5034130.def /out:P5034130.dll C:\Program Files\SQLLIB\lib\db2api.lib

----------------------------------------------------------------------------

SQL7032N SQL procedure "PROC1" not created. Diagnostic file is

"P5034130.log". SQLSTATE=42904

DB2ADMIN.PROC1 - Build failed.

DB2ADMIN.PROC1 - Changes rolled back.
---------------end error----------------

I'm agonising about creating a Stored Procedure in DB2 for many days.
Could you give me some suggestions or advices?
3ks a lot!

...全文