CREATE PROCEDURE down.insertdowndata(in i_serviceid varchar(40) REFERENCES db2admin.downservicetable(serviceid),in i_dataid varchar(40),in i_dataname varchar (80),in i_datapath varchar(500))LANGUAGE SQL BEGIN insert into db2admin.downdatat...
显示全部CREATE PROCEDURE down.insertdowndata(in i_serviceid varchar(40) REFERENCES db2admin.downservicetable(serviceid),in i_dataid varchar(40),in i_dataname varchar (80),in i_datapath varchar(500))
LANGUAGE SQL
BEGIN
insert into db2admin.downdatatable values(i_serviceid,i_dataid,i_dataname,i_datapath)
END
@
错误代码如下:
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 "REFERENCES" was found following "erviceid
varchar(40)". Expected tokens may include: ",". LINE NUMBER=1.
SQLSTATE=42601
请问什么意思啊?
收起