BASICHELP.HLB  —  RECORD
  The RECORD statement lets you name and define data structures in a BASIC
  program  and  provides the BASIC interface to the Oracle CDD/Repository.
  You can use the defined RECORD name anywhere a BASIC data  type  keyword
  is valid.

  Example

  RECORD Emp_wage_class
         GROUP Emp_name
               STRING First  = 15
               STRING Middle = 1
               STRING Last   = 14
         END GROUP Emp_name
         VARIANT
               CASE
                  GROUP Hourly
                        DECIMAL(4,3) Hourly_wage
                        SINGLE Regular_pay_ytd
                        SINGLE Overtime_pay_ytd
                  END GROUP Hourly
               CASE
                  GROUP Salaried
                        DECIMAL(7,2) Yearly_salary
                        SINGLE Pay_ytd
                  END GROUP Salaried
         END VARIANT
  END RECORD Emp_wage_class

  Once you specify a record structure, you  declare  a  variable  of  that
  record  type  by  using  the  RECORD  name  as a data type keyword.  For
  instance, using the data structure defined above:

      DECLARE Emp_wage_class Emp_variable

  To reference the fields of the record, specify the record variable  name
  and  the  name of the field being accessed separated by two colons.  You
  can also specify any intermediate GROUP names.  However, they  are  only
  necessary  if  more  than  one field of the record has the same name and
  excluding the GROUP names  would  make  the  reference  ambiguous.   For
  example,  the  following assignment statements reference the same record
  field:

      Emp_variable::pay_ytd = 5000
      Emp_variable::Salaried::pay_ytd = 5000
Additional Information: explode extract
Syntax
Close Help