Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
guides:migration-toolkit:command-line:sqlways-ini:sybase-section [2019/11/16 10:03] darya.prikhodkina |
guides:migration-toolkit:command-line:sqlways-ini:sybase-section [2024/04/12 17:16] (current) uliana.philippova |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ** About Ispirer Systems ** | ||
| + | |||
| + | [[https://www.ispirer.com|Ispirer Home Page]] | ||
| + | [[https://www.ispirer.com/products/database-migration|Database Migration]] | ||
| + | [[https://www.ispirer.com/application-conversion|Application Conversion]] | ||
| + | [[https://www.ispirer.com/download|Downloads]] | ||
| + | ---- | ||
| ====== Sqlways.ini File - Section [SYBASE] ====== | ====== Sqlways.ini File - Section [SYBASE] ====== | ||
| Line 15: | Line 22: | ||
| | **CLIENT_SIDE_PWD_ENCRYPTION** | Specifies the client-side password encryption to the ISQL and BCP utilities commands (Parameter -X). \\ Possible values: "Yes", "No". Default value is "No". | | | **CLIENT_SIDE_PWD_ENCRYPTION** | Specifies the client-side password encryption to the ISQL and BCP utilities commands (Parameter -X). \\ Possible values: "Yes", "No". Default value is "No". | | ||
| | **PREFETCH_SIZE** | Specifies the number of rows per batch of data copied. By default, bcp copies n rows in one batch, where n is equal to the batch size. Batch size applies only when you are bulk copying in; it has no effect on bulk copying out. The smallest number bcp accepts for batchsize is 1. The largest number bcp accepts for batchsize is 2147483647L. | | | **PREFETCH_SIZE** | Specifies the number of rows per batch of data copied. By default, bcp copies n rows in one batch, where n is equal to the batch size. Batch size applies only when you are bulk copying in; it has no effect on bulk copying out. The smallest number bcp accepts for batchsize is 1. The largest number bcp accepts for batchsize is 2147483647L. | | ||
| - | | **IDENTIFIER_DELIMITER** | This option defines identifier delimiter that will be used in a query, which is used to get data from Sybase database. For more details about this option, please contact our technical support team [[[email protected]]] | | + | | **IDENTIFIER_DELIMITER** | This option defines identifier delimiter that will be used in a query, which is used to get data from Sybase database.| |
| + | | **BCP_COMMAND_LINE_CUSTOM_PARAMETERS** | This option allows you to set custom command line parameters to call the bcp utility in the executable file. \\ [[samples:options-examples #[[Usage example]: BCP_COMMAND_LINE_CUSTOM_PARAMETERS |Usage Example]]. | | ||
| + | |||
| + | By default it contains information about client_charset and has the value "-J iso_1", but you can change this value or add new ones | | ||
| **Example**: | **Example**: | ||
| Line 26: | Line 36: | ||
| \\ | \\ | ||
| - | ---- | + | |
| - | === More about Ispirer Systems === | + | |
| - | [[https://www.ispirer.com|Ispirer Home Page]] | + | |
| - | [[https://www.ispirer.com/products/database-migration|Database Migration]] | + | |
| - | [[https://www.ispirer.com/application-conversion|Application Conversion]] | + | |
| - | [[https://www.ispirer.com/download|Downloads]] | + | |