Operating System - OpenVMS
cancel
Showing results for 
Search instead for 
Did you mean: 

dumping RDB table to flat file

 
SAMI AHMAD
Regular Advisor

dumping RDB table to flat file

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

 

thanks

2 REPLIES 2
Brad McCusker
Respected Contributor

Re: dumping RDB table to flat file

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

 

Brad McCusker
Software Concepts International
Hoff
Honored Contributor

Re: dumping RDB table to flat file

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.