$isview = strncmp($ttype,'V',1) === 0;		}		for ($i=0; $i < sizeof($arr); $i++) {			if (!$arr[$i][2]) continue;			$type = $arr[$i][3];			$schemaval = ($schema) ? $arr[$i][1].'.' : '';			if ($ttype) { 				if ($isview) {					if (strncmp($type,'V',1) === 0) $arr2[] = $schemaval.$arr[$i][2];				} else if (strncmp($type,'SYS',3) !== 0) $arr2[] = $schemaval.$arr[$i][2];			} else if (strncmp($type,'SYS',3) !== 0) $arr2[] = $schemaval.$arr[$i][2];		}		return $arr2;	}	/*See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/db2/htm/db2datetime_data_type_changes.asp/ SQL data type codes /#define	SQL_UNKNOWN_TYPE	0#define SQL_CHAR			1#define SQL_NUMERIC		 2#define SQL_DECIMAL		 3#define SQL_INTEGER		 4#define SQL_SMALLINT		5#define SQL_FLOAT		   6#define SQL_REAL			7#define SQL_DOUBLE		  8#if (DB2VER >= 0x0300)#define SQL_DATETIME		9#endif#define SQL_VARCHAR		12/ One-parameter shortcuts for date/time data types /#if (DB2VER >= 0x0300)#define SQL_TYPE_DATE	  91#define SQL_TYPE_TIME	  92#define SQL_TYPE_TIMESTAMP 93#define SQL_UNICODE                             (-95)#define SQL_UNICODE_VARCHAR                     (-96)#define SQL_UNICODE_LONGVARCHAR                 (-97)*/	function DB2Types($t)	{		switch ((integer)$t) {		case 1:			case 12:		case 0:		case -95:		case -96:			return 'C';		case -97:		case -1: //text			return 'X';		case -4: //image			return 'B';						case 9:			case 91:			return 'D';				case 10:		case 11:		case 92:		case 93:			return 'T';					case 4:		case 5:		case -6:			return 'I';					case -11: // uniqidentifier			return 'R';		case -7: //bit			return 'L';				default:			return 'N';		}	}		function &MetaColumns($table)	{	global $ADODB_FETCH_MODE;			$false = false;		if ($this->uCaseTables) $table = strtoupper($table);		$schema = '';		$this->_findschema($table,$schema);				$savem = $ADODB_FETCH_MODE;		$ADODB_FETCH_MODE = ADODB_FETCH_NUM;	        	$colname = "%";	        $qid = db2_columns($this->_connectionID, "", $schema, $table, $colname);		if (empty($qid)) return $false;				$rs =& new ADORecordSet_db2($qid);		$ADODB_FETCH_MODE = $savem;				if (!$rs) return $false;		$rs->_fetch();				$retarr = array();				/*		$rs->fields indices		0 TABLE_QUALIFIER		1 TABLE_SCHEM		2 TABLE_NAME		3 COLUMN_NAME		4 DATA_TYPE		5 TYPE_NAME		6 PRECISION		7 LENGTH		8 SCALE		9 RADIX		10 NULLABLE		11 REMARKS		*/		while (!$rs->EOF) {			if (strtoupper(trim($rs->fields[2])) == $table && (!$schema || strtoupper($rs->fields[1]) == $schema)) {				$fld = new ADOFieldObject();				$fld->name = $rs->fields[3];				$fld->type = $this->DB2Types($rs->fields[4]);								// ref: http://msdn.microsoft.com/library/default.asp?url=/archive/en-us/dnaraccgen/html/msdn_odk.asp				// access uses precision to store length for char/varchar				if ($fld->type == 'C' or $fld->type == 'X') {					if ($rs->fields[4] <= -95) // UNICODE						$fld->max_length = $rs->fields[7]/2;					else						$fld->max_length = $rs->fields[7];				} else 					$fld->max_length = $rs->fields[7];				$fld->not_null = !empty($rs->fields[10]);				$fld->scale = $rs->fields[8];				$fld->primary_key = false;				$retarr[strtoupper($fld->name)] = $fld;				} else if (sizeof($retarr)>0)				break;			$rs->MoveNext();		}		$rs->Close(); 		if (empty($retarr)) $retarr = false;	      $qid = db2_primary_keys($this->_connectionID, "", $schema, $table);		if (empty($qid)) return $false;				$rs =& new ADORecordSet_db2($qid);		$ADODB_FETCH_MODE = $savem;				if (!$rs) return $retarr;		$rs->_fetch();				/*		$rs->fields indices		0 TABLE_CAT		1 TABLE_SCHEM		2 TABLE_NAME		3 COLUMN_NAME		4 KEY_SEQ		5 PK_NAME		*/		while (!$rs->EOF) {			if (strtoupper(trim($rs->fields[2])) == $table && (!$schema || strtoupper($rs->fields[1]) == $schema)) {				$retarr[strtoupper($rs->fields[3])]->primary_key = true;			} else if (sizeof($retarr)>0)				break;			$rs->MoveNext();		}		$rs->Close(); 				if (empty($retarr)) $retarr = false;		return $retarr;	}		function Prepare($sql)	{		if (! $this->_bindInputArray) return $sql; // no binding		$stmt = db2_prepare($this->_connectionID,$sql);		if (!$stmt) {			// we don't know whether db2 driver is parsing prepared stmts, so just return sql			return $sql;		}		return array($sql,$stmt,false);	}	/* returns queryID or false */	function _query($sql,$inputarr=false) 	{	GLOBAL $php_errormsg;		if (isset($php_errormsg)) $php_errormsg = '';		$this->_error = '';				if ($inputarr) {			if (is_array($sql)) {				$stmtid = $sql[1];			} else {				$stmtid = db2_prepare($this->_connectionID,$sql);					if ($stmtid == false) {					$this->_errorMsg = isset($php_errormsg) ? $php_errormsg : '';					return false;				}			}						if (! db2_execute($stmtid,$inputarr)) {				if ($this->_haserrorfunctions) {					$this->_errorMsg = db2_stmt_errormsg();					$this->_errorCode = db2_stmt_error();				}				return false;			}				} else if (is_array($sql)) {			$stmtid = $sql[1];			if (!db2_execute($stmtid)) {				if ($this->_haserrorfunctions) {					$this->_errorMsg = db2_stmt_errormsg();					$this->_errorCode = db2_stmt_error();				}				return false;			}		} else			$stmtid = @db2_exec($this->_connectionID,$sql);				$this->_lastAffectedRows = 0;		if ($stmtid) {			if (@db2_num_fields($stmtid) == 0) {				$this->_lastAffectedRows = db2_num_rows($stmtid);				$stmtid = true;			} else {				$this->_lastAffectedRows = 0;			}						if ($this->_haserrorfunctions) {				$this->_errorMsg = '';				$this->_errorCode = 0;			} else				$this->_errorMsg = isset($php_errormsg) ? $php_errormsg : '';		} else {			if ($this->_haserrorfunctions) {				$this->_errorMsg = db2_stmt_errormsg();				$this->_errorCode = db2_stmt_error();			} else				$this->_errorMsg = isset($php_errormsg) ? $php_errormsg : '';		}		return $stmtid;	}	/*		Insert a null into the blob field of the table first.		Then use UpdateBlob to store the blob.				Usage:		 		$conn->Execute('INSERT INTO blobtable (id, blobcol) VALUES (1, null)');		$conn->UpdateBlob('blobtable','blobcol',$blob,'id=1');	*/	function UpdateBlob($table,$column,$val,$where,$blobtype='BLOB')	{		return $this->Execute("UPDATE $table SET $column=? WHERE $where",array($val)) != false;	}		// returns true or false	function _close()	{		$ret = @db2_close($this->_connectionID);		$this->_connectionID = false;		return $ret;	}	function _affectedrows()	{		return $this->_lastAffectedRows;	}	}	/*--------------------------------------------------------------------------------------	 Class Name: Recordset--------------------------------------------------------------------------------------*/class ADORecordSet_db2 extends ADORecordSet {			var $bind = false;	var $databaseType = "db2";			var $dataProvider = "db2";	var $useFetchArray;		function ADORecordSet_db2($id,$mode=false)	{		if ($mode === false) {  			global $ADODB_FETCH_MODE;			$mode = $ADODB_FETCH_MODE;		}		$this->fetchMode = $mode;				$this->_queryID = $id;	}	// returns the field object	function &FetchField($offset = -1) 	{		$o= new ADOFieldObject();		$o->name = @db2_field_name($this->_queryID,$offset);		$o->type = @db2_field_type($this->_queryID,$offset);		$o->max_length = db2_field_width($this->_queryID,$offset);		if (ADODB_ASSOC_CASE == 0) $o->name = strtolower($o->name);		else if (ADODB_ASSOC_CASE == 1) $o->name = strtoupper($o->name);		return $o;	}		/* Use associative array to get fields array */	function Fields($colname)	{		if ($this->fetchMode & ADODB_FETCH_ASSOC) return $this->fields[$colname];		if (!$this->bind) {			$this->bind = array();			for ($i=0; $i < $this->_numOfFields; $i++) {				$o = $this->FetchField($i);				$this->bind[strtoupper($o->name)] = $i;			}		}		 return $this->fields[$this->bind[strtoupper($colname)]];	}				function _initrs()	{	global $ADODB_COUNTRECS;		$this->_numOfRows = ($ADODB_COUNTRECS) ? @db2_num_rows($this->_queryID) : -1;		$this->_numOfFields = @db2_num_fields($this->_queryID);		// some silly drivers such as db2 as/400 and intersystems cache return _numOfRows = 0		if ($this->_numOfRows == 0) $this->_numOfRows = -1;	}			function _seek($row)	{		return false;	}		// speed up SelectLimit() by switching to ADODB_FETCH_NUM as ADODB_FETCH_ASSOC is emulated	function &GetArrayLimit($nrows,$offset=-1) 	{		if ($offset <= 0) {			$rs =& $this->GetArray($nrows);			return $rs;		}		$savem = $this->fetchMode;		$this->fetchMode = ADODB_FETCH_NUM;		$this->Move($offset);		$this->fetchMode = $savem;				if ($this->fetchMode & ADODB_FETCH_ASSOC) {			$this->fields =& $this->GetRowAssoc(ADODB_ASSOC_CASE);		}				$results = array();		$cnt = 0;		while (!$this->EOF && $nrows != $cnt) {			$results[$cnt++] = $this->fields;			$this->MoveNext();		}				return $results;	}			function MoveNext() 	{		if ($this->_numOfRows != 0 && !$this->EOF) {					$this->_currentRow++;						$this->fields = @db2_fetch_array($this->_queryID);			if ($this->fields) {				if ($this->fetchMode & ADODB_FETCH_ASSOC) {					$this->fields =& $this->GetRowAssoc(ADODB_ASSOC_CASE);				}				return true;			}		}		$this->fields = false;		$this->EOF = true;		return false;	}			function _fetch()	{		$this->fields = db2_fetch_array($this->_queryID);		if ($this->fields) {			if ($this->fetchMode & ADODB_FETCH_ASSOC) {				$this->fields =& $this->GetRowAssoc(ADODB_ASSOC_CASE);			}			return true;		}		$this->fields = false;		return false;	}		function _close() 	{		return @db2_free_result($this->_queryID);			}}?>