Create Table: Options panel
You use the Create Table: Options panel to specify information to define options for the table you are creating.
Panel and field definitions
Process Options Utilities Help
ZDT/Db2 (DFG2) Create Table: Options
Processing Options, Internal Identifiers.:
EDITPROC . . . DSN8EAE1 (optional)
VALIDPROC . . (optional)
OBID value . . (optional)
Audit and Data Storage Options:
Audit Options Data Storage Options
1. None (default) 1. EBCDIC (default)
2. Changes 2. ASCII
3. All 3. UNICODE
Logging and Table Deletion Options:
Enter '/' to select option
Log data capture changes (default is not to log)
Restrict drop of table (default is to allow)
Command ===>
F1=Help F2=Split F3=Exit F4=CRetriev F7=Backward F8=Forward
F9=Swap F10=Actions F12=Cancel
- EDITPROC
- If the table you are creating requires an EDITPROC clause, specify the name of the edit procedure here. The default is not to use an EDITPROC clause. An edit procedure transforms data at row level within Db2® before presentation.
- VALIDPROC
- If the table you are creating requires a VALIDPROC clause, specify the name of the validation procedure here. The default is not to use a VALIDPROC clause. A validation procedure validates data at row level before it is added.
- OBID value
- Use this field, if necessary, to specify the integer for the OBID clause for the table you are creating. Db2® assigns an (internal) object identifier value to each Db2® object. There are circumstances where it is desirable to specify the value for a Db2® object instead of using the Db2-assigned value. An example is where there are two parallel Db2® subsystems, with the same objects defined in each, and where every matching object has the same OBID value.
- Audit Options
- Db2® provides 3 auditing
options which determine the type of access to the table that causes
auditing to be performed:
- 1. None
- No auditing performed. This is the default setting.
- 2. Changes
- Auditing performed when changes are made to the table.
- 3. All
- Auditing performed when the table is accessed.
- Data Storage Options
- The encoding scheme for string data stored in the table.
ZDT/Db2 uses the selected option when it generates the CCSID clause in the
CREATE TABLE statement.
- 1. EBCDIC
- String data encoded using EBCDIC CCSIDs. This is the default setting.
- 2. ASCII
- String data encoded using ASCII CCSIDs.
- 3. UNICODE
- UNICODE string data encoded using UNICODE CCSIDs.
- Log data capture changes
- Whether additional information is logged for INSERT, UPDATE and
DELETE operations.
- Slash (/)
- ZDT/Db2 generates a DATA CAPTURE CHANGES clause in the CREATE TABLE statement.
- (blank)
- ZDT/Db2 generates a DATA CAPTURE NONE clause in the CREATE TABLE statement. This is the default setting.
- Restrict drop of table
- Whether the table cannot be dropped. You can use this option to
prevent the accidental deletion of tables.
- Slash (/)
- ZDT/Db2 generates a WITH RESTRICT ON DROP in the CREATE TABLE statement.
- (blank)
- ZDT/Db2 allows the table to be dropped. This is the default setting.
Parent panels
Child panels
None.