Create Options

Home | Previous Page | Next Page Data Migration Utilities > The onunload and onload Utilities > Syntax of the onload Command >

Create Options

Create Options:
 
   .---------------------------------------.
   V                                       |
|----+- -c--oldcnstrnt--newcnstrnt-------+-+-------------------->
     +- -i--oldindex--newindex-----------+
     +- -fd--oldbsp--newdbsp-------------+
     '- -fi--indexname--olddbsp--newdbsp-'
 
>--database--+------------------------+-------------------------|
             '-:--+----------+--table-'
                  '-owner--.-'

Element	Purpose	Key Considerations
-c oldcnstrnt newcnstrnt	Directs onload to rename the specified constraint.	None.
-i oldindex newindex	Directs onload to rename the table index when it stores the index on disk.	Additional Information: Use the -i option to rename indexes during the load to avoid conflict with existing index names. References: Syntax must conform to the Identifier segment; see the IBM Informix: Guide to SQL Syntax.
-fd olddbsp newdbsp	Allows you to move a data fragment from one dbspace to another.	Restriction: The new dbspace must exist and not already contain another data fragment for the table. Additional Information: This option is used with parallel data query (PDQ) and table fragmentation.
-fi indexname olddbs newdbsp	Allows you to move index fragments from one dbspace to another.	Restriction: The new dbspace must exist and not already contain another index fragment for the table. Additional Information: This option is used with PDQ and table fragmentation.
database	Specifies the name of the database	Restriction: The database name cannot include a database server name, such as database@dbservername. References: Syntax must conform to the Identifier segment; see the IBM Informix: Guide to SQL Syntax.
owner.	Specifies the owner of the table	Restriction: The owner name must not include illegal characters. References: For pathname syntax, refer to your operating-system documentation.
table	Specifies the name of the table	Restriction: The table must not exist. References: Syntax must conform to the Table Name segment; see the IBM Informix: Guide to SQL Syntax.

If you do not specify any create options, the onload utility stores the database or table in the root dbspace.

You can use the -c, -i, -fd, and -fi options in any order and as often as necessary as long as you use unique pairs.