From 841dbc40cf0d351ff9a5c32158ac8825ca2c18e7 Mon Sep 17 00:00:00 2001
From: Mark Newnham <mark@newnhams.com>
Date: Mon, 27 May 2024 11:32:08 -0600
Subject: Added SET SCHEMA support

---
 drivers/adodb-db2.inc.php | 8 ++++++++
 1 file changed, 8 insertions(+)

(limited to 'drivers')

diff --git a/drivers/adodb-db2.inc.php b/drivers/adodb-db2.inc.php
index eaef8f73..b7819c7b 100644
--- a/drivers/adodb-db2.inc.php
+++ b/drivers/adodb-db2.inc.php
@@ -170,12 +170,17 @@ class ADODB_db2 extends ADOConnection {
 					$db2Options[$k] = $v;
 		}
 
+		$schema = '';
 		if ($useCataloguedConnection)
+		{
 			$this->_connectionID = $db2Function($argDatabasename,
 												$argUsername,
 												$argPassword,
 												$db2Options);
+			$schema = $argDatabasename;
+		}
 		else
+		
 			$this->_connectionID = $db2Function($argDSN,
 												'',
 												'',
@@ -187,6 +192,9 @@ class ADODB_db2 extends ADOConnection {
 		if ($this->_connectionID && $this->connectStmt)
 			$this->execute($this->connectStmt);
 
+		if ($this->_connectionID && $schema)
+			$this->execute("SET SCHEMA=$schema");
+		
 		return $this->_connectionID != false;
 
 	}
-- 
cgit v1.3