##
SELECT FILENAME FROM SEARCH_CLASSIFIEDS
WHERE FILENAME IN ( filename_list )
SORT BY FIRST50CHARS
##
##
CREATE TABLE CLS_TMP_$$
FILENAME VARCHAR(40)
NOLOGGING
##
##
SELECT FILENAME FROM SEARCH_CLASSIFIEDS
WHERE FILENAME IN ( SELECT FILENAME FROM CLS_TMP_$$ )
SORT BY FIRST50CHARS
##
##
foreach (@files) {
# INSERT INTO CLS_TMP_$$ values('$_')
}