SQL Schemas

Before you can use the capabilities SQL offers for defining, manipulating and controlling data, you must have a schema to define your SQL environment. A schema is required before you can use SQL.

The schema is essentially an authorization ID and all the SQL objects (tables, views, plans, and synonyms) qualified by that authorization ID.

You can create a schema in the following ways:

Embed a CREATE SCHEMA statement in an application
Submit the CREATE SCHEMA statement through the CA Datacom Datadictionary Interactive SQL Service Facility
Use DBSQLPR to CREATE SCHEMA

When you create your schema, the only requirement is that you specify the authorization ID. You can optionally define your tables, views and synonyms at that time, or you can create these objects separately as needed.