4.14. SQL Constants

Table 4.568. Database Driver Constants in the SQL Namespace

Constant

Value

Description

SQL::DSOracle

"oracle"

Indicates that the oracle driver should be used by Datasource::constructor() and DatasourcePool::constructor()

SQL::DSMySQL

"mysql"

Indicates that the mysql driver should be used by Datasource::constructor() and DatasourcePool::constructor()

SQL::DSPGSQL

"pgsql"

Indicates that the pgsql driver should be used by Datasource::constructor() and DatasourcePool::constructor()

SQL::DSSybase

"sybase"

Indicates that the sybase driver should be used by Datasource::constructor() and DatasourcePool::constructor()

SQL::DSFreeTDS, SQL::MSSQL

"freetds"

Indicates that the freetds driver should be used by Datasource::constructor() and DatasourcePool::constructor()

SQL::DB2

"db2"

Indicates that the db2 driver should be used by Datasource::constructor() and DatasourcePool::constructor()

SQL::DSSQLite3

"sqlite3"

Indicates that the sqlite3 driver should be used by Datasource::constructor() and DatasourcePool::constructor()


Table 4.569. Placeholder Bind Constants in the SQL Namespace

Constant

Description

SQL::VARCHAR

Indicates that the placeholder buffer should be a string buffer

SQL::CLOB

Indicates that the placeholder buffer should be a CLOB string buffer.

SQL::BLOB

Indicates that the placeholder buffer should be a binary buffer.

SQL::DATE

Indicates that the placeholder buffer should be a date-time buffer.


Table 4.570. DBI Capability Constant Codes in the SQL Namespace

Constant

Description

SQL::DBI_CAP_CHARSET_SUPPORT

Indicates that the DBI driver supports proper character encoding conversions.

SQL::DBI_CAP_TRANSACTION_MANAGEMENT

Indicates that the DBI driver supports transaction management.

SQL::DBI_CAP_STORED_PROCEDURES

Indicates that the DBI driver supports stored procedure execution.

SQL::DBI_CAP_LOB_SUPPORT

Indicates that the DBI driver supports *LOB columns.

SQL::DBI_CAP_BIND_BY_VALUE

Indicates that the DBI driver supports directly binding qore values into queries using the %v placeholder in the query string.

SQL::DBI_CAP_BIND_BY_PLACEHOLDER

Indicates that the DBI driver supports binding placeholder buffers when executing SQL to retrieve data from queries and procedures, etc.