New clauses have been added to the SQL CREATE TABLE statement to allow you to create distributed files with SQL. These additions are shown below:
>>-CREATE TABLE--(--column definitions--)-----------------------> >--+--------------------------------------------------+-------->< '-IN--+-nodegroup-------------+--| partition key |-' +-library--/--nodegroup-+ '-library--.--nodegroup-' partition key: |--+-------------------------------------------------------+----| | .-,------. | | V | .-USING HASHING-. | '-PARTITIONING KEY--(----column-+--)--+---------------+-'
For more information about using SQL commands in ILE COBOL programs, refer to "Including Structured Query Language (SQL) Statements in Your ILE COBOL Program".
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.