|
| Any manual about interperting Information center SQL statements |
 |
Tue, 14 Aug 2007 15:22:39 EDT |
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-'
|
| Post Reply
|
| Re: Any manual about interperting Information center SQL statements reference? |
 |
Wed, 15 Aug 2007 13:51:57 +020 |
legolas.w@gmail.com wrote:
> 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]
> >>-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]
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/co
mmonsyn.htm
--
Knut Stolze
DB2 z/OS Utilities Development
|
| Post Reply
|
|
|
|
|
|
|
|
|
|