gistfile1.aw

<?php

	class Model_Browser extends Model {
		
		public function list_schemas ( $like = null ) {
			
			$query = \DB::select( array( 'table_schem', 'schema' ) )->from( 'sysibm.sqltables' );
			
			if ( $like != null ) {
				$query->where( 'table_schem', 'like', $like );
			}
			
			$query->order_by('schema');
			
			// make it distinct
			$query->distinct();
			
			// we want an object back
			$query->as_object();
			
			// execute!
			$result = $query->execute();
			
			return $result;
			
		}
		
	}

?>