I'm trying to write an SQL Stored procedure and want to use arrays.
I've found examples on IBM sites for the following...
CREATE TYPE BIGINTARRAY AS BIGINT ARRAY[INTEGER];
CREATE TYPE CHARARRAY AS CHAR(10) ARRAY[VARCHAR(3)];
It doesn't like the Integer type or the VARCHAR typingm with following message...
Position 41 Token INTEGER was not valid. Valid tokens: ].
Apparently Stored Procedures don't like arrays on i/OS (v7r3)?
How can I use arrays in SQL/PSM?
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.