OS 7.1 with all current PTFs
I've created the sql procedure below, but I receive an error (sql0104: 'Token CL was not valid. Valid tokens: ( END SET CALL DROP FREE HOLD LOCK OPEN WITH ALTER.') when I try to execute it.
Is keyword 'CL:' not allowed in this setting, or am I doing something wrong?
I've created the sql procedure below, but I receive an error (sql0104: 'Token CL was not valid. Valid tokens: ( END SET CALL DROP FREE HOLD LOCK OPEN WITH ALTER.') when I try to execute it.
Is keyword 'CL:' not allowed in this setting, or am I doing something wrong?
Code:
create or replace procedure submitJob ( in pCommand varchar(1024), in pJobName varchar(10), in pJobDescription varchar(10), in pJobQ varchar(10), in pJobUser varchar(10), in pJobDelaySeconds int ) specific syJobSbm result sets 0 language sql modifies sql data not deterministic set option Commit=*NONE ,DatFmt=*ISO ,DynUsrPrf=*OWNER ,UsrPrf=*OWNER ,DlyPrp=*YES ,CloSqlCsr=*ENDMOD ,SQLpath=*LIBL ,DftRdbCol=*NONE ,DbgView=*SOURCE ... set lCursortext = 'cl: sbmJob cmd(?) job(?) jobd(?) jobq(?) user(?) scdTime(?)'; prepare lCursorStatement from lCursorText; execute lCursorStatement using pCommand, pJobName, pJobDescription, pJobQ, pJobUser, lScheduleTime; ...
Comment