Ispirer Migration Knowledge Base

User Tools

Site Tools

You are here: Ispirer Migration Knowledge Base » Ispirer Migration Knowledge Base » SQLWays Command Line » Sqlways.ini File Sections Overview » Sqlways.ini File - Section [COMMON]

Differences

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

Link to this comparison view

sqlways:command-line:sqlways-ini:common-section [May 03, 2019, 10:31:45 AM] – darya.prikhodkinasqlways: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://www.ispirer.com|Ispirer Home Page]] +[[https://www.ispirer.com|Ispirer Website]] 
-[[http://www.ispirer.com/products|Ispirer MnMTK Product Page]] +[[https://www.ispirer.com/products/migration-toolkit|Ispirer Toolkit Overview]] 
-[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request Ispirer MnMTK]]+[[https://www.ispirer.com/download/download-demo|Free Trial]]
 ====== Sqlways.ini File - Section [COMMON] ====== ====== Sqlways.ini File - Section [COMMON] ======
  
Line 45: Line 45:
 | **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 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".| | **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. |+| **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 - "Yes". |
 | **GENERATE_VERSION_TIMESTAMP** | This option generates the information about the datetime of conversion and version of the tool in the SQL code. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No" or Empty. | | **GENERATE_VERSION_TIMESTAMP** | This option generates the information about the datetime 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. | | **FB_DIALECT** | This option defines the dialect number that will be used to connect to FIREBIRD database. |
Line 54: Line 54:
 | **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.  | | **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.  | | **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. |
  
 **Example**: **Example**:
Line 67: Line 68:
  
  
-\\ 
-[[http://www.ispirer.com|Ispirer Home Page]] 
-[[http://www.ispirer.com/products|Ispirer MnMTK Product Page]] 
-[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request Ispirer MnMTK]] 
  
© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.