We hava been able to
produce the SQL that returns us a Vertical table with the
from table CLIENTES
(sql against qsys2/syscolumns).
WHERE TABLE_NAME = 'CLIENTES'
AND TABLE_SCHEMA =
Column 1 Column 2
xhrsurname Last Name
Now I would like to join this column label names (name, last name),
which will be different for another table (so they should be variables),
and add them to another sql select from the same table and library,
whicch would only obtain data. Brian SMith, Laura Willcox......
Otherwise , can an sql be done to a table that already brings along
the column headings, instedad of column 1, column 2....?
as400, axes from lansa
April 19, 2012 8:15 AM
April 20, 2012 11:30 PM