SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements

HP NonStop SQL/MX Reference Manual—523725-004

2-215

SET NAMETYPE Statement

Considerations for SET NAMETYPE

Examples of SET NAMETYPE

The SET NAMETYPE statement sets the NAMETYPE attribute value for the current

SQL session.

The SET NAMETYPE statement sets the NAMETYPE attribute for all dynamic

statements within the control flow scope of an embedded SQL program for the current

SQL session.

SET NAMETYPE is an SQL/MX extension.

ANSI | NSK

specifies whether the system assumes logical names (ANSI) or physical Guardian

names (NSK) are used to reference SQL/MP database objects in SQL statements.

Considerations for SET NAMETYPE

Scope of SET NAMETYPE

The NAMETYPE attribute value you specify with SET NAMETYPE remains in effect

until the end of the session or until you execute another SET NAMETYPE statement.

If no SET NAMETYPE statement is in effect, NonStop SQL/MX determines the default

NAMETYPE attribute value. For more information, see Object Naming on page 10-47.

Use SET NAMETYPE to set the NAMETYPE attribute for dynamic SQL statements.

Use DECLARE NAMETYPE to set the NAMETYPE attribute for static SQL statements.

See DECLARE NAMETYPE Declaration on page 3-31. For more information, see the

SQL/MX Programming Manual for C and COBOL or the SQL/MX Programming Manual

for Java.

Examples of SET NAMETYPE

•

Set the NAMETYPE attribute value to NSK:

SET NAMETYPE NSK;

SET NAMETYPE {ANSI | NSK}

Embed