Column name from view

If the table is from a view, PowerBuilder and PowerServer will generate different column names.

For example,

//v_cust_dept is from view cust_dept
select  v_cust_dept.v_id from v_cust_dept;

PowerBuilder will generate the column name as v_cust_dept_v_id; while PowerServer will generate the column name as cust_dept_v_id.

If using dw_1.getitem(1,"v_cust_dept_v_id") to get data, runtime error will occur. Use dw_1.getitem(1,index) instead.