Take a look at the TPump manuals for restrictions on the types of statements you can use. Since TPump isn't exactly a bulk loader, you might be able to use ANSI Merge. But you really don't need to. TPump has it's own capability to do an UPSERT. See the manual for "DO INSERT FOR MISSING UPDATE ROWS".