1  PRINT
   Displays values from data records in a record stream on the
   current default output device. PRINT is intended for testing
   and learning. Using PRINT, you can type a query at the terminal
   and see the results immediately. You can also use the SET OUTPUT
   statement to write the results to a file or another output
   device.

   PRINT is valid only in RDO. To retrieve values in an RDBPRE
   program, use the GET statement to assign database values to host
   language variables.

   RDO Example:

   RDO>  FOR J IN JOBS
   cont>  PRINT J.JOB_CODE, J.JOB_TITLE
   cont> END_FOR
 

2  More
   If you have invoked a database, you have the necessary privileges
   to use the PRINT statement.

   You can use the PRINT statement in three ways:

   o  When you establish a record stream with the FOR or START_
      STREAM statement, you use the PRINT statement to write values
      from the current record stream to the output device. In the
      case of START_STREAM, you also need FETCH to indicate the
      current record in the stream.

   o  You can also use PRINT 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  You can use PRINT...RDB$DB_KEY in a STORE...END_STORE block to
      display the database key of the record just stored. Example:

      RDO> STORE E IN EMPLOYEES USING
      cont>  E.EMPLOYEE_ID = "15231";
      cont>  E.LAST_NAME = "Smith";
      cont>   PRINT E.RDB$DB_KEY
      cont> END_STORE
                  RDB$DB_KEY
                    21:339:0
 

2  Format

 (B)0PRINT qqqwqwqqq> value-expr qqqqqqqqwqwqqq>
          x mqqq> context-var . * qqqj x
          mqqqqqqqqqqqqqq , <qqqqqqqqqqj

   Also see STORE syntax for example of using PRINT...RDB$DB_KEY in
   RDO within a STORE...END_STORE block.
 

3  value-expr
   A valid Oracle Rdb value expression. Request HELP on Value_expr for
   more information.
 

3  context-var
   A context variable you have defined in a FOR or START_STREAM
   statement. Use a context variable and a wildcard character (*)
   to display all the fields for each record in the record stream.
   If you use the wildcard character, RDO uses the field names as
   column headers on the display.
 

2  Examples
   Example 1

   Retrieve all the field values from one or more relations

   RDO> START_TRANSACTION READ_ONLY
   RDO>
   RDO>  FOR E IN EMPLOYEES
   cont>  PRINT E.*
   cont> END_FOR
   RDO>
   RDO> COMMIT

   You can use the wildcard character (*) to display all fields from
   one or more relations named in your RSE. RDO displays the names
   of the fields as column headers and displays the corresponding
   field values beneath them. When you use the wildcard character,
   you cannot display values for segmented strings, literals, or
   statistical expressions.

   This RDO query displays all the field values from each record in
   the EMPLOYEES relation.

   Example 2

   Retrieve values from named fields in a relation:

   RDO> START_TRANSACTION READ_ONLY
   RDO>
   RDO>  FOR E IN EMPLOYEES
   cont>  PRINT E.LAST_NAME, E.FIRST_NAME, E.MIDDLE_INITIAL
   cont> END_FOR
   RDO>
   RDO> COMMIT

   This RDO query displays field values from each record in the
   EMPLOYEES relation.

   Example 3

   Retrieve values from fields in two relations:

   RDO> START_TRANSACTION READ_ONLY
   RDO>
   RDO>  FOR E IN EMPLOYEES CROSS JH IN JOB_HISTORY
   cont>   OVER EMPLOYEE_ID
   cont>   WITH JH.JOB_END MISSING
   cont>   PRINT E.LAST_NAME, JH.JOB_CODE
   cont> END_FOR
   RDO>
   RDO> COMMIT

   This RDO statement performs a join of two relations and uses
   PRINT to display a value from each. The result is the last name
   and current job code of each employee.

   Example 4

   Retrieve the result of a statistical expression:

   RDO> START_TRANSACTION READ_ONLY
   RDO>
   RDO> PRINT COUNT OF E IN EMPLOYEES WITH
   cont> E.STATE = "MA"
   RDO>
   RDO> COMMIT

   This example retrieves the number of employees who live in
   Massachusetts.