Specifying Result Tables › Selecting All Columns

Selecting All Columns

You do not have to name every column in a table if you want to retrieve each one, as the following example shows.

 Problem

 Select all columns from the table ORDERS.
 Solution

               .
               .
       (COBOL statements)
               .
               .
  1   EXEC SQL
  2       DECLARE ORDER_LIST CURSOR FOR
  3           SELECT *
  4           FROM ORDERS
  5   END-EXEC
               .
               .
       (COBOL statements)
               .
               .

Line 3

The asterisk (*) in the select-statement is used to retrieve all columns from the specified table without having to name each column.