PDOSQLExecTask

The PDOSQLExecTask executes SQL statements using PDO.

Note

The combination of large SQL files and delimitertype set to normal can trigger segmentation faults with large files.

Table 106. Attributes

Name Type Description Default Required
url String PDO connection URL (DSN) none Yes
userid String Username for connection (if it cannot be specified in URL) none No
password String The password to use for the connection (if it cannot be specified in URL) none No
src File A single source file of SQL statements to execute. none No
onerror String The action to perform on error (continue, stop, or abort) abort No
delimiter String The delimeter to separate SQL statements (e.g. "GO" in MSSQL) ; No
delimitertype String The delimiter type ("normal", "row" or "none"). Normal means that any occurence of the delimiter terminate the SQL command whereas with row, only a line containing just the delimiter is recognized as the end of the command. None disables all delimiter detection. none No
autocommit Boolean Whether to autocommit every single statement. false No
encoding String Encoding to use for read SQL files none No