External stored procedure on IBM i

I am trying to create an external stored procedure on IBM I (V5R4), but I get an error when I try to start it.

All I want to do is call the RPG program without passing any parameters or without worrying about returning any data. Sorry, I'm not an RPG programmer or an IBM i expert, so I might be missing out on something very simple.

SQL to create the procedure:

CREATE PROCEDURE SOMELIB.SOMEPROC ( ) 

    LANGUAGE RPGLE 

    NOT DETERMINISTIC 

    NO SQL
    EXTERNAL NAME 'OTHERLIB/SOMERG' 

    PARAMETER STYLE GENERAL; 

Error executing CALL SOMELIB.SOMEPROC ():

SQL State: 38501 Supplier
Code: -443
: [CEE9901] . RNX1216 BB1002RG 2100000001, X'0000 '. .,,: , . , , - SOMERG SOMERG. ​​ () . , ILE. . * N , , . .,: . , , . , .

+3
4

RPG- . :

1) F-spec RPG, EXTFILE.

2) CL , , , . CL RPG.

+4

( ) , . , .

, , CL .

+2

, , , EXTFILE(variablename) USROPN F-spec. PSDS variablename , OPEN .

, , . ( PSDS) PSDS ( ). , , , .

( , . . * USRIDX . , . , . .)

+2

: JOBD , .

+1

Source: https://habr.com/ru/post/1720104/


All Articles