About Ispirer Systems

Ispirer Home Page Database Migration Application Conversion Downloads


Sqlways.ini File - Section [COMMON]

This article describes sqlways.ini file’s [COMMON] section and the options it contains.

Option name Description
DSN Data source name.
USER User name.
PWD Password.
TARGET Target database.
TARGET_PRODUCT Target database product.
TARGET_VERSION Target database version.
IMPORT_ORDER Migration sequence. Default value: “Clean”.
IMPORT_SYSTEM Import system. Default value: Windows.
DIR Export directory.
LOBDIR Directory for LOB files. By default, Ispirer SQLWays Wizard will store LOB files in the Export directory.
IMPORT_DIR Import directory.
IMPORT_LOBDIR Import directory for LOB files.
OUTFORMAT Output text format.
PREFETCHROWS Prefetch count. Default value: 1000.
NONSTOP Continue when an error occurs. Default value: “Yes”.
REGISTRATION_NAME Specifies the registration name.

This option can be used for custom tool fixes or when access to the registry to read license information is restricted.
REGISTRATION_NUMBER Specifies the registration number.

Use this option if access to the registry to read license information is restricted.
TEST This option controls whether to generate testing scripts for destination database. More information about how to use this option can be found in this article: How to Test Converted SQL Code
Possible values: “Yes”, “No” or Empty.
Default value: “No” or Empty.
MAX_NUMBER_OF_TEST_CALLS Controls the number of calling statements for option TEST. The default value is 10.
GENRPT Option that controls whether to generate the HTML report or not. The default value is “Yes”. Possible values: “Yes”, “No”.
CONVERT_VIEW2TABLE Option that controls whether to convert all selected views to tables or not. The data for the tables will be extracted from the source database using the select provided in a view. Default value: “No”. Possible values: “Yes”, “No”.
FN_WITH_EXC2SP Whenever there is EXEPTION block with WHEN OTHERS inside the function it will be converted to procedure with TRY CATCH block. Default value: “No” or Empty. Possible values: “Yes”, “No”.
OPTION_VARYING_PARSING Option that controls the way the delimited identifiers from Informix are parsed.

By default double quotes in Informix represent the string literal. This behavior can be changed by using the DELIMIDENT option. If DELIMIDENT option is set to ON, one can use double quotes to represent the delimited identifiers in Informix database. So, if the BL object like Stored Procedure or UDF is created with this option and uses delimited identifiers inside, even if the option is OFF, the BL still will be working correctly.

The tool tries to parse double quotes as the string literal first, using the OPTION_VARYING_PARSING option. If the parser error arises, the source code is parsed as if the DELIMIDENT is set to ON - like a delimited identifier.

Possible values: “Yes”, “No”.
CONVERT_VIEW2TABLE When this option is set to “Yes” all views selected for conversion are converted to tables. Data for such tables is retrieved using select statements of these views. Default value: “No”. Possible values: “Yes”, “No”.
USE_ODBC_FUNCTIONS When this option is set to “Yes”, only ODBC functions will be used to extract data from the source database. Default value: “No”. Possible values: “Yes”, “No”.
PRECACHE_OBJECTS This option increases productivity of the tool when working with large databases. When you need to convert a number of tables that is greater than the number defined in PRECACHE_TABLES_COUNT option, optimization is turned on. Default value: “True”. Possible values: “True”, “False”.
PRECACHE_TABLES_COUNT This option defines the minimum number of tables, which will be precached if PRECACHE_OBJECTS is set to “True”. Default value: 100.
SUB_QUERY2VIEW Option that controls whether to convert the sub-queries from WITH Clause into Views or not. The views in this case are created before the whole query and sub-query aliases are left the same as in the source. The conversion works when the option is set to “Yes”. Default value: “No”.
USE_ANSI_CAST When this option is set to “Yes”, only ANSI SQL scalar function CAST is used to convert values from one datatype to another. Default value: “No”. Possible values: “Yes”, “No”.
Supported directions:
Sybase ASA to PostgreSQL
LOGICAL_FILES_PATH To migrate Logical Files from DB2 AS400 you need to provide the path to the files that will store LF definition. SQLWays Wizard will be able to read and analyze such description and convert it to the view in the target database. This option should be set only if you are migrating from DB2 AS400 and need to convert Logical Files.
SOURCE_DB Option that defines source database for Embedded SQL conversion.
TARGET_DB Option that defines target database for Embedded SQL conversion.
API_SOURCE_DB Option that defines database API for source database for Embedded SQL conversion.
API_TARGET_DB Option that defines database API for target database for Embedded SQL conversion.
API_SOURCE_DB_VERSION Option that defines version of database API for source database for Embedded SQL conversion.
API_TARGET_DB_VERSION Option that defines version of database API for target database for Embedded SQL conversion.
PLACE_COMMENTED_SOURCE_END This option controls where the commented source code of the object will be located in the generated SQL file. If this options is set to “Yes”, the commented source code will be placed at the end of the file. If this option is set to “No”, the commented source code will be placed at the beginning of the SQL file.
Possible values: “Yes”, “No” or Empty.
Default value: “No”.
LICENSE_INFO This option generates the information about the date and time of conversion, version and license owner inside the converted SQL code.
Possible values: “Yes”, “No” or Empty.
Default value: “No” or Empty.
GENERATE_VERSION_TIMESTAMP This option generates the information about the date/time of conversion and version of the tool in the SQL code.
Possible values: “Yes”, “No” or Empty.
Default value: “No” or Empty.
FB_DIALECT This option defines the dialect number that will be used to connect to FIREBIRD database.
CACHE_OBJECTS_COUNT This option defines the number of objects that should be specified for conversion to launch the cache system for objects. If number of specified object is bigger than the number provided in the option, cache system will be launched. If number of objects is less, common conversion will be used.
PARSE_DIRECTIVES This option defines whether the toolkit should parse the directives in the C++ code.
Possible values: “Yes”, “No” or Empty.
Default value: “Yes”.
REMOVE_SRC_FORMATTING This option removes source code formatting by removing extra separators for COBOL to JAVA direction.
Possible values: “Yes”, “No” or Empty.
Default value: “No” or Empty.
DETAIL_REPORT If this option is set to “Yes”, detail report with the information about the converted objects will be generated and placed to the export directory in “Reports” folder.
Possible values: “Yes”, “No” or Empty.
Default value: “No” or Empty.
USE_SP_PRIMARYKEY By default our tool shouldn't extract primary keys that were defined using the “sp_primarykey” system procedure in Sybase ASE database. But if we set this option to “Yes”, the tool will also convert the primary key defined with “sp_primarykey” system procedure.
Possible values: “Yes”, “No” or Empty.
Default value: “No” or Empty.
OMIT_ORACLE_HINTS Since Oracle hints are specific only for Oracle database, by default these pieces of code are commented. If OMIT_ORACLE_HINTS option is set to “Yes”, all Oracle hints will be omitted during the conversion.
Possible values: “Yes”, “No” or Empty.
Default value: “No” or Empty.
SHORTCUT_JOINS This option defines whether the OUTER keyword should be removed from Joins. If this option is set to “Yes”, then OUTER will be removed.
Possible values: “Yes”, “No” or Empty.
Default value: “No” or Empty.
EMBEDDED_SQL_CONVERSION_OFF This option switch off conversion of embedded statements that contains keywords specified in this option. User can specify multiple keywords using comma ”,” as a separator.
Default value - Empty.
PATTERNS_LOGS If it is set to Yes, detailed information about the execution time of each conversion template will be collected after the conversion is started, and then saved to an xml file in the PatternsLogs directory.
After the conversion, the PatternsLogs folder will be created in the export directory.
Possible values: “Yes”, “No” or Empty. Default value: “No” or Empty.
IMPORT_CLIENT_OPTIONS This option addes the additional import parameters to command line which specified in this option for target MySQL.
Possible values: https://dev.mysql.com/doc/refman/8.0/en/mysql-command-options.html or Empty. Default value: Empty. \\Usage example
SOURCE_ENCODING Option specifies in which encoding the source files are. If you specify the value of this option incorrectly, then SQLWays will incorrectly subtract the file.
Possible values: ANSI, UTF8, UTF16BE.
Default value: ANSI.
TARGET_ENCODING Option specifies in which encoding SQLWays will write the output files.
Possible values: ANSI, UTF8.
Default value: ANSI.
DESIGN_PATTERN For Informix 4GL to C# the option operates the following way:
This parameter determines whether the source files should be converted to controllers with Swaggers-attributes to the one direction only
Source Type: Application.
Source Technology: Informix 4GL

Target Type: Application.
Application
Type: Web.
Software Platform: .NET
Programming Language: C#
UI Type: ASPNET.
or not.
It is located in the [Common] section.
If the option is set to “Swagger”, then source files should be converted to controllers with Swaggers-attributes.
If the option is set to Empty, then source files should be converted to regular controllers.
Possible values: “Swagger” or Empty. Default value: “Swagger.
Usage example
For Delphi, Pascal, Oracle Forms, CPP, PB Scripts the option operates the following way:
Parameter determines whether source files should be converted to *.cs files using the MVVM pattern and the Ispirer - framework
Source Type: Application.
Source Technology: Delphi or Pascal or Oracle Forms or CPP or PBScripts

Target Type: Application.
Application Type: Desktop.
Software Platform: .NET
Programming Language: C#
UI Type: WPF.
or not.
It is located in the [Common] section.
If the option is set to “MVVM”, then source files should be converted to files with MVVM - pattern.
If the option is set to Empty, then source files should be converted to regular files.
Possible values: “MVVM” or Empty. Default value: “MVVM.
Usage example
TABLES_DDL You can specify the path to the saved ddl of tables so that it can be used during conversion to determine the list and types of columns.
To do this, set the path to this file in the settings, for example: TABLES_DDL=d:\Migration\tables.sql
Possible values: Path and Empty.
Default value: Empty.
Usage example
OBJECT_INFO Option that enables statistics collection. It functions if source=target.
The option parses the file and collects information on it, recording it to statistics_tmp.xml, then combines the information between files and records it to the Statistics.xml file.
Possible values: “Yes” or “No”.
Default value: “No”.
OBJECT_INFO_DIR Default value: DSN, the path where the statistics file and other files with additional information about the conversion, such as TableInfo.ddl, Statistics.xml, etc., are located.
During the conversion via the path, it invokes the statistics file.
ORACLE_USE_PREPROCESSOR Please note: the option works only for the source Oracle database!
Starting with Oracle database 10g, conditional compilation is allowed for objects. The compiler compiles selected parts of the program based on the conditions you specify with the $IF directive.
This option determines whether objects should be precompiled before conversion.
Possible values: “Yes”, “No”.
Default value: “No”.
Usage example
BEFORE_IMPORT_SCRIPT Option specifying the path to the SQL script that will be executed before starting import of all objects. The script is started automatically if the path is specified.
Possible values: path to SQL script.
Default value: Empty (no bat file is created).
AFTER_IMPORT_SCRIPT Option specifying the path to the SQL script that will be executed after import of all objects is completed. The script is run automatically if the path is specified.
Possible values: path to SQL script.
Default value: Empty (no bat file is created).

Example:

[common]
registration_name = ABC Inc. 
registration_number = XXXX-YYYY-ZZZZ


If you have any questions about the supported options and features, please contact our technical team: support@ispirer.com