OK.
I understand now what you are trying to achieve.
There are two ways of doing it
Number one
Create two import scripts
First script will update existing data (Transformation=Update Records)
Second one will add new records. (Transformation=Add new Records)
enter following sql in SQL Before for second script
VARIABLE x NUMBER
BEGIN
select max ( POHEADERID ) into : X from yourtable;
execute immediate 'create sequence tmp_seq start with '||to_char( : X );
END;
/
and enter
drop sequence tmp_seq;
in SQl after.
than for POHEADERID field set mapping type to sql function and type tmp_seq.nextval
This way will work if you allowed to create sequences in your database and nobody is adding records to the database except you.
Number two
Create two import scripts
First script will update existing data (Transformation=Update Records)
Second one will add new records. (Transformation=Add new Records)
You must use ODBC connection for second script.
For second script, for POHEADERID field set mapping type to sql function and type (select max(POHEADERID)+1 from yourtable)
Second way is slower than first one.
Let us know the outcome
John
