It isn't an error with CREATE TABLE.

It is a design flaw with the schema that you created the table in. It isn't an actual schema; it's a library that is only being used like a schema.

A true schema will be created with a journal. You are using a library that hasn't been prepared for SQL. If you use CREATE SCHEMA to create a schema first, then use that schema to create your tables in, you won't get the message.

Since you don't have a real schema, there are two ways you can make the library work more like a schema for this message.

First, you can create a journal named QSQJRN in the library. If you create your table then, it will start automatic journaling.

Second, you can create a journal with a name different from QSQJRN in your library. Then create a data area named QDFTJRN in your library. Follow the rules in Automatically starting journaling to define it.

Tom