Currently Supported Database Handle Attributes

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);

See Multiple Result Sets.

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 undef (that is, it fails).

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