现有两台服务器,一台安装db2 server,另一台安装 db2 client,在client端配置实例db2inst1,并编目server端数据库。
在客户端可以正常执行select、update、delete等sql语句,可以成功调用不带参数存储过程,但是调用但参数存储过程会报如下错误:
[db2inst1@localhost ~]$ db2 "call adm.sp_test_zcq_var('20150101') "
SQL0104N An unexpected token ")" was found following "BEGIN-OF-STATEMENT".
Expected tokens may include: "
". SQLSTATE=42601
在server端却可以正常执行成功
[dpfinst1@node1 ~]$ db2 "call adm.sp_test_zcq_var('20150101')"
Return Status = 0
[dpfinst1@node1 ~]$收起