SQL prefix

Function

The SQL prefix indicates the beginning of an SQL.

Format

EXEC SQL

Common rules

  1. Each SQL must be enclosed between an SQL prefix and an SQL terminator.
  2. See the HiRDB Version 8 UAP Development Guide for the SQL coding rules.

Examples

Code the OPEN statement:

C language

EXEC SQL
  OPEN CR1;

COBOL language

EXEC SQL
  OPEN CR1
END-EXEC.