Ispirer Ispirer
 

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

sqlways:command-line:sqlways-ini:hirdb-section [October 23, 2018, 12:41:39 PM]
alexandr.kirpichny created
sqlways:command-line:sqlways-ini:hirdb-section [January 25, 2019, 01:00:44 PM] (current)
darya.prikhodkina
Line 13: Line 13:
 | **PORT** | Specifies the port number that will be used to connect to HIRDB database. | | **PORT** | Specifies the port number that will be used to connect to HIRDB database. |
 | **BIN** | Specifies the path to the folder where PDSQL native utility is located on local machine. This utility will be used to load the converted object into the HIRDB database. | | **BIN** | Specifies the path to the folder where PDSQL native utility is located on local machine. This utility will be used to load the converted object into the HIRDB database. |
-| **USE_LOAD_COMMAND** | If Yes is specified, the LOAD command is used to move data into the database. Possible values - Yes, No. The default value is No. | +| **USE_LOAD_COMMAND** | If "Yesis specified, the LOAD command is used to move data into the database. Possible values - Yes, No. The default value is No. | 
-| **LOAD_FROM_CLIENT** | If Yes is specified, the CLIENT option is used in the LOAD command. This option specifies that the data can reside on a remote client. Otherwise, the data must reside on the HIRDB server. \\ Possible values - Yes, No. The default value is No. | +| **LOAD_FROM_CLIENT** | If "Yesis specified, the CLIENT option is used in the LOAD command. This option specifies that the data can reside on a remote client. Otherwise, the data must reside on the HIRDB server. \\ Possible values - Yes, No. The default value is No. | 
-| **LOAD_NONRECOVERABLE** | If Yes is specified, the NONRECOVERABLE option is added to the LOAD command. This option specifies that the load transaction is to be marked as non-recoverable, and that it will not be possible to recover it by a subsequent roll forward action. \\ With this option, when the database is configured to support online backups, table spaces are not put in backup pending state following the load operation. \\ Possible values - Yes, No. The default value is No. | +| **LOAD_NONRECOVERABLE** | If "Yesis specified, the NONRECOVERABLE option is added to the LOAD command. This option specifies that the load transaction is to be marked as non-recoverable, and that it will not be possible to recover it by a subsequent roll forward action. \\ With this option, when the database is configured to support online backups, table spaces are not put in backup pending state following the load operation. \\ Possible values - Yes, No. The default value is No. | 
-| **IMPORT_OPTION** | Specifies a mode, under which the import utility will execute. Possible values are INSERT (Adds the imported data to the table without changing the existing table data), INSERT_UPDATE (Adds rows of imported data to the target table, or updates existing rows of the target table with matching primary keys) and REPLACE (Deletes all existing data from the table by truncating the data object, and inserts the imported data. The table definition and the index definitions are not changed). The default mode is INSERT. | +| **IMPORT_OPTION** | Specifies a mode, under which the import utility will be executed. Possible values are INSERT (Adds the imported data to the table without changing the existing table data), INSERT_UPDATE (Adds rows of imported data to the target table, or updates existing rows of the target table with matching primary keys) and REPLACE (Deletes all existing data from the table by truncating the data object, and inserts the imported data. The table definition and the index definitions are not changed). The default mode is INSERT. | 
-| **LOAD_OPTION** | Specifies a mode, under which the load utility will execute. Possible values are INSERT (Adds the loaded data to the table without changing the existing table data) and REPLACE (Deletes all existing data from the tableand inserts the loaded data. The table definition and index definitions are not changed). The default mode is INSERT. |+| **LOAD_OPTION** | Specifies a mode, under which the load utility will execute. Possible values are INSERT (Adds the loaded data to the table without changing the existing table data) and REPLACE (Deletes all existing data from the table and inserts the loaded data. The table definition and index definitions are not changed). The default mode is INSERT. |
 | **MODIFIEDBY_OPTIONS** | Specifies additional options that are added to the modified by option of the IMPORT and LOAD utilities. \\ Some options like character, column delimiters and others are added to the IMPORT/LOAD scripts by SQLWays. You can use this option if you need other options to be added to the modified by option. \\ For example, set modifiedby_options=usedefaults delprioritychar and these options will be added to the modified by option in each script for the IMPORT/LOAD utilities. | | **MODIFIEDBY_OPTIONS** | Specifies additional options that are added to the modified by option of the IMPORT and LOAD utilities. \\ Some options like character, column delimiters and others are added to the IMPORT/LOAD scripts by SQLWays. You can use this option if you need other options to be added to the modified by option. \\ For example, set modifiedby_options=usedefaults delprioritychar and these options will be added to the modified by option in each script for the IMPORT/LOAD utilities. |
 | **TABLESPACE** | Specifies the table space in which the tables will be created. The table space must exist, and be a REGULAR table space. If no other table space is specified, all table parts will be stored in this table space. The default value is USERSPACE1. | | **TABLESPACE** | Specifies the table space in which the tables will be created. The table space must exist, and be a REGULAR table space. If no other table space is specified, all table parts will be stored in this table space. The default value is USERSPACE1. |
-| **TABLESPACE_DATABASE_NAME** | This option will add IN [database_name] clause to the converted table definitionthat controls in what database this table should be created. \\ By default this option is empty. |+| **TABLESPACE_DATABASE_NAME** | This option will add IN [database_name] clause to the converted table definition that controls in what database this table should be created. \\ By default this option is empty. |
 | **INDEX_TABLESPACE** | Specifies the table space in which any indexes on the tables will be created. The specified table space must exist, be a REGULAR DMS table space. | | **INDEX_TABLESPACE** | Specifies the table space in which any indexes on the tables will be created. The specified table space must exist, be a REGULAR DMS table space. |
 | **LONG_TABLESPACE** | Specifies the table space in which the values of any long columns (LONG VARCHAR, LONG VARGRAPHIC, LOB data types) will be stored. The table space must exist, be a LONG DMS table space. | | **LONG_TABLESPACE** | Specifies the table space in which the values of any long columns (LONG VARCHAR, LONG VARGRAPHIC, LOB data types) will be stored. The table space must exist, be a LONG DMS table space. |
 | **DOUBLE_SIZE_CHARACTERS_DATA_TYPES** | If this option is set to "Yes", SQLWays will double the size of the character columns in the converted tables. \\ Possible values - "Yes", "No" or Empty. Default value - "No" or Empty. | | **DOUBLE_SIZE_CHARACTERS_DATA_TYPES** | If this option is set to "Yes", SQLWays will double the size of the character columns in the converted tables. \\ Possible values - "Yes", "No" or Empty. Default value - "No" or Empty. |
-| **IXF_SB_CODE_PAGE** | This option specifies Single-Byte codepage, that will be used in the .IXF file, generated during the conversion step.  | +| **IXF_SB_CODE_PAGE** | This option specifies Single-Byte codepage, that will be used in the .IXF file, generated during the conversion.  | 
-| **IXF_DB_CODE_PAGE** | This option specifies Double-Byte codepage, that will be used in the .IXF file, generated during the conversion step. | +| **IXF_DB_CODE_PAGE** | This option specifies Double-Byte codepage, that will be used in the .IXF file, generated during the conversion. | 
-| **USE_SOURCE_TABLESPACE_NAMES** | This option specifies whethe to use original tablespace names in the converted objects. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No" or Empty. | +| **USE_SOURCE_TABLESPACE_NAMES** | This option specifies whether to use original tablespace names in the converted objects. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No" or Empty. | 
-| **PREFETCH_SIZE** | This option identifies the number of rows you want to read from the datafile before data save for Direct path loads. The default is to read all the rows and save data at the end of the load. |+| **PREFETCH_SIZE** | This option identifies the number of rows you want to read from the datafile before data saving for Direct path loads. The default is to read all the rows and save data at the end of the load. |
  
  
sqlways/command-line/sqlways-ini/hirdb-section.txt · Last modified: January 25, 2019, 01:00:44 PM by darya.prikhodkina
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement