# Differences

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

sqlways:command-line:sqlways-ini:hpnonstop-section [September 20, 2018, 02:56:43 PM]
alexandr.kirpichny
sqlways:command-line:sqlways-ini:hpnonstop-section [October 12, 2018, 09:01:10 AM] (current)
darya.prikhodkina
Line 8: Line 8:
^  Option name  ^ Description  ^  ^  Option name  ^ Description  ^
| **TARGET_VERSION** | Specifies the target version for the HP NonStop SQL/MX database. | | **TARGET_VERSION** | Specifies the target version for the HP NonStop SQL/MX database. |
-| **HOST** | Specifies a remote host name where the target HP NonStop SQL/MX database resides. |+| **HOST** | Specifies a remote host name where the target HP NonStop SQL/MX database is located. |
| **DATABASE** | Specifies the database name that is used in generated scripts for HP NonStop SQL/MX. | | **DATABASE** | Specifies the database name that is used in generated scripts for HP NonStop SQL/MX. |
| **USER** | Specifies the user name that is used in generated scripts for HP NonStop SQL/MX. | | **USER** | Specifies the user name that is used in generated scripts for HP NonStop SQL/MX. |
Line 14: Line 14:
| **PORT** | Specifies the database server port for HP NonStop SQL/MX. | | **PORT** | Specifies the database server port for HP NonStop SQL/MX. |
| **BIN** | Specifies the directory where HP NonStop SQL/MX utilities are located. | | **BIN** | Specifies the directory where HP NonStop SQL/MX utilities are located. |
-| **USE_CONVERT_VARCHAR_TO_CHAR** | This option controls whether to convert VARCHAR data type to CHAR data type while converting to HP NonStop SQL/MX. The upper limit of VARCHAR size for which the conversion is required is controlled by **CONVERT_VARCHAR_TO_CHAR** option. The default is Yes. | +| **USE_CONVERT_VARCHAR_TO_CHAR** | This option controls whether to convert VARCHAR data type to CHAR data type while converting to HP NonStop SQL/MX. The upper limit of VARCHAR size for which the conversion is required is controlled by **CONVERT_VARCHAR_TO_CHAR** option. The default value is Yes. |
-| **CONVERT_VARCHAR_TO_CHAR** | This option controls the upper limit of VARCHAR size for which the conversion from VARCHAR to CHAR is required. The optimized default is 20. | +| **CONVERT_VARCHAR_TO_CHAR** | This option controls the upper limit of VARCHAR size for which the conversion from VARCHAR to CHAR is required. The optimal default value is 20. |
-| **CONVERT_MULTILINE_TO_SINGLELINE_COMMENT** | This option controls the way the multi-line comments are converted to HP NonStop SQL/MX. The default is No. | +| **CONVERT_MULTILINE_TO_SINGLELINE_COMMENT** | This option controls the way the multi-line comments are converted to HP NonStop SQL/MX. The default value is No. |
-| **DEFAULT_STORAGE** | This option controls the partitioning mechanism to use while converting to HP NonStop SQL/MX. The default is HASH_PARTITION_BY, which means that HASH PARTITION is used as the default. | +| **DEFAULT_STORAGE** | This option controls the partitioning mechanism to use while converting to HP NonStop SQL/MX. The default value is HASH_PARTITION_BY, which means that HASH PARTITION is used by default. |
-| **RANGE_PART_XML_GEN** | This option lets you collect the information about RANGE PARTITIONS while doing the conversion from Oracle to HP NonStop SQL/MX. If this option is specified as Yes, the range_part_spec.xml file is generated during the conversion. This file can be subsequently used for RANGE PARTITION conversion from Oracle database/script to HP NonStop SQL/MX. The default is No. |+| **RANGE_PART_XML_GEN** | This option lets you collect the information about RANGE PARTITIONS while doing the conversion from Oracle to HP NonStop SQL/MX. If this option is set to Yes, the range_part_spec.xml file is generated during the conversion. This file can be subsequently used for RANGE PARTITION conversion from Oracle database/script to HP NonStop SQL/MX. The default value is No. |
| **PARTITION_FILE** | This option lets you specify the location of the generated range_part_spec.xml file for RANGE PARTITION conversion from Oracle to HP NonStop SQL/MX. The location is specified as the absolute path to file, e.g.: **S:\Sqlways\Oracle\Ispirer\HPNonStop\Range_partition_conversion\range_part_spec.xml** | | **PARTITION_FILE** | This option lets you specify the location of the generated range_part_spec.xml file for RANGE PARTITION conversion from Oracle to HP NonStop SQL/MX. The location is specified as the absolute path to file, e.g.: **S:\Sqlways\Oracle\Ispirer\HPNonStop\Range_partition_conversion\range_part_spec.xml** |
-| **DATA_INSERT** | This option controls the way the source data will be extracted and prepared to be loaded into the target database. If this option is set to "Single", then only one INSERT statement will be generated and it will include all the data from a table. If "Multiple" is used, INSERT statement will be generated for each row of a table. If "Prepare" is used - PREPARE statement will be generated with INSERT, and data will be passed as parameters to the INSERT statement, while being executed. \\ Possible values - "Single", "Multiple", "Prepare".  \\ Default value - "Multiple". | +| **DATA_INSERT** | This option controls the way the source data is extracted and prepared for the loading to the target database. If this option is set to "Single", then only one INSERT statement will be generated and it will include all the data from a table. If "Multiple" is used, INSERT statement will be generated for each row of a table. If "Prepare" is used - PREPARE statement will be generated with INSERT, and data will be passed as parameters to the INSERT statement, while being executed. \\ Possible values - "Single", "Multiple", "Prepare".  \\ Default value - "Multiple". |
-| **SINGLE_INSERT_BUFFER_SIZE** | It controls the maximum size of data in bytes in INSERT statement, that will be generated to load the data into HPNonStop. This option works only for cases when option DATA_INSERT is set to "Single". \\ Default value - 32000. |+| **SINGLE_INSERT_BUFFER_SIZE** | Controls the maximum size of data in bytes in INSERT statement, that will be generated to load the data into HPNonStop. This option works only for cases when option DATA_INSERT is set to "Single". \\ Default value - 32000. |
| **EXT_PATH** | This option defines the external path clause in the generated NONSTOP procedures. | | **EXT_PATH** | This option defines the external path clause in the generated NONSTOP procedures. |
-| **ADD_SPJMETHOD** | This option defines how to add the spj method to the generated methods. If this option is set to "Yes" - add spjmethods for all methods. If it is set to "[path_to_file]" - spj will be added only for specified method. \\ Default value - "Yes".|+| **ADD_SPJMETHOD** | This option defines how to add the spj method to the generated methods. If this option is set to "Yes", spj methods will be added for all methods. If it is set to "[path_to_file]" - spj will be added only for the specified method. \\ Default value - "Yes".|