We are designing a stored procedure on DB2 for IBM i (7.1 TR7) which returns a data structure array as a result set.
The data structure definition is below
dcl-ds OUT_ARR_AID Qualified Dim(32000);
AccountId char(29) ;
AccountDesc char(61) ;
PostEditCode char(1) ;
SBLType char(1) ;
end-ds;
Exec Sql SET RESULT SETS
WITH RETURN TO CLIENT
ARRAY :Out_Arr_AID
FOR :Out_NumberofAccounts ROWS;
If we change the dimension to 35000, the compilation is failing, is there any limitation?
MSG ID SEV RECORD TEXT
SQL5011 30 144 Position 30 Host structure array OUT_ARR_AID not defined
or not usable.