Re: SQL auto-generates select list of fields for primary select

Keeping in mind that you can do

select system_column_name
from syscolumns
where system_table_name='MYFILE' and system_table_scheme='MYLIB' and
system_column_name not in('PAYRATE', 'SSN')

perhaps you can figure out some way to concatenate that list. Someone
recently did something with XML in SQL that blew my mind.

But the long slow painful way in RPG could be done and then you could
store your sql command string in a variable,
use PREPARE and EXECUTE (or EXECUTE IMMEDIATE) and get your desired
statement.

Rob Berendt