My Oracle Support Banner

RDBPROD: Dynamic SQL Programming Primer (Doc ID 65261.1)

Last updated on MARCH 01, 2018

Applies to:

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

Purpose

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.

Scope

Some looking to write code using dynamic SQL.

Details

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.