Here is what I'd like to do:

Modify DB_TABLE_ABC from TEMP_INPUT, match KEY1 and KEY2, insert or update COL1; set MOD_TYPE='Updated' if there is a match in the table, set MOD_TYPE='Inserted' if there is no match and insert the record.

What is the correct syntax?

TABLE FILE TEMP_ABC
PRINT 
KEY1
KEY2
COL1
ON TABLE HOLD AS TEMP_INPUT FORMAT ALPHA
END


MODIFY DB_TABLE_ABC
FIXFORM FROM TEMP_INPUT
MATCH KEY1 KEY2
ON MATCH   UPDATE  COL1 MOD_TYPE='Updated'
ON NOMATCH INCLUDE COL2 MOD_TYPE='Inerted'
DATA ON TEMP_INPUT
END
-RUN

Thanks!

This message has been edited. Last edited by: bug,

Try this approach:

MODIFY DB_TABLE_ABC
FIXFORM FROM TEMP_INPUT
MATCH KEY1 KEY2
ON NOMATCH COMPUTE MOD_TYPE='Inserted';
ON NOMATCH INCLUDE 
ON MATCH   COMPUTE MOD_TYPE='Updated';
ON MATCH   UPDATE  COL1 MOD_TYPE
DATA ON TEMP_INPUT
END

This works! Thank you so much Alan!

quote:

Originally posted by Alan B:
Try this approach:

MODIFY DB_TABLE_ABC
FIXFORM FROM TEMP_INPUT
MATCH KEY1 KEY2
ON NOMATCH COMPUTE MOD_TYPE='Inserted';
ON NOMATCH INCLUDE 
ON MATCH   COMPUTE MOD_TYPE='Updated';
ON MATCH   UPDATE  COL1 MOD_TYPE
DATA ON TEMP_INPUT
END

There are still MODIFY manuals on the documentation site, but they are a little difficule to find.