Ispirer Ispirer
 

Differences

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

Link to this comparison view

sqlways:command-line:sqlways-ini:db2-section [July 24, 2018, 01:06:23 PM]
alexandr.kirpichny
sqlways:command-line:sqlways-ini:db2-section [October 26, 2018, 09:34:38 AM] (current)
darya.prikhodkina
Line 11: Line 11:
 | **USER** | Specifies the user name that is used in generated scripts for the IBM DB2 utilities. | | **USER** | Specifies the user name that is used in generated scripts for the IBM DB2 utilities. |
 | **PWD** | Specifies the user password that is used in generated scripts for the IBM DB2 utilities. | | **PWD** | Specifies the user password that is used in generated scripts for the IBM DB2 utilities. |
-| **TARGET_VERSION** | Specifies the target version of the DB2 database. If this option is empty the latest DB2 database version will be used. \\ Note: According to the version number conversion results may be different. |+| **TARGET_VERSION** | Specifies the target version of the DB2 database. If this option is empty the latest DB2 database version will be used. \\ Note: According to the version number conversion results may differ. |
 | **USE_LOAD_COMMAND** | If Yes is specified, the IBM DB2 LOAD command is used to move data into the IBM DB2 database. Possible values - Yes, No. The default value is No, which means that the IBM DB2 IMPORT command is used. | | **USE_LOAD_COMMAND** | If Yes is specified, the IBM DB2 LOAD command is used to move data into the IBM DB2 database. Possible values - Yes, No. The default value is No, which means that the IBM DB2 IMPORT command is used. |
 | **LOAD_FROM_CLIENT** | If Yes is specified, the CLIENT option is used in the IBM DB2 LOAD command. This option specifies that the data can reside on a remote client. Otherwise, the data must reside on the IBM DB2 server. \\ Possible values - Yes, No. The default value is No. The CLIENT option in the LOAD command is available in IBM DB2 7.1 or later. | | **LOAD_FROM_CLIENT** | If Yes is specified, the CLIENT option is used in the IBM DB2 LOAD command. This option specifies that the data can reside on a remote client. Otherwise, the data must reside on the IBM DB2 server. \\ Possible values - Yes, No. The default value is No. The CLIENT option in the LOAD command is available in IBM DB2 7.1 or later. |
Line 27: Line 27:
 | **IXF_SB_CODE_PAGE** | This option specifies Single-Byte codepage, that will be used in the .IXF file, generated during the conversion step.  | | **IXF_SB_CODE_PAGE** | This option specifies Single-Byte codepage, that will be used in the .IXF file, generated during the conversion step.  |
 | **IXF_DB_CODE_PAGE** | This option specifies Double-Byte codepage, that will be used in the .IXF file, generated during the conversion step. | | **IXF_DB_CODE_PAGE** | This option specifies Double-Byte codepage, that will be used in the .IXF file, generated during the conversion step. |
-| **USE_SOURCE_TABLESPACE_NAMES** | This option specifies whethe to use original tablespace names in the converted objects. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No" or Empty. |+| **USE_SOURCE_TABLESPACE_NAMES** | This option specifies whether to use the original tablespace names in the converted objects. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No" or Empty. |
 | **DB2CMD_FULL_PATH** | If this option is set to "Yes", SQLWays Wizard will generate command to the native db2.exe utility using the full path to this utility. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No" or Empty. | | **DB2CMD_FULL_PATH** | If this option is set to "Yes", SQLWays Wizard will generate command to the native db2.exe utility using the full path to this utility. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No" or Empty. |
 | **PREFETCH_SIZE** | This option identifies the number of rows you want to read from the datafile before a data save for Direct path loads. The default is to read all the rows and save data at the end of the load. | | **PREFETCH_SIZE** | This option identifies the number of rows you want to read from the datafile before a data save for Direct path loads. The default is to read all the rows and save data at the end of the load. |
sqlways/command-line/sqlways-ini/db2-section.txt · Last modified: October 26, 2018, 09:34:38 AM by darya.prikhodkina
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement