topic Re: dumping RDB table to flat file in Operating System - OpenVMS

dumping RDB table to flat file

SAMI AHMAD — Fri, 30 Jan 2015 17:24:53 GMT

how can i dump a RDB table to plain text file ?

thanks

Re: dumping RDB table to flat file

Brad McCusker — Fri, 30 Jan 2015 18:09:55 GMT

The easiest way to dump an Rdb table to a text file is to use the RMU/UNLOAD facility. The output can be a simple flat file, a comma delimited list or even an XML document.

$ RMU/UNLOAD/FIELDS=(EMPLOYEE_ID, LAST_NAME) -

-$ /RECORD_DEFINITION=(FILE=NAMES, FORMAT=DELIMITED_TEXT) -

-$ MF_PERSONNEL EMPLOYEES NAMES.UNL

Hope this helps.

Brad McCusker

Software Concepts International

www.sciinc.com

Re: dumping RDB table to flat file

Hoff — Fri, 30 Jan 2015 18:11:21 GMT

Best to ask these questions in the Oracle forums, as Rdb is an Oracle product, and there are typically more folks that use Rdb over there than around here. Also best to include some details with your question, such as your OpenVMS and Rdb versions - it's quite possible that the following answer will not apply here, as you're could well be running ancient VMS and ancient Rdb.

For details on using the products, start with the Rdb RMU utility documentation and the Oracle Rdb SQL documentation for the commands and syntax (for your Rdb version, of course). Or start with some of the existing discussions around the net' such as here and here and here and here and here; I'd usually expect to see SQL EXPORT and SQL IMPORT and/or RMU /EXTRACT and RMU /UNLOAD commands used here, depending on exactly what you're up to with your text export.