"Beyond SQL_ACTIVE_STATEMENTS limit" means that your application has tried to create more "hStmt"s by ODBC driver than the database is allowed.
It probably means that you are creating a new "hStmt" each time you submit a new query, but you are not releasing these "hStmt"s after the queries complete.
Please make sure to close the cursor object after the the query is completed with the "close" function as shown in the example below:
>> sqlquery = 'SELECT * FROM inventoryTable ORDER BY productNumber';
>> curs = exec(conn,sqlquery,'CursorType','scrollable');
>> curs = fetch(curs,'AbsolutePosition',10);
>> data = curs.Data;
>> close(curs);
Best Answer