DBEngine (Class)

Represents a database connection.

This object enables you to query the database and perform related operations.

Most methods in this class require 'sql' rights. If the operator invokes a method and does not have the appropriate rights, an exception is raised. Generally speaking, all methods that change the database require 'sql' rights, while methods which simply view information do not. Refer to the documentation on each method to find out whether or not the rights are required.

Methods


batchDelete	Deletes the records of a table by packets.
dispose	Frees the connection from all resources linked to it.
execute	Executes a SQL command.
exec	Alias of the execute command. This function is obsolete, use execute()
query	Executes a SELECT type SQL query.
queryWithTypes	Executes a SELECT type SQL query with column type specification.
begin	Starts a new transaction on the connection.
commit	Approves the transaction in progress on the connection.
rollback	Cancels the transaction in progress on the connection.

Properties


isOracle	Returns true if the database is Oracle.
isDB2	Returns true if the database is of DB2 type.
isMySQL	Returns true if the database is of MySQL type.
isMSSQL	Returns true if the database is SQL Server.
isPostgreSQL	Returns true if the database is PostgreSQL.
isSybase	Returns true if the database is Sybase.
isSybaseIQ	Returns true if the database is Sybase IQ.
isFDA	Returns true if the database is accessed through FDA.
isBroken	Returns true if the connection is no longer usable.
useUnicodeData	Returns true if the database contains unicode data.
useNChar	Returns true if Adobe Campaign uses NCHAR, NVARCHAR, NCLOB, NTEXT type fields.

Features

Available in:

Content management
Delivery properties
Typology rule
JSSP
SOAP Method
WebApp
Workflow