If you have invoked a database, you have the necessary privileges to use the GET statement. In RDBPRE programs, you can use the GET statement in three ways: o When you establish a record stream with the FOR or START_ STREAM statement, you use the GET statement to assign values from the current record in the stream to variables in your program. In the case of START_STREAM, you also need FETCH to indicate the current record in the stream. o You can use GET alone, without a FOR or FETCH statement, to retrieve the result of a statistical function. The record stream is formed by the record selection expression within the statistical expression. o Or you can use GET...RDB$DB_KEY in a STORE...END_STORE block to retrieve the database key of the record just stored. Example: &RDB& STORE E IN EMPLOYEES USING E.EMPLOYEE_ID = 15231; &RDB& E.LAST_NAME = "Smith"; &RDB& GET MY_DB_KEY = E.RDB$DB_KEY; &RDB& END_GET &RDB& END_STORE (MY_DB_KEY is a user-defined host language variable.) You cannot use the concatenation operation in a GET statement. NOTE Use the GET statement only in RDBPRE programs. RDO uses the PRINT statement to display values on the terminal.