Scalable Database Server, HiRDB Version 8 SQL Reference

[Contents][Index][Back][Next]

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.