Currently supported database handle attributes include:
Attribute |
Description |
Default |
---|---|---|
dbh->{AutoCommit} = (0|1); |
Disables or enables AutoCommit. |
0 (off) |
dbh->{LongTruncOK} = (0|1); |
Disables or enables truncation of text and image types. |
0 |
dbh->{LongReadLen}=(int); |
Sets the default read chunk size for text and image data. For example: dbh->{LongReadLen} = 64000. |
32767 |
dbh->{syb_show_sql} =(0|1); |
If set, the current statement is included in the error string returned by the $dbh->errstr mechanism. |
0 |
dbh->{syb_show_eed} = (0|1); |
If set, the extended error information is included in the error string returned by $dbh->errstr. |
0 |
dbh->{syb_chained_txn} = (0|1); |
If set, CHAINED transactions are used when AutoCommit is off. Use this attribute only during the connect() call: $dbh = DBI->connect("dbi:SybaseASE:", $user, $pwd, {syb_chained_txn => 1}); Using syb_chained_txn at any time with AutoCommit turned off forces a commit on the current handle. When set to 0, an explicit BEGIN TRAN is issued as needed. |
0 |
dbh->{syb_use_bin_0x} = (0|1); |
If set, BINARY and VARBINARY values are prefixed with '0x' in the result string. |
0 |
dbh->{syb_binary_images} = (0|1); |
If set, image data is returned in raw binary format. Otherwise, image data is converted into a hexadecimal string. |
0 |
dbh->{syb_quoted_identifier} =(0|1); |
Allows identifiers that conflict with Sybase reserved words if they are quoted using "identifier." |
0 |
dbh->{syb_rowcount}=(int); |
If set to a nonzero value, the number of rows returned by a SELECT, or affected by an UPDATE or DELETE statement are limited to the rowcount value. Setting it back to 0 clears the limit. |
0 |
dbh->{syb_flush_finish} = (0|1); |
If set, the driver drains any results remaining for the current command by actually fetching them. This can be used instead of a ct_cancel() command issued by the driver. |
0 |
dbh->{syb_date_fmt} = datefmt string |
This private method sets the default date conversion and display formats. See “Default date conversion and display format”. |
|
dbh->{syb_err_handler} |
Perl subroutine that can be created to execute an error handler or report before the regular error handling takes place. Useful for certain classes of warnings. See “Error handling”. |
0 (not present) |
dbh->{syb_failed_db_fatal} = (0|1) |
If the DSN has a database=mumbles attribute/value pair and this database does not exist at connection time, the DBI->connect() call fails. |
0 |
dbh->{syb_no_child_con} =(0|1); |
If set, the driver disallows multiple active statement handles on the dbh. In this case, a statement can be prepared but must be executed to completion before another statement prepare is attempted. |
0 |
dbh->{syb_cancel_request_on_error}=(0|1); |
If set, when a multistatement set is executed and one statement fails, sth->execute() fails. |
1 (on) |
dbh->{syb_bind_empty_string_as_null}= (0|1); |
If set, a NULLABLE column attribute returns an empty string (one space) to represent the NULL character. |
0 |
dbh->{syb_disconnect_in_child} = (0|1); |
Handles closed connections across a fork. The DBI causes connections to be closed if a child dies. |
0 |
dbh->{syb_enable_utf8} = (0|1); |
If set, UNICHAR, UNIVARCHAR, and UNITEXT are converted to utf8. |
0 |
sth->syb_more_results} = (0|1); |
||
sth->{syb_result_type} = (0|1); |
If set, returns the numeric result number instead of the symbolic CS_ version. |
0 |
sth->{syb_no_bind_blob} = (0|1); |
If set, image or text columns are not returned upon sth->{fetch} or other variations. See “Text and image data handling”. |
0 |
sth->{syb_do_proc_status} = (0|1); |
Forces $sth->execute() to fetch the return status of a stored procedure executed in the SQL stream. If the return status is nonzero, $sth->execute() returns Setting this attribute does not affect existing statement handles. However, it affects those statement handles that are created after setting it. To revert behavior of an existing $sth handle, execute: $sth->{syb_do_proc_status} = 0; |
0 |
dbh->{syb_dynamic_supported}
dbh->{syb_ocs_version}
dbh->{syb_server_version}
dbh->{syb_server_version_string}
dbh->{syb_has_blk}
Perl scripts attempting to use these options generate an error.