I have a file named IAMPRJD and another file named IAMPRJHST that has the exact same record format. Using SQL, I want to insert records from IAMPRJD into IAMPRJHST that do not have the same values in PRONUM, SRCNME, SRCTYP
Announcement
Collapse
No announcement yet.
SQL Needed
Collapse
X
-
I found this post which solves my problem, no need to reply
I have 2 files, COMMOM and COMMONBK that are indentical except COMMONBK contains some rows that are not in COMMON. How can I insert the rows into COMMON that exist in COMMONBK but not in COMMON based on 2 key fields FLD1 and FLD2. It seems I did this a long time ago using the EXISTS clause in an INSERT stmt
- Likes 1
Comment