Hi All, Can you plz help me with below query...
Trying to use array in sql (SQLRPGLE) to check if a value is present in array or not like:-
Dcl-ds Array_Ds Qualified Dim(200);
Item Zoned(3:0);
End-ds;
//Here already populated array Array_Ds.Item from file using sql
Exec Sql Select Count(*) into: Count from FileA where
Field1 in :Array_Ds.Item;
So getting error while compiling like - *RNF5343 30 2 Array has too many omitted indexes; specification is ignored.ay in SQLRPGLE
Trying to use array in sql (SQLRPGLE) to check if a value is present in array or not like:-
Dcl-ds Array_Ds Qualified Dim(200);
Item Zoned(3:0);
End-ds;
//Here already populated array Array_Ds.Item from file using sql
Exec Sql Select Count(*) into: Count from FileA where
Field1 in :Array_Ds.Item;
So getting error while compiling like - *RNF5343 30 2 Array has too many omitted indexes; specification is ignored.ay in SQLRPGLE
Comment