Differences
This shows you the differences between two versions of the page.
sqlways:command-line:sqlways-ini:common-section [January 18, 2019, 12:47:56 PM] – darya.prikhodkina | sqlways:command-line:sqlways-ini:common-section [May 31, 2023, 05:28:08 PM] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
\\ | \\ | ||
- | [[http:// | + | [[https:// |
- | [[http:// | + | [[https:// |
- | [[http:// | + | [[https:// |
====== Sqlways.ini File - Section [COMMON] ====== | ====== Sqlways.ini File - Section [COMMON] ====== | ||
- | This article describes sqlways.ini file [COMMON] section and the options it contains. | + | This article describes sqlways.ini file’s [COMMON] section and the options it contains. |
^ Option name ^ Description | ^ Option name ^ Description | ||
| **DSN** | Data source name. | | | **DSN** | Data source name. | | ||
Line 13: | Line 13: | ||
| **TARGET_PRODUCT** | Target database product. | | | **TARGET_PRODUCT** | Target database product. | | ||
| **TARGET_VERSION** | Target database version. | | | **TARGET_VERSION** | Target database version. | | ||
- | | **IMPORT_ORDER** | Migration sequence. The default value is Clean. | | + | | **IMPORT_ORDER** | Migration sequence. The default value is “Clean”. | |
| **IMPORT_SYSTEM** | Import system. The default value is Windows. | | | **IMPORT_SYSTEM** | Import system. The default value is Windows. | | ||
| **DIR** | Export directory. | | | **DIR** | Export directory. | | ||
- | | **LOBDIR** | Directory for LOB files. By default Ispirer SQLWays Wizard will store LOB files in the 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_DIR** | Import directory. | | ||
| **IMPORT_LOBDIR** | Import directory for LOB files. | | | **IMPORT_LOBDIR** | Import directory for LOB files. | | ||
| **OUTFORMAT** | Output text format. | | | **OUTFORMAT** | Output text format. | | ||
| **PREFETCHROWS** | Prefetch count. The default value is 1000. | | | **PREFETCHROWS** | Prefetch count. The default value is 1000. | | ||
- | | **NONSTOP** | Continue when an error occurs. The default value is Yes. | | + | | **NONSTOP** | Continue when an error occurs. The default value is “Yes”. | |
- | | **REGISTRATION_NAME** | Specifies the registration name. \\ \\ This option can be used for custom | + | | **REGISTRATION_NAME** | Specifies the registration name. \\ \\ This option can be used for custom |
| **REGISTRATION_NUMBER** | Specifies the registration number. | | **REGISTRATION_NUMBER** | Specifies the registration number. | ||
- | | **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: [[https:// | + | | **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: [[https:// |
| **MAX_NUMBER_OF_TEST_CALLS** | Controls the number of calling statements for option **TEST**. The default value is 10. | | | **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 | + | | **GENRPT** | Option that controls whether to generate the HTML report or not. The default value is “Yes”. Possible values |
- | | **CONVERT_VIEW2TABLE** | Option that controls whether to convert all selected views to tables or not. The data for the tables | + | | **CONVERT_VIEW2TABLE** | Option that controls whether to convert all selected views to tables or not. The data for the tables |
- | | **FN_WITH_EXC2SP** | Whenever there is EXEPTION block with WHEN OTHERS inside the function it will be converted to procedure with TRY CATCH block. The default value is No or Empty. Possible values | + | | **FN_WITH_EXC2SP** | Whenever there is EXEPTION block with WHEN OTHERS inside the function it will be converted to procedure with TRY CATCH block. The default value is “No” or Empty. Possible values |
- | | **OPTION_VARYING_PARSING** | Option that controls the way the delimited identifiers from Informix are parsed. | + | | **OPTION_VARYING_PARSING** | Option that controls the way the delimited identifiers from Informix are parsed. |
- | | **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. The default value is No. Possible values | + | | **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. The default value is “No”. Possible values |
- | | **USE_ODBC_FUNCTIONS** | When this option is set to "YES" only ODBC functions | + | | **USE_ODBC_FUNCTIONS** | When this option is set to "Yes", only ODBC functions |
- | | **PRECACHE_OBJECTS** | This option increases productivity of SQLWays | + | | **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 |
- | | **PRECACHE_TABLES_COUNT** | This option defines the minimum number of tables, which will be precached if PRECACHE_OBJECTS is set to True. The default value is 100.| | + | | **PRECACHE_TABLES_COUNT** | This option defines the minimum number of tables, which will be precached if PRECACHE_OBJECTS is set to “True”. The default value is 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. The default value is No.| | + | | **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”. The default value is “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. The default value is No. Possible values | + | | **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. The default value is “No”. Possible values |
- | | **REPLICATION_CONVERT** | When this option is set to "YES" | + | | **REPLICATION_CONVERT** | When this option is set to "Yes" the tool performs generation of Triggers and additional tables for the [[: |
- | | **LOGICAL_FILES_PATH** | To migrate Logical Files from DB2 AS400, a path to the files that will store LF definition | + | | **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. | | | **SOURCE_DB** | Option that defines source database for Embedded SQL conversion. | | ||
| **TARGET_DB** | Option that defines target database for Embedded SQL conversion. | | | **TARGET_DB** | Option that defines target database for Embedded SQL conversion. | | ||
Line 44: | Line 44: | ||
| **API_SOURCE_DB_VERSION** | Option that defines version of database API for source 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. | | | **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 generated | + | | **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 - " |
- | | **LICENSE_INFO** | This option generates the information about the date and time of conversion, version and license owner inside the converted | + | | **LICENSE_INFO** | This option generates the information about the date and time of conversion, version and license owner inside the converted |
- | | **GENERATE_VERSION_TIMESTAMP** | This option generates the information about the datetime of conversion and version of the tool in the sql code. \\ Possible values - " | + | | **GENERATE_VERSION_TIMESTAMP** | This option generates the information about the datetime of conversion and version of the tool in the SQL code. \\ Possible values - " |
- | | **FB_DIALECT** | This option defines the dialect number that will be used to connect to the FIREBIRD database. | | + | | **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 a 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, then common conversion will be used. | | + | | **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 - " | | **PARSE_DIRECTIVES** | This option defines whether the toolkit should parse the directives in the C++ code. \\ Possible values - " | ||
- | | **REMOVE_SRC_FORMATTING** | This option removes source code formatting by removing extra separators for COBOL -> JAVA direction. \\ Possible values - " | + | | **REMOVE_SRC_FORMATTING** | This option removes source code formatting by removing extra separators for COBOL to JAVA direction. \\ Possible values - " |
- | | **DETAIL_REPORT** | If this option is set to " | + | | **DETAIL_REPORT** | If this option is set to " |
- | | **USE_SP_PRIMARYKEY** | By default our tool shouldn' | + | | **USE_SP_PRIMARYKEY** | By default our tool shouldn' |
- | | **OMIT_ORACLE_HINTS** | Since Oracle hints are specific only for Oracle database, by default these peaces | + | | **OMIT_ORACLE_HINTS** | Since Oracle hints are specific only for Oracle database, by default these pieces |
+ | | **SHORTCUT_JOINS** | This option defines whether the OUTER keyword should be removed from Joins. If this option is set to " | ||
+ | | **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 "," | ||
**Example**: | **Example**: | ||
Line 64: | Line 65: | ||
\\ | \\ | ||
- | If you have any questions | + | If you have any questions |
- | \\ | ||
- | [[http:// | ||
- | [[http:// | ||
- | [[http:// |