select name as ".......NAME.........." from sysibm.syscolumns
where tbname = ucase('SUB_RED_HY')
order by 1

	//SQL quyery  
$Query = "SELECT * from iesfile.drivers";

//execute query 
$queryexe = odbc_do($connectionstring, $Query);

 //query database
while(odbc_fetch_row($queryexe)) 
    {
    	
    //collect results 
    
    $numfields = odbc_num_fields($queryexe);
    
      for($i = 1;$i <= odbc_num_fields($queryexe);$i++)
    {
        $odbc['rows']['fieldnames'][$i] = odbc_field_name($queryexe,$i);
        $odbc['rows']['fieldtypes'][$i] = odbc_field_type($queryexe,$i);
        $odbc['rows']['fieldlengths'][$i] = odbc_field_len($queryexe,$i);
    }
    unset($i);
        
          }