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....?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!