Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

Sqlways.ini File - Section [SYBASE]

This article describes sqlways.ini file [SYBASE] section and the options it contains.

Option name Description
BIN Specifies the directory where the Sybase utilities like BCP and ISQL are located.
SERVER_NAME Specifies the server name that is used in generated scripts for the BCP and ISQL utilities (Parameter -S).
DATABASE Specifies the database name that is used in generated scripts for the BCP and ISQL utilities.
USER Specifies the user name that is used in generated scripts for the BCP and ISQL utilities (Parameter -U).
PWD Specifies the user password that is used in generated scripts for the BCP and ISQL utilities (Parameter -P).
TEMP_TAB_INDEXED_ALWAYS This option is used for SybaseASE to SybaseASE, when the detection for Cartesian Product works. If this option is specified as yes, all the joins with temporary tables are treated as indexed. So no Cartesian is detected in this case. Otherwise the Cartesian is detected if there is no information about the indexes created upon the temporary tables used in DML statement.
CLIENT_SIDE_CHARACTER_SET_CONVERSION This option specifies client-side character set conversion for the BCP utility (Parameter -Y).
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”.

Example:

[SYBASE]
SERVER_NAME=test_srv
CLIENT_SIDE_CHARACTER_SET_CONVERSION=Yes


Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

sqlways/command-line/sqlways-ini/sybase-section.txt · Last modified: September 15, 2016, 06:20:33 AM by alexandr.kirpichny
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement