Differences

This shows you the differences between two versions of the page.

--- v5:reference:connection:setconnectionparameter [2022/07/13 03:26] – [Other Usage] mnewnham
+++ v5:reference:connection:setconnectionparameter [2022/07/13 03:47] (current) – [IDM DB2] mnewnham
@@ Line 77: / Line 77: @@
-===== SQL Server =====
+==== SQL Server ====
 Parameters must be set from the list of Microsoft [[https://docs.microsoft.com/en-us/sql/connect/php/connection-options|PHP Connection Options]]
@@ Line 88: / Line 88: @@
 </code>
-===== IDM DB2 =====
+==== IDM DB2 ====
+Parameters must be chosen from the list of DB2 [[https://www.php.net/manual/en/function.db2-connect|Connection Parameters]]
 <code php>
 /*
- * Connecting to DB2 Database
+ * Example Setting Auto-commit
  */
 $db->setConnectionParameter('autocommit',DB2_AUTOCOMMIT_ON);
@@ Line 97: / Line 98: @@
 </code>
+==== PDO Driver ====
+Any parameter from the PHP [[https://www.php.net/manual/en/pdo.setattribute|PDO Attribute List]]
+<code php>
+/*
+ * Example Setting Timeout Duration
+ */
+$db->setConnectionParameter(PDO::ATTR_TIMEOUT,60);
+$db->connect(mysql:$dsn,'user','password');
+</code>