The CREATE statement interface

Figure 1 and Figure 2 show the order in which the database server executes purpose functions for a CREATE TABLE and CREATE INDEX statement. If the IN clause specifies multiple storage spaces in which to fragment the index, the database server repeats the sequence of purpose functions that Figure 1 and Figure 2 show for each storage space.
Figure 1. Processing a CREATE TABLE statement
Flowchart shows am_create pointing to am_open, pointing to am_close.
Figure 2. Processing a CREATE INDEX statement
Flowchart shows am_create pointing to am_open, pointing to am_insert key, pointing to a box that says "More rows?" If the answer is Yes, am_insert key is executed again in a loop until the answer is No. If the answer is No, am_close is executed.

Copyright© 2019 HCL Technologies Limited