Create Table: Options panel

Panel and field definitions

  Process   Options   Utilities   Help
                                                                                
 FM/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. FM/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 (/)

FM/Db2 generates a DATA CAPTURE CHANGES clause in the CREATE TABLE statement.

(blank)

FM/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 (/)

FM/Db2 generates a WITH RESTRICT ON DROP in the CREATE TABLE statement.

(blank)

FM/Db2 allows the table to be dropped. This is the default setting.