Hi,
Having failed with the production task I've created a file on the AS400 with two fields EFEMNO (Employee Number) and EFSTDT (Start Date) and I'm trying to populate the file from a SQL7 table which has more columns/fields but identical field names using the following SQL in the DTS job
select efemno, efstdt from csempspf.
The message I get is "Query cannot be updated because it contains no searchable columns to use as a key"
which is curious since the DB2 physical file is unique keyed on EFEMNO.
Any advice gratefully received.