Creating a stored procedure with ARRAY input argument in AS400

Question

I'm currently working on an AS400 machine to create a stored procedure which accepts a string array as an input argument. My code is as follow:

CREATE TYPE stringArray as VARCHAR(100) array[100] 
CREATE PROCEDURE ALI/LWRH_SP
(
    IN list stringArray
)
LANGUAGE SQL
BEGIN
    --TO DO SOME WORK
END

Unfortunately, when I run the mentioned code, the system gives me an error:

SQL0104: token array was not valid. valid tokens:END-OF-STATEMENT

Does anyone know how I can manage this error?

Edit your question to add the version of the Db2 for i that you are using. If your version is IBM i 6.1 then you may be out of luck, as the docs suggest that only IBM i 7.1 or higher supports array types on SQL procedures. Also try qualifying the type name where used. — mao
– mao, Commented Jan 21, 2018 at 13:23

mao · Accepted Answer · 2018-01-22 11:59:33Z

1

If your version is IBM i 6.1 (or lower) then you may be out of luck, as the docs suggest that only IBM i 7.1 or higher supports array types on SQL procedures.

answered Jan 22, 2018 at 11:59

mao

12.4k2 gold badges15 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Creating a stored procedure with ARRAY input argument in AS400

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related