DYNPREFIX(prefix)
-dp prefix - Teradata Preprocessor2

Teradata® Preprocessor2 for Embedded SQL Programmer Guide

Product
Teradata Preprocessor2
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-19
dita:mapPath
whb1544831946911.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2446
lifecycle
previous
Product Category
Teradata Tools and Utilities

Purpose

Specifies a prefix that identifies the dynamic statement used by these manipulation statements:
  • DECLARE
  • PREPARE
  • DESCRIBE
  • EXECUTE
  • OPEN

The prefix is used in conjunction with the dynamic statement ID.

Usage Notes

The abbreviation for DYNPREFIX is DP.

The prefix must be no longer than 8 characters and must not include any of these characters:
  • Apostrophe
  • Quote
  • Space
When the same dynamic statements are prepared in different modules, DYNPREFIX:
  • Is required for C, COBOL and PL/I programs.
  • Should specify unique prefixes for each compilation unit of the executable module.