Two Dimensional Arrays in 16 ?

[former_SQLA_member1694910]

The Documentation says ( as a new feature ) you can Declare a two dimensional Composite Data Type ( ARRAY )

Is this true ? It only allows me to declare one dimension

e.g. DECLARE New2DArray INTEGER ARRAY(5) ARRAY(10);

if not, is there a work-around ?

greg

[VolkerBarth · Accepted solution]

You are relating to the following doc page, right?

AFAIK, the mentioned sample does not fit. You have to build an array of arrays as mentioned in the next sample from that page, such as

DECLARE New2DArray ARRAY(10) OF ARRAY(5) OF INTEGER;

More samples and explanations can be found in Breck's great Top 10 Cool New Features in SAP Sybase SQL Anywhere 16 article.