ILE COBOL Programmer's Guide

SQL Statement Additions for Distributed Data Files

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".


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]