Any manual about interperting Information center SQL statements reference?

[l***@gmail.com]

Hi
thank you for reading my post
Is there any manual about interperting sql statement references which you can find in information center?

for example, what can be meaning of following statement?

[code]
Skip visual syntax diagram>>-CREATE--+-----------------------+---------------------------->
+-LARGE-----------------+
+-REGULAR---------------+
| .-SYSTEM-. |
'-+--------+--TEMPORARY-'
'-USER---'

--TABLESPACE--tablespace-name---------------------------------->
--+-----------------------------------------------------------+-->

| .-DATABASE PARTITION GROUP-. |
'-IN--+--------------------------+--db-partition-group-name-'

--+--------------------------+--------------------------------->

'-PAGESIZE--integer--+---+-'
'-K-'

.-MANAGED BY--AUTOMATIC STORAGE--| size-attributes |---------------------.

--+------------------------------------------------------------------------+-->

'-MANAGED BY--+-SYSTEM--| system-containers |--------------------------+-'
'-DATABASE--| database-containers |--| size-attributes |-'

--+---------------------------------+-------------------------->

'-EXTENTSIZE--+-number-of-pages-+-'
'-integer--+-K-+--'
'-M-'

--+-----------------------------------+------------------------>

'-PREFETCHSIZE--+-number-of-pages-+-'
'-integer--+-K-+--'
+-M-+
'-G-'

--+-----------------------------+------------------------------>

'-BUFFERPOOL--bufferpool-name-'

--+----------------------------------+------------------------->

'-OVERHEAD--number-of-milliseconds-'

.-FILE SYSTEM CACHING----.

--+------------------------+----------------------------------->

'-NO FILE SYSTEM CACHING-'

--+--------------------------------------+--------------------->

'-TRANSFERRATE--number-of-milliseconds-'

--+---------------------------------+-------------------------><

'-DROPPED TABLE RECOVERY--+-ON--+-'
'-OFF-'

size-attributes:

|--+---------------------+--+-----------------------------+----->
'-AUTORESIZE--+-NO--+-' '-INITIALSIZE--integer--+-K-+-'
'-YES-' +-M-+
'-G-'

--+------------------------------------+----------------------->

'-INCREASESIZE--integer--+-PERCENT-+-'
'-+-K-+---'
+-M-+
'-G-'

--+-----------------------------+------------------------------|

'-MAXSIZE--+-integer--+-K-+-+-'
| +-M-+ |
| '-G-' |
'-NONE-----------'

system-containers:

.----------------------------------------------------------------------.
| .-,------------------. |
V V | |
|----USING--(----'container-string'-+--)--+-----------------------------+-+--|
'-| on-db-partitions-clause |-'

database-containers:

.--------------------------------------------------------------.
V |
|----USING--| container-clause |--+-----------------------------+-+--|
'-| on-db-partitions-clause |-'

container-clause:

.-,---------------------------------------------------.
V |
|--(----+-FILE---+--'container-string'--+-number-of-pages-+-+--)--|
'-DEVICE-' '-integer--+-K-+--'
+-M-+
'-G-'

on-db-partitions-clause:

|--ON--+-DBPARTITIONNUM--+-------------------------------------->
'-DBPARTITIONNUMS-'

.-,--------------------------------------------------.
V |

--(----db-partition-number1--+--------------------------+-+--)--|

'-TO--db-partition-number2-'

[/code]

[Knut Stolze]

Post by l***@gmail.com
Hi
thank you for reading my post
Is there any manual about interperting sql statement references which you
can find in information center?
for example, what can be meaning of following statement?
[code]

Post by l***@gmail.com
-CREATE--+-----------------------+---------------------------->

+-LARGE-----------------+
+-REGULAR---------------+
| .-SYSTEM-. |
'-+--------+--TEMPORARY-'
'-USER---'

--TABLESPACE--tablespace-name---------------------------------->
--+-----------------------------------------------------------+-->

| .-DATABASE PARTITION GROUP-. |
'-IN--+--------------------------+--db-partition-group-name-'

--+--------------------------+--------------------------------->

'-PAGESIZE--integer--+---+-'
'-K-'
.-MANAGED BY--AUTOMATIC STORAGE--| size-attributes
|---------------------.

--+------------------------------------------------------------------------+-->

'-MANAGED BY--+-SYSTEM--| system-containers
|--------------------------+-'
'-DATABASE--| database-containers |--| size-attributes
|-'

--+---------------------------------+-------------------------->

'-EXTENTSIZE--+-number-of-pages-+-'
'-integer--+-K-+--'
'-M-'

--+-----------------------------------+------------------------>

'-PREFETCHSIZE--+-number-of-pages-+-'
'-integer--+-K-+--'
+-M-+
'-G-'

--+-----------------------------+------------------------------>

'-BUFFERPOOL--bufferpool-name-'

--+----------------------------------+------------------------->

'-OVERHEAD--number-of-milliseconds-'
.-FILE SYSTEM CACHING----.

--+------------------------+----------------------------------->

'-NO FILE SYSTEM CACHING-'

--+--------------------------------------+--------------------->

'-TRANSFERRATE--number-of-milliseconds-'

--+---------------------------------+-------------------------><

'-DROPPED TABLE RECOVERY--+-ON--+-'
'-OFF-'
|--+---------------------+--+-----------------------------+----->
'-AUTORESIZE--+-NO--+-' '-INITIALSIZE--integer--+-K-+-'
'-YES-' +-M-+
'-G-'

--+------------------------------------+----------------------->

'-INCREASESIZE--integer--+-PERCENT-+-'
'-+-K-+---'
+-M-+
'-G-'

--+-----------------------------+------------------------------|

'-MAXSIZE--+-integer--+-K-+-+-'
| +-M-+ |
| '-G-' |
'-NONE-----------'
.----------------------------------------------------------------------.
| .-,------------------.
| |
V V |
|
|----USING--(----'container-string'-+--)--+-----------------------------+-+--|
'-| on-db-partitions-clause |-'
.--------------------------------------------------------------.
V |
|----USING--| container-clause |--+-----------------------------+-+--|
'-| on-db-partitions-clause |-'
.-,---------------------------------------------------.
V |
|--(----+-FILE---+--'container-string'--+-number-of-pages-+-+--)--|
'-DEVICE-' '-integer--+-K-+--'
+-M-+
'-G-'
|--ON--+-DBPARTITIONNUM--+-------------------------------------->
'-DBPARTITIONNUMS-'
.-,--------------------------------------------------.
V |

--(----db-partition-number1--+--------------------------+-+--)--|

'-TO--db-partition-number2-'
[/code]

That's a regular syntax diagram. All products that support some sort of
syntax for commands have something like that. BNFs (Backus-Naur-Forms) are
comparable.

As for reading such diagrams, you will find an explanation here:
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.dzic.doc/commonsyn.htm