We recently updated our Rapid holdings. I've never done that before and the procedure was undocumented. Someone from Oklahoma State University was kind enough to share their procedure, which was a series of MS Access queries that were broken up to permit large resultsets. Lucky for me, we have a relatively small collection so I rewrote it in Oracle SQL and as a single query.
SELECT
BIB_TEXT.TITLE_BRIEF AS TITLE
, BIB_TEXT.ISSN
, MFHD_ITEM.ITEM_ENUM as HLDGS
, MFHD_ITEM.CHRON as Second866
, LOCATION.LOCATION_CODE
, BIB_TEXT.NETWORK_NUMBER
, MFHD_MASTER.DISPLAY_CALL_NO
FROM
BIB_MASTER
INNER JOIN BIB_TEXT USING(BIB_ID)
INNER JOIN BIB_MFHD USING(BIB_ID)
INNER JOIN MFHD_MASTER USING(MFHD_ID)
INNER JOIN LOCATION USING(LOCATION_ID)
INNER JOIN MFHD_ITEM USING(MFHD_ID)
WHERE
BIB_MASTER.SUPPRESS_IN_OPAC='N' AND
MFHD_MASTER.SUPPRESS_IN_OPAC='N' AND
BIB_TEXT.BIB_FORMAT Like '%s' AND
BIB_TEXT.ISSN is not null AND
(LOCATION.LOCATION_CODE Like 'PERIODICAL' OR
LOCATION.LOCATION_CODE Like 'ARCHIVES' OR
LOCATION.LOCATION_CODE Like 'CURPER' OR
LOCATION.LOCATION_CODE Like 'CURRPER' OR
LOCATION.LOCATION_CODE Like 'CURREF' OR
LOCATION.LOCATION_CODE Like 'CURRREF' OR
LOCATION.LOCATION_CODE Like 'CURSTA' OR
LOCATION.LOCATION_CODE Like 'CURRSTA' OR
LOCATION.LOCATION_CODE Like 'MAINSTA' OR
LOCATION.LOCATION_CODE Like 'MICROFICHE' OR
LOCATION.LOCATION_CODE Like 'MICROFILM' OR
LOCATION.LOCATION_CODE Like 'OVERSIZE' OR
LOCATION.LOCATION_CODE Like 'MICROREF' OR
LOCATION.LOCATION_CODE Like 'REFERENCE' OR
LOCATION.LOCATION_CODE Like 'SPECCOLL' OR
LOCATION.LOCATION_CODE Like 'WWW'
)
ORDER BY
ISSN ASC
I run this through a short Java program I wrote. It uses JDBC and Oracle's thin driver to execute the SQL statement and returns the result as a comma-delimited file using the CSVWriter from Java CSV Library. The above SQL will work with any Oracle driver, but will require slight modification to run under MS-Access.