×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
FYI, not a question.
I am trying to start a stored procedure (all written in SPL) with the following command:
SBMJOB CMD(RUNSQL SQL('CALL AS2EDI') COMMIT(*NONE) NAMING(*SQL) DFTRDBCOL(ROUTINES))
JOB(AS2EDIMON) JOBD(ROUTINES/ROUTINES) CURLIB(ROUTINES) INLLIBL(*JOBD)
I am getting the following message:
Message ID . . . . . . : SQL0204
Message . . . . : AS2EDI in *N type *N not found.
WRKOBJ OBJ(ROUTINES/AS2EDI)
Object Type Library Attribute Text
AS2EDI *PGM ROUTINES CLE SQL PROCEDURE AS2EDI
AS2EDI *MSGQ ROUTINES
select *
from qsys2.sysprocs
where specific_schema = 'ROUTINES'
or ROUTINE_NAME='AS2EDI'
;
Finds it.
No parameters.
Fix was to change:
... RUNSQL SQL('CALL AS2EDI')...
To
...RUNSQL SQL('CALL ROUTINES.AS2EDI')...
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 7310 Innovation Blvd, Suite 104
Ft. Wayne, IN 46818
Ship to: 7310 Innovation Blvd, Dock 9C
Ft. Wayne, IN 46818
http://www.dekko.com
midrange.com
