>We load heaps of comma delimited text files into tables, and I'd like to know if there is some way of checking to see if a particular file has already been loaded - as sometimes data files are loaded twice (which is a no-no). Most of the files have generic names, so we really need to check the actual contents of the file before we load it - not just the file name.
>
>If anyone has any ideas - I'm all ears!
If the files are small (< 16MB) you could combine
FILETOSTR() and
SYS(2007) to keep
file signatures.
----------------------------------
António Tavares Lopes