Table Options

Description

We use the term of Table Options for those elements or clauses that comes after the Content Source of a Create Table Definition.

Grammar Syntax

Image showing the possible Table Options according to the Grammar Syntax.

Navigate to the following pages to get more details about the translation spec for the subsections of the content-source section.

1. Organize By

2. Data Capture

3. Tablespace Clauses

4. Distribution Clause

5. Partitioning Clause

6. Compression Clause

7. With Restrict on Drop

8. Not Logged Initially

9. CCSID

10. Security Policy

11. Options