I have created the following:
CREATE SCHEMA APPLDICT
FOR NONSQL SCHEMA SYSDIRL.IDMSNTWK VERSION 1
And now I can query it using Selects like this:
SELECT * FROM APPLDICT."SA-018";
I can't query records in the thousands like:
SELECT * FROM APPLDICT."FILE-1039";
I get this error:
*+ Status = -5 SQLSTATE = 60002 Messages follow:
*+ DB001031 T51475 C-5M321: DB error 1492; Tbl:?, Area:?
*+ ErrSet:?, ErrTbl:?, ErrArea:?
I assume this is because I need to create another schema for NONSQL schema for the DDLCAT area. I am not sure how to do that?
Does anyone have details on what to do?