About Ispirer Systems
Ispirer Home Page Database Migration Application Conversion Downloads
Sqlways.ini File - Section [HPNonStop]
This article describes sqlways.ini file's [HPNonStop] section and the options it contains.
Option name | Description |
---|---|
TARGET_VERSION | Specifies the target version for HP NonStop SQL/MX database. |
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. |
USER | Specifies the user name that is used in generated scripts for HP NonStop SQL/MX. |
PWD | Specifies the user password that is used in generated scripts 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. |
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 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 value is “No”. |
DEFAULT_STORAGE | This option controls the partitioning mechanism used 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 allows you to 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 allows you to 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 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 | 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. |
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”. |
ADD_DEFAULT_ATTRIBS | This option defines whether SQLWays will add default values for table and index attributes in HPNonStop, like LOCATION, AUDITCOMPRESS, BLOCKSIZE, CLEARONPURGE, EXTENT, MAXEXTENTS. Possible values - “Yes”, “No” or Empty. Default value - “Yes”. For more information about default values of these attributes, please contact our support team. |
Example:
[Postgre] HOST=hostname DATABASE=test USER=tester