DB2_I5_NAMING_OFF,'i5_libl'=>'CDCFILE MCPDFILE');
//$conn = db2_connect($database,"","");
if ($conn) {
$sql = "SELECT CDCODE,CDNAME
FROM cdcfile.pfscode
WHERE cdid='TC' and cdstat=' '
ORDER BY cdcode asc
";
$query = odbc_exec($conn, $sql);
while ($row=odbc_fetch_object($query)) {
$ccode= $row->CDCODE;
$cname= $row->CDNAME;
array_push($acode , $ccode);
array_push($aname , $cname);
}
}
?>
select