Calls an editor that lets you edit the RDO statements you have issued within a terminal session. By default, Oracle Rdb uses the EDT editor. You can use the editor to modify your previous RDO statements, construct your next statement or group of statements, or include a file with other statements. Example using EDT to edit an RDO statement: RDO> FOR J IN JOSB PRINT J.JOB_TITLE END_FOR %RDO-F-RELNOTDEF, Relation JOSB is not defined in database RDO> EDIT FOR J IN JOSB PRINT J.JOB_TITLE END_FOR [EOB]
1 – More
If you have invoked a database, you have the necessary privileges to use the EDIT statement. If you have the VAX Text Processing Utility (VAXTPU) installed on your system, you can invoke VAXTPU with the EDIT statement in an RDO session. To use VAXTPU in an RDO session, define the logical name RDO$EDIT in the following way: $ DEFINE RDO$EDIT "TPU" Then, when you type EDIT in an RDO session, VAXTPU is invoked. If RDO$EDIT is not defined, or is defined to be something other than VAXTPU, then the EDT editor will be invoked when you issue the EDIT statement. If RDO cannot find the VAXTPU shareable image, EDT will be invoked. To use your personal VAXTPU section file with RDO EDIT, you must define the logical name TPU$SECTION to be your personal section file. You can use the editor you choose with your usual initialization file to modify your previous RDO statements, construct your next statement or group of statements, or include a file with other statements.
2 – Format
(B)0[m[4mEDIT[m qqqqwqqqqq>qqqqqqqwqqq> tqq> number qqu mqq> * qqqqqqqj
2.1 – number
The number of previous statements you want to edit. This must be an integer. If you specify 0, RDO calls the editor with an empty main editing buffer. The default is 1.
2.2 – asterisk
The wild card character (*). If you use the wild card, RDO includes in the editing buffer n previous statements, where n is the number specified in SET EDIT KEEP n. The default is 20 statements.
3 – Example
The following sequence demonstrates the correction of a misspelled statement: 1. Make a mistake: RDO> FOR J IN JOSB cont> PRINT J.JOB_TITLE END_FOR %RDO-F-RELNOTDEF, Relation JOSB is not defined in database RDO> 2. Invoke the EDT editor: RDO> EDIT 3. When in the editor, change "JOSB" to "JOBS". 4. Exit from the editor. RDO automatically executes the contents of the editing buffer. * EXIT Associate Programmer Clerk Deputy Gopher Department Manager Dept. Supervisor . . .