TABLE SEARCH_CLASSIFIEDS
    FILENAME  VARCHAR(40)
    FIRST50CHARS  VARCHAR(50)
    PUB_DATE  DATE

##</code><code>##

SELECT FILENAME FROM SEARCH_CLASSIFIEDS
WHERE FILENAME IN ( filename_list )
SORT BY FIRST50CHARS

##</code><code>##

CREATE TABLE CLS_TMP_$$
    FILENAME  VARCHAR(40)
NOLOGGING

##</code><code>##

SELECT FILENAME FROM SEARCH_CLASSIFIEDS
WHERE FILENAME IN ( SELECT FILENAME FROM CLS_TMP_$$ )
SORT BY FIRST50CHARS

##</code><code>##

foreach (@files) {
  # INSERT INTO CLS_TMP_$$ values('$_')
}