The following panel shows an example of entering a CREATE SCHEMA statement. See How to Submit SQL Statements for the steps to obtain the Source Panel and an explanation of the fields.
=> => => ------------------------------------------------------------------------------- Interactive SQL Service Facility SQLMAINT Source Panel S01S EDIT Member: $DDSQL Output Line Limit: 01000 Person: DATACOM-INSTALL Current Authid: SYSADM Description: CREATE A SCHEMA ------------------------------------------------------------------------------- ====== ========================== T O P ======================================= 000001 create schema authorization jones; ====== ======================= B O T T O M ==================================== PF1=HELP PF2=END PF3=SPLIT PF4=PROCESS PF5=TOP PF6=BOTTOM PF7=BACKWARD PF8=FORWARD PF9=EXECUTE PF10=LEFT PF11=RIGHT PF12=ALTERNATE
The statement CREATE SCHEMA and the keyword AUTHORIZATION are required. AUTHORIZATION must be followed by the name of the authorization ID you are creating. In this example, the authorization ID is JONES.
You can create a base table at the same time you create a schema by entering a CREATE TABLE statement in the source member.
You can create more than one schema in a source member by entering multiple CREATE SCHEMA statements. If you choose to do this, each authorization ID you specify must be unique, that is to say, no duplications are allowed, including naming an authorization ID which already exists.
For more information on the CREATE SCHEMA statement, see CREATE SCHEMA.
After placing your SQL statement in the numbered line area on the Source Panel, you can perform the following:
|
Copyright © 2014 CA.
All rights reserved.
|
|