Ispirer Ispirer
 

Differences

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

Link to this comparison view

sqlways:command-line:sqlways-ini:ddl-section [February 01, 2019, 12:43:45 PM]
darya.prikhodkina
sqlways:command-line:sqlways-ini:ddl-section [February 08, 2019, 12:06:07 PM] (current)
darya.prikhodkina
Line 44: Line 44:
 | **TRIM_RULE_LEFTTRIM** | This option is used in conjunction with the "trim_names_exceeding_max_len=yes" option. \\ If Yes is specified and an identifier exceeds the maximum length for the target database, SQLWays trims characters from the left side.\\ The default value is No. Possible values - Yes, No. | | **TRIM_RULE_LEFTTRIM** | This option is used in conjunction with the "trim_names_exceeding_max_len=yes" option. \\ If Yes is specified and an identifier exceeds the maximum length for the target database, SQLWays trims characters from the left side.\\ The default value is No. Possible values - Yes, No. |
 | **REPLACE_RESERVED_WORDS** | This option is used to change identifiers of the source database which serve as reserved words in the target database. The option specifies a template for reserved words replacement. \\ For example, if %RWORD%_ is specified, underscore character is added to the right of all reserved words. \\ The default value of the template is %RWORD% which means that the reserved words are not changed and are delimited in SQL statements for the target database. The delimiter depends on the database. | | **REPLACE_RESERVED_WORDS** | This option is used to change identifiers of the source database which serve as reserved words in the target database. The option specifies a template for reserved words replacement. \\ For example, if %RWORD%_ is specified, underscore character is added to the right of all reserved words. \\ The default value of the template is %RWORD% which means that the reserved words are not changed and are delimited in SQL statements for the target database. The delimiter depends on the database. |
-| **CONVERT_DATABASE_TO_SCHEMA** | This option is used to convert fully qualified names with the database specification. \\ It is required to set this option to Yes to get it work. | +| **CONVERT_DATABASE_TO_SCHEMA** | This option is used to convert fully qualified names with the database specification. \\ Please set this option to Yes to get it work. | 
-| **CONVERT_PACKAGE_TO_SCHEMA** | This option is used to convert the Package name as the schema from an Oracle database. Currently this feature works for MSSQL as a target database only. \\ It is required to set this option to Yes to get it work. |+| **CONVERT_PACKAGE_TO_SCHEMA** | This option is used to convert the Package name as the schema from an Oracle database. Currently this feature works for MSSQL as a target database only. \\ Please set this option to Yes to get it work. |
 | **SCHEMA_TO_OBJ_NAME** | This option is used to convert the schema name as the prefix to the object name. \\ Possible values - "Yes", "No" or Empty. Default value - "No" or Empty. | | **SCHEMA_TO_OBJ_NAME** | This option is used to convert the schema name as the prefix to the object name. \\ Possible values - "Yes", "No" or Empty. Default value - "No" or Empty. |
-| **BUILTIN_FUNCTIONS_NULLIF_CHECK** | This option is used to generate NULLIF check when converting **LTRIM**, **RTRIM**, **SUBSTRING**, **RIGHT**, **REPLICATE** functions and COALESCE(@some_value,'') for the second parameter of the **CHARINDEX** function from Sybase ASE to Microsoft SQL Server. \\ This option is required for compatibility of these functions when empty strings, NULL values or zero lengths are processed. \\ It is required to set this option to Yes to get it work. |+| **BUILTIN_FUNCTIONS_NULLIF_CHECK** | This option is used to generate NULLIF check when converting **LTRIM**, **RTRIM**, **SUBSTRING**, **RIGHT**, **REPLICATE** functions and COALESCE(@some_value,'') for the second parameter of the **CHARINDEX** function from Sybase ASE to Microsoft SQL Server. \\ This option is required for compatibility of these functions when empty strings, NULL values or zero lengths are processed. \\ Please set this option to Yes to get it work. |
 | **FULLY_QUALIFY_IDENTIFIERS** | This option is used to generate schema for each referenced object without schema inside a View, Stored Procedure or Function. \\ This option works only if the **EMPTY_SCHEMA** option is set to No. \\ The default value is No. Possible values - Yes, No.| | **FULLY_QUALIFY_IDENTIFIERS** | This option is used to generate schema for each referenced object without schema inside a View, Stored Procedure or Function. \\ This option works only if the **EMPTY_SCHEMA** option is set to No. \\ The default value is No. Possible values - Yes, No.|
-| **CONVERT_ROUTINE_TO_SP_RESULTSET** | If it's Yes, then all the functions and procedures that return values must be converted to stored procedures that return resultset via the SELECT statement.  \\ The default value is No or Empty. Possible values - Yes, No.| +| **CONVERT_ROUTINE_TO_SP_RESULTSET** | If it is set to Yes, all the functions and procedures that return values must be converted to stored procedures that return resultset via the SELECT statement.  \\ The default value is No or Empty. Possible values - Yes, No.| 
-| **OUT_REFCUR_FIRST_POSITION** | This option works together with CONVERT_ROUTINE_TO_SP_RESULTSET and puts OUT parameter to the first position in the parameter list. Also please note, that this option will work only for Oracle version 11 and lower. For Oracle version 12 and higher OUT parameter will not be generated, and will be used PIPELINE functionality. \\ Possible values - "Yes", "No" or Empty. \\ Default values - "No" or Empty. |+| **OUT_REFCUR_FIRST_POSITION** | This option works together with CONVERT_ROUTINE_TO_SP_RESULTSET and puts OUT parameter to the first position in the parameter list. Also please note, that this option will work only for Oracle version 11 and lower. For Oracle version 12 and higher OUT parameter will not be generated, and PIPELINE functionality will be used. \\ Possible values - "Yes", "No" or Empty. \\ Default values - "No" or Empty. |
 | **MIGRATE_MEMBERSHIP** | This option controls the way the **Groups** are converted. When MIGRATE_MEMBERSHIP=No then groups are migrated as simple users and default permissions are used for them, E.G.: \\ For SAP ASA to Microsoft SQL Server db_datareader and db_datawriter are specified. \\ The default value is Yes. Possible values - Yes, No.| | **MIGRATE_MEMBERSHIP** | This option controls the way the **Groups** are converted. When MIGRATE_MEMBERSHIP=No then groups are migrated as simple users and default permissions are used for them, E.G.: \\ For SAP ASA to Microsoft SQL Server db_datareader and db_datawriter are specified. \\ The default value is Yes. Possible values - Yes, No.|
-| **TARGET_FILES_GROUPING** | This option controls the way the result SQL files are generated. \\ When data export is switched off and the TARGET_FILES_GROUPING = YES, then separate SQL files are generated each for each object extracted from the source database. \\ If the TARGET_FILES_GROUPING=ALL, then all the generated SQL is stored in one large file.  \\ The default value is empty. Possible values - ALL.| +| **TARGET_FILES_GROUPING** | This option controls the way the result SQL files are generated. \\ When data export is switched off and the TARGET_FILES_GROUPING = YES, then separate SQL files are generated for each object extracted from the source database. \\ If the TARGET_FILES_GROUPING=ALL, then all the generated SQL is stored in one large file.  \\ The default value is empty. Possible values - ALL.| 
-| **CONVERT_GLOBAL_VARIABLES_TO_LOCAL** | This option controls the way global or user variables are converted by SQLWays. \\ When the option is set to Yes, all global variables are converted to local variables declared and used inside the SP or FN only. \\ If the option is set to No, then global variables are converted to their equivalent, automatically generated by SQLWays.  \\ The default value is No. Possible values - Yes, No.| +| **CONVERT_GLOBAL_VARIABLES_TO_LOCAL** | This option controls the way global or user variables are converted by SQLWays. \\ When the option is set to Yes, all global variables are converted to local variables declared and used inside SP or FN only. \\ If the option is set to No, global variables are converted to their equivalents, automatically generated by SQLWays.  \\ The default value is No. Possible values - Yes, No.| 
-| **PKG_VARIABLES** | This option controls the way global variables are stored in the target database. \\ When the option is set to UNION_BY_PACKAGE, all package variablesthat belong to one packageare stored in one table per package, where column names correspond to variable names and values are stored each in its own column. \\ If the option is set to UNION_BY_TYPE, then all global variables are stored in tables, each for its own type group, where variable name is stored as the value of the column with the corresponding variable value in the corresponding row. \\ If the option is set to LOCAL, then all the global variables are converted to local variables. Please use this option carefully to avoid import issues, as not all the source cases can be converted using this option. \\ The default value is UNION_BY_TYPE. Possible values - UNION_BY_TYPE, UNION_BY_PACKAGE and LOCAL.| +| **PKG_VARIABLES** | This option controls the way global variables are stored in the target database. \\ When the option is set to UNION_BY_PACKAGE, all package variables that belong to one package are stored in one table per package, where column names correspond to variable names and all the values are stored in their own columns. \\ If the option is set to UNION_BY_TYPE, all global variables are stored in tables, each for its own type group, where variable name is stored as the value of the column with the corresponding variable value in the corresponding row. \\ If the option is set to LOCAL, all the global variables are converted to local variables. Please use this option carefully to avoid import issues, as not all the source cases can be converted using this option. \\ The default value is UNION_BY_TYPE. Possible values - UNION_BY_TYPE, UNION_BY_PACKAGE and LOCAL.| 
-| **CONVERT_PK_INDEX** | This option controls the way the indexes, created on primary column in DB2, are converted by SQLWays. \\ When the option is set to Yes, the indexes on primary columns are converted to their equivalent. \\ If the option is set to No, then indexes are commented by SQLWays.  \\ The default value is Yes. Possible values - Yes, No. \\ Currently this option works only for DB2 to Oracle migration direction.| +| **CONVERT_PK_INDEX** | This option controls the way the indexes, created on primary column in DB2, are converted by SQLWays. \\ When the option is set to Yes, the indexes on primary columns are converted to their equivalents. \\ If the option is set to No, then indexes are commented by SQLWays.  \\ The default value is Yes. Possible values - Yes, No. \\ Currently this option works only for DB2 to Oracle migration direction.| 
-| **FN_RET_MULTIPLE_VALUES_TO_TABLE_FN** | This option controls the way informix functionswhich return multiple valuesare converted to MSSQL Server. If this option is set as Yes, SQLWays will convert it as Table Function in MSSQL, if NO - procedure with out parameters. \\ The default value is No. Possible values - Yes, No.| +| **FN_RET_MULTIPLE_VALUES_TO_TABLE_FN** | This option controls the way informix functions which return multiple values are converted to MSSQL Server. If this option is set as Yes, SQLWays will convert them as Table Function in MSSQL, if NO - as procedures with out parameters. \\ The default value is No. Possible values - Yes, No.| 
-| **SW_SEQ_SUFFIX** | This option adds suffix to the sequences generated automatically by Ispirer SQLWays Wizard. Default value is "SWS_". If both options SW_SEQ_SUFFIX and SW_SEQ_PREFIX are empty default suffix("SWS_") and prefix("_ID") for sequences will be used. | +| **SW_SEQ_SUFFIX** | This option adds suffix to the sequences generated automatically by Ispirer SQLWays Wizard. Default value is "SWS_". If both options SW_SEQ_SUFFIX and SW_SEQ_PREFIX are emptydefault suffix("SWS_") and prefix("_ID") for sequences will be used. | 
-| **SW_SEQ_PREFIX** | This option adds prefix to the sequences generated automatically by Ispirer SQLWays Wizard. Default value is "_ID". If both options SW_SEQ_SUFFIX and SW_SEQ_PREFIX are empty suffix("SWS_") and prefix("_ID") for sequences will be used default. | +| **SW_SEQ_PREFIX** | This option adds prefix to the sequences generated automatically by Ispirer SQLWays Wizard. Default value is "_ID". If both options SW_SEQ_SUFFIX and SW_SEQ_PREFIX are emptysuffix("SWS_") and prefix("_ID") for sequences will be used by default. | 
-| **SW_TRIG_SUFFIX** | This option adds suffix to the triggers generated automatically by Ispirer SQLWays Wizard. Default value is "SWT_". If both options SW_TRIG_SUFFIX and SW_TRIG_PREFIX are empty default suffix("SWT_") and prefix("_ID") for triggers will be used. | +| **SW_TRIG_SUFFIX** | This option adds suffix to the triggers generated automatically by Ispirer SQLWays Wizard. Default value is "SWT_". If both options SW_TRIG_SUFFIX and SW_TRIG_PREFIX are emptydefault suffix("SWT_") and prefix("_ID") for triggers will be used. | 
-| **SW_TRIG_PREFIX** | This option adds suffix to the triggers generated automatically by Ispirer SQLWays Wizard. Default value is "_ID". If both options SW_TRIG_SUFFIX and SW_TRIG_PREFIX are empty suffix("SWT_") and prefix("_ID") for triggers will be used default. | +| **SW_TRIG_PREFIX** | This option adds suffix to the triggers generated automatically by Ispirer SQLWays Wizard. Default value is "_ID". If both options SW_TRIG_SUFFIX and SW_TRIG_PREFIX are emptysuffix("SWT_") and prefix("_ID") for triggers will be used by default. | 
-| **ANSI_QUOTED_IDENTIFIERS** | This option controls how to handle text inside the double quotes. If this option is empty or set to "No", text in double quotes will be identified as a simple string. If this option is set to "Yes" SQLWays will handle text in double quotes as identifier names. \\ Possible values - "Yes", "No" or empty(the same as "No"). Default value - "No" or empty. | +| **ANSI_QUOTED_IDENTIFIERS** | This option controls how to handle the text inside double quotes. If this option is empty or set to "No", the text in double quotes will be identified as a simple string. If this option is set to "Yes" SQLWays will handle the text in double quotes as identifier names. \\ Possible values - "Yes", "No" or empty(the same as "No"). Default value - "No" or empty. | 
-| **TARGET_BL** | This option controls how business logic objects (procedures, functions, triggers, etc.) should be converted to SQL objects or to Java classes. By default this option is set to "Default" and business logic objects will be converted to SQL objects. If this option is set to "Java" java classes will be generated as a result of conversion. Possible values - "Default" and "Java". | +| **TARGET_BL** | This option controls how business logic objects (procedures, functions, triggers, etc.) should be convertedto SQL objects or to Java classes. By default this option is set to "Default" and business logic objects will be converted to SQL objects. If this option is set to "Java"java classes will be generated as a result of conversion. Possible values - "Default" and "Java". | 
-| **CASCADE_CONSTRAINTS_NO_ACTION** | If there is a referential relationship between a table and the parent row is altered in the parent table, an action, which should be done on child table, can be specified in constraint definition. If you set this option as "Yes", this action will be set to "NO ACTION" in constraint. Default value - "No". Possible values - "Yes", "No". | +| **CASCADE_CONSTRAINTS_NO_ACTION** | If a referential relationship between a table and the parent row is altered in the parent table, an action, which should be performed for child table, can be specified in constraint definition. If you set this option as "Yes", this action will be set to "NO ACTION" in constraint. Default value - "No". Possible values - "Yes", "No". | 
-| **QUOTE_IDENTIFIERS** | This option puts identifier names in quotes in target scripts. Possible values - "Always", empty. Default - empty. |+| **QUOTE_IDENTIFIERS** | This option encloses identifier names in quotes in target scripts. Possible values - "Always", empty. Default - empty. |
 | **SYNONYM_TO_VIEW** | This option controls how Oracle synonyms should be converted to PostgreSQL database. By default CREATE SYNONYM statement will be commented and all the synonyms identifiers will be changed to the original object names. If this option is set to YES, all the synonyms will be converted to views in PostgreSQL. Possible values - "Yes", "No" or empty. Default - "No" or empty. | | **SYNONYM_TO_VIEW** | This option controls how Oracle synonyms should be converted to PostgreSQL database. By default CREATE SYNONYM statement will be commented and all the synonyms identifiers will be changed to the original object names. If this option is set to YES, all the synonyms will be converted to views in PostgreSQL. Possible values - "Yes", "No" or empty. Default - "No" or empty. |
 | **CONVERT_SP_RETSTATUS_OUTPARAM** | If this option is set to "Yes" the source procedure will be converted to the procedure in the target with additional OUT parameter, that will return status of procedure execution. If this option is set to "No", source procedure will be converted to the function with return statement. Possible values - "Yes", "No". | | **CONVERT_SP_RETSTATUS_OUTPARAM** | If this option is set to "Yes" the source procedure will be converted to the procedure in the target with additional OUT parameter, that will return status of procedure execution. If this option is set to "No", source procedure will be converted to the function with return statement. Possible values - "Yes", "No". |
-| **CONVERT_CHECK_CONSTRAINTS** | This option defines whether check constraints should be converted. If this option is set to "Yes", check constraints will be converted. If it is set to "No" - check constraints will not be converted. \\ Possible values - Yes, No. \\ Default value - Yes. | +| **CONVERT_CHECK_CONSTRAINTS** | This option defines whether check constraints should be converted or not. If this option is set to "Yes", check constraints will be converted. If it is set to "No" - check constraints will not be converted. \\ Possible values - Yes, No. \\ Default value - Yes. | 
-| **CONVERT_UNIQUE_CONSTRAINTS** | This option defines whether unique constraints should be converted. If this option is set to "Yes", unique constraints will be converted. If it is set to "No" - unique constraints will not be converted. \\ Possible values - Yes, No. \\ Default value - Yes. | +| **CONVERT_UNIQUE_CONSTRAINTS** | This option defines whether unique constraints should be converted or not. If this option is set to "Yes", unique constraints will be converted. If it is set to "No" - unique constraints will not be converted. \\ Possible values - Yes, No. \\ Default value - Yes. | 
-| **SCHEMA_TO_DATABASE** | This option controls schema names conversion for all specified objects for the migration process. If this option is set to "Yes", converted objects will be created under the database with the same name as the source schema has. In that case, the schema name will be obtained from OUTSCHEMA option. If it is set to "No" the source database structure will be saved. \\ Possible values - Yes, No. \\ Default value - No. | +| **SCHEMA_TO_DATABASE** | This option controls schema names conversion for all specified objects for the migration process. If this option is set to "Yes", converted objects will be created under the database with the same name as the source schema has. In that case, the schema name will be obtained from OUTSCHEMA option. If it is set to "No"the source database structure will be saved. \\ Possible values - Yes, No. \\ Default value - No. | 
-| **PARTITION_TABLESPACE** | This option controls whether source partition table tablespaces should be converted or noIn case when the option is set into "Yes", source tablespaces for table partitions will be included in migration solution and target definitions of table partitions will contain tablespaces equal to source tablespaces. If the option = "No", tablespaces for table partitions will be ignored. \\ Possible values - Yes, No. \\ Default value - No. | +| **PARTITION_TABLESPACE** | This option controls whether source partition table tablespaces should be converted or notWhen the option is set into "Yes", source tablespaces for table partitions will be included in migration solution and target definitions of table partitions will contain tablespaces equal to source tablespaces. If the option = "No", tablespaces for table partitions will be ignored. \\ Possible values - Yes, No. \\ Default value - No. | 
-| **REMOVE_VAR_PREFIX** | This option controls the way the source variable prefix like "@" will be replaced from MS SQL ServerSybase ASE databases inTO other target databases. In case the option is set to "Yes", the SQLWays will just remove the variable prefix and variable name will be without any additional prefixes. If the option "No", the SQLWays will remove source prefix with the prefix defined in the VAR_PREFIX option. Default prefix that will be used is "v_". User can specify its own prefix that will be used in conversion. \\ Possible values - Yes, No. \\ Default value - Yes. | +| **REMOVE_VAR_PREFIX** | This option controls the way the source variable prefix like "@" will be replaced from MS SQL Server and Sybase ASE databases into other target databases. In case the option is set to "Yes", SQLWays will just remove the variable prefix so that variable name will not have any additional prefixes. If the option is set to "No", SQLWays will remove source prefix with the prefix defined in the VAR_PREFIX option. Default prefix that will be used is "v_". The user can specify his own prefix that will be used during conversion. \\ Possible values - Yes, No. \\ Default value - Yes. | 
-| **VAR_PREFIX** | This option defines what variable prefix will be used in variables when migrating from such databases as MS SQL Server and Sybase ASE. In this option user can specify its own prefix. \\ Default value - "v_". |+| **VAR_PREFIX** | This option defines which variable prefix will be used in variables when migrating from such databases as MS SQL Server and Sybase ASE. In this option the user can specify his own prefix. \\ Default value - "v_". |
 | **USE_CHAR_LENGTH** | When migrating tables from Oracle to PostgreSQL, Greenplum or Redshift, information about the column length is taken from DATA_LENGTH column from ALL_TAB_COLUMNS system table. This column stores information about the number of bytes of CHAR\VARCHAR2 and NCHAR\NVARCHAR2 columns. And if you need to use the number of characters as a length of CHAR\VARCHAR2 and NCHAR\NVARCHAR2 columns, you need to set this option to "Yes" and our tool will use information from ALL_TAB_COLUMNS from "CHAR_LENGTH" column. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No" or Empty. | | **USE_CHAR_LENGTH** | When migrating tables from Oracle to PostgreSQL, Greenplum or Redshift, information about the column length is taken from DATA_LENGTH column from ALL_TAB_COLUMNS system table. This column stores information about the number of bytes of CHAR\VARCHAR2 and NCHAR\NVARCHAR2 columns. And if you need to use the number of characters as a length of CHAR\VARCHAR2 and NCHAR\NVARCHAR2 columns, you need to set this option to "Yes" and our tool will use information from ALL_TAB_COLUMNS from "CHAR_LENGTH" column. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No" or Empty. |
 | **USE_SYSTEM_COLUMN_NAME** | This option allows to use system column names when migrating from DB2 database. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No" or Empty. | | **USE_SYSTEM_COLUMN_NAME** | This option allows to use system column names when migrating from DB2 database. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No" or Empty. |
 | **REFCUR_NAME_FOR_RESULT_SETS** | This option allows to control the name of the refcursor OUT parameter name. | | **REFCUR_NAME_FOR_RESULT_SETS** | This option allows to control the name of the refcursor OUT parameter name. |
-| **CONVERT_INDEXES** | This option defines the types of the indexes that will be converted by the SQLWays tool. \\ Possible values - "All", "None", "Unique". \\ Default value - "ALL". |+| **CONVERT_INDEXES** | This option defines the types of the indexes that will be converted by SQLWays tool. \\ Possible values - "All", "None", "Unique". \\ Default value - "ALL". |
 | **CONVERT_TEMPORARY_TABLES_TO_PERMANENT_TABLES** | This option defines how to convert temporary tables. If this option is set to "No", temporary tables will be converted as is. If this option is set to "Yes", temporary tables will be converted to permanent tables. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No" or Empty. | | **CONVERT_TEMPORARY_TABLES_TO_PERMANENT_TABLES** | This option defines how to convert temporary tables. If this option is set to "No", temporary tables will be converted as is. If this option is set to "Yes", temporary tables will be converted to permanent tables. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No" or Empty. |
-| **CONVERT_ALL_SP_TO_PACKAGE** | If this option is set to "Yes", all the procedures will be converted to one set of procedures inside one package, when migrating to Oracle. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No" or Empty. | +| **CONVERT_ALL_SP_TO_PACKAGE** | If this option is set to "Yes", all the procedures will be converted to one set of procedures inside one package, when migrating to Oracle. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No" or Empty. | 
-| **START_VALUE_EXTRACTION_WITH_SEQUENCE_INCREMENT** | If this option is set to "Yes", SQLWays tool will extract start value of the sequence as current value plus increment. Important notification - using this option will change the current sequence value in the source Informix database. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No" or Empty. | +| **START_VALUE_EXTRACTION_WITH_SEQUENCE_INCREMENT** | If this option is set to "Yes", SQLWays tool will extract start value of the sequence as current value plus increment. Important notification - this option will change the current sequence value in the source Informix database. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No" or Empty. | 
-| **CONVERT_COMMENTS** | This option defines whether the comments inside the sql code should be converted. By default this option is set to "Yes" and all the comments are saved. If we set this option to "No", comments will be removed from the sql code. \\ Possible values - "Yes", "No". \\ Default value - "Yes". | +| **CONVERT_COMMENTS** | This option defines whether the comments inside the sql code should be converted or not. By default this option is set to "Yes" and all the comments are saved. If we set this option to "No", comments will be removed from the sql code. \\ Possible values - "Yes", "No". \\ Default value - "Yes". | 
-| **EXPORT_CONSTRAINTS_FOR_QUERIES** | This option controls whether the constraints should be converted when doing conversion using the queries. \\ Possible values - "Yes", "No". \\ Default value - "Yes". | +| **EXPORT_CONSTRAINTS_FOR_QUERIES** | This option controls whether the constraints should be converted when performing conversion using the queries. \\ Possible values - "Yes", "No". \\ Default value - "Yes". | 
-| **CONVERT_MM_TAB** | This option defines how multi-member tables will be converted from DB2 AS 400 into Microsoft SQL Server database. If this option is set to "SINGLE" our tool will try to extract date from all the members created on this table in DB2 database and load all the extracted data into one table in MSSQL. In that case table in MSSQL will have the same name as original table in DB2. If this option is set to "MULTIPLE" our tool will extract information about the table and data from each member and will create separate tables in MSSQL for each member with the same structure as the original table. It means that in the target database we will have multiple tables with data and the same name as corresponding member. \\ Possible values - "SINGLE" or "MULTIPLE". \\ Default value - "SINGLE". | +| **CONVERT_MM_TAB** | This option defines how multi-member tables will be converted from DB2 AS 400 into Microsoft SQL Server database. If this option is set to "SINGLE"our tool will try to extract the data from all the members created on this table in DB2 database and load all the extracted data into one table in MSSQL. In that case table in MSSQL will have the same name as original table in DB2. If this option is set to "MULTIPLE"our tool will extract information about the table and data from each member and will create separate tables in MSSQL for each member with the same structure as the original table. It means that in the target database we will have multiple tables with data and with the same name as the corresponding member. \\ Possible values - "SINGLE" or "MULTIPLE". \\ Default value - "SINGLE". | 
-| **ORACLE_PKG_TO_FN** | This option allows to change package conversion structure logic from Oracle to Greenplum migration direction. By default Oracle packages are converted to sets of Greenplum functions corresponding to source package routines. Package global variables are converted using temporary tables. If the option is set to 'Yes', Oracle package will be converted into one function which takes 1 parameter to pass package routine name and branches package routines logic via IF...ELSE structures.Package global variables in that case will be converted to function local variables.\\ Possible values - "Yes", "No". \\ Default value - "Yes". |+| **ORACLE_PKG_TO_FN** | This option allows to change package conversion structure logic for Oracle to Greenplum migration direction. By default Oracle packages are converted to sets of Greenplum functions corresponding to source package routines. Package global variables are converted using temporary tables. If the option is set to 'Yes', Oracle package will be converted into one function which takes 1 parameter to pass package routine name and branches package routines logic via IF...ELSE structures.Package global variables in that case will be converted to function local variables.\\ Possible values - "Yes", "No". \\ Default value - "Yes". |
  
  
Line 93: Line 93:
 \\ \\
  
-If you have any questions about the supported options or some features that you may need during your migration project, please contact our technical team: **__[[[email protected]]]__**+If you have any questions about the supported options or about any features that you may need for your migration project, please contact our technical team: **__[[[email protected]]]__**
  
 \\ \\
sqlways/command-line/sqlways-ini/ddl-section.txt · Last modified: February 08, 2019, 12:06:07 PM by darya.prikhodkina
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement