diff options
| author | Mark Newnham <mark@newnhams.com> | 2024-05-27 11:32:08 -0600 |
|---|---|---|
| committer | Damien Regad <dregad@mantisbt.org> | 2024-08-28 09:24:07 +0200 |
| commit | 841dbc40cf0d351ff9a5c32158ac8825ca2c18e7 (patch) | |
| tree | dd464785b3af31c8fce95eb0b2612f26ce34c7f9 | |
| parent | cb18a9dab2eb113feb878af7c3b3639c39354bbf (diff) | |
| download | adodb-841dbc40cf0d351ff9a5c32158ac8825ca2c18e7.tar.gz adodb-841dbc40cf0d351ff9a5c32158ac8825ca2c18e7.tar.bz2 adodb-841dbc40cf0d351ff9a5c32158ac8825ca2c18e7.zip | |
Added SET SCHEMA support
| -rw-r--r-- | drivers/adodb-db2.inc.php | 8 |
1 files changed, 8 insertions, 0 deletions
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; } |