In response to this bit of your post :
=> Can I, in a RESIDENT LOAD, implement a WHERE NOT EXISTS() that refers to a field that is not in the table I'm currently loading, but in a previously loaded table?
The field needs to be in both :
- The load statement with the WHERE NOT EXISTS()
- A previously loaded statement
thanks a lot! That is all I wanted to know - so I did do it right, which is good ;-) I will just insert one line of comment to make it clear what is done in that clause (I generally stick to inserting roughly 1 line every 5 lines of code, or wherever some explanation is needed)