>If you have to test for existence in a batch insert, you should *not* be
>doing this in the client. I'm curious to know how you are doing
>conditional insert/update in batch in a single DSQL statement.

Why shouldn't I be doing it in the client? This isn't a one-time batch
insert into a single database. I'm actually incorporating an import
function into my client application.

I'm not doing this all in a single DSQL statement. I'm using several DSQL
statements in a loop:

while (not at end of source dataset)
select to see if key exists // First DSQL statement
if (exists)
update // Second DSQL statement
else
insert // Third DSQL statement
go to next source record
end while loop

-Joe