My Oracle Support Banner

RDBPROD: Dynamic SQL Programming Primer (Doc ID 65261.1)

Last updated on APRIL 14, 2022

Applies to:

Oracle Rdb Server on OpenVMS - Version 4.1 and later
HP OpenVMS Itanium
HP OpenVMS Alpha


This article is designed to be an introduction to Dynamic SQL using Oracle Rdb. There will be partial sample code (mostly C) shown to highlight usage. Embedded SQL as well as SQLMOD are discussed.

The PERSONNEL.RDB database will be used in any examples.

All Dynamic SQL programs use V4.1 or later SQL syntax.

The example programs used in this text have been tested using Oracle Rdb V7.1.4 on OpenVMS Alpha V7.3-2. However, Oracle cannot guarantee their effectiveness because of the possibility of error in transmitting or implementing it. The examples may be incomplete programs, and are meant to be used as templates for writing your own programs. They may require modification for use on your system.


Some looking to write code using dynamic SQL.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.