When you access a Sybase Adaptive Server Enterprise database in PowerBuilder through Open Client, Sec_Data_Integrity is one of several parameters that support per-packet security for network-based security services. (For other per-packet security parameters, see the See Also section.)
Sec_Data_Integrity controls whether your connection's security mechanism checks the integrity of data transmitted to and from the server. When Sec_Data_Integrity is set to 1, the security mechanism analyzes all packets to ensure that their content was not modified during transmission.
When Sec_Data_Integrity is set to 0 (the default), no integrity checking is performed.
You must specify a value for Sec_Data_Integrity before connecting to the database in PowerBuilder.
Using third-party security mechanisms
For information about the third-party security
mechanisms and operating system platforms that Sybase has tested
with Open Client security services, see the Open Client documentation.
ASE, SYC Sybase Adaptive Server Enterprise
Sec_Data_Integrity=value
Sec_Data_Integrity=0
When to use Your connection’s security mechanism can check data integrity only when your connection is also using network-based login authentication. For information, see your Sybase Open Client/Server documentation.
Set Release parameter For this parameter to take effect, you must also set the Release parameter to 11or higher to specify that your application should use the appropriate version of Sybase Open Client Client-Library (CT-Lib) behavior. See the description of the Release parameter for more information.
Requirements for use To use Sec_Data_Integrity or any other parameter supporting Open Client security services, you must meet certain requirements for using security services in your PowerBuilder application. For details, see “Requirements for using Open Client security services” in Connecting to Your Database.
Corresponding CT-Lib connection property Specifying a value for Sec_Data_Integrity sets the corresponding Sybase CT-Lib connection property named CS_SEC_INTEGRITY.
To specify that your connection’s security mechanism checks data integrity:
Database profile Select the Ensure Data Integrity check box on the Security page in the Database Profile Setup dialog box.
Application Type the following in code:
SQLCA.DBParm="Sec_Data_Integrity=1;Release=15"
