so you could run a CREATE EXTERNAL TABLE command.
Then run a CREATE PROCEDURE command that works off that one.
run both of these commands

in the stored procedure you could do this.

FOR SELECT FOO1, FOO2 FROM EXT_FOO
INTO
:FOO1, :FOO2
DO
TRY
INSERT INTO IMPORT_FOO
(FOO1, FOO2)
VALUES
:FOO1, :FOO2;
EXCEPT
UPDATE IMPORT_FOO
SET F003 = :FOO3
WHERE
( FOO1 = :FOO1 )
AND( FOO2 = :FOOW
END

EXECUTE PROCEDURE ....
Then it should be doing an append update thing.
would this work ?

Regards,

Robert