Create a schema
To create a schema:
- In the System i Navigator window, expand the system you want to use.
- Expand Databases and the database that you want to work with.
- Right-click Schemas and select New Schema.
- On the New Schema dialog, specify a schema name.
- To add this schema to the list of schemas displayed,
select Add to displayed list of schemas.
- To create as a standard library, select Create as a standard library (optional).
- Specify an disk pool to contain the schema
- Specify a description (optional).
- Click OK.
You can view the SQL used to create this object by select Show SQL. This action
launches Run SQL Scripts. You can then choose to run the SQL from the Run SQL Scripts
window. However, if you edit the SQL in the Run SQL Scripts window, the changes are not reflected back
to the dialog. Additionally, if you create the object from the Run SQL Scripts window and then click
OK on the dialog, you will receive an error.