This is an old revision of the document!



Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

Sqlways.ini File - Section [HPNonStop]

This article describes sqlways.ini file [HPNonStop] section and the options it contains.

Option name Description
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.
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 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_MULTILINE_TO_SINGLELINE_COMMENT This option controls the way the multi-line comments are converted to HP NonStop SQL/MX. The default 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.
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.
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”.
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.
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_DEFAULT_ATTRIBS This option defines whether the 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


Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays


© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.