Re: File Conversion Utility Search

[rob@xxxxxxxxx]

You mean like something initially populated with:
create table rob/xref 
as (select system_column_name as FromField,
           System_table_name as FromFile, 
           system_column_name as ToField, 
           System_table_name as ToFile 
    from qsys2/syscolumns) 
with NO DATA 

ALTER TABLE ROB/XREF ALTER COLUMN TOFILE DROP NOT NULL

ALTER TABLE ROB/XREF ALTER COLUMN TOFIELD DROP NOT NULL

insert into rob/xref (FromField, FromFile)
 (select system_column_name, 
           System_table_name 
    from qsys2/syscolumns 
    where system_table_schema='ROB') 


Rob Berendt