SchulzP

SQL query non-sql schema to get at FILE-1039

Discussion created by SchulzP on Jan 4, 2018
Latest reply on Oct 9, 2018 by newna02

I have created the following:

  CREATE SCHEMA APPLDICT

  FOR NONSQL SCHEMA SYSDIRL.IDMSNTWK VERSION 1

  DBNAME APPLDICT;

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?

 

-Paul

 

Outcomes