SQL/MX 3.2 Programming Manual for C and COBOL (H06.25+, J06.14+)

Program and Module Management
HP NonStop SQL/MX Release 3.2 Programming Manual for C and COBOL—663854-002
17-12
How Modules Are Named

Syntax for the Windows-Hosted SQL/MX COBOL Preprocessor on page 16-19
Module Name Length
Figure 17-1 shows the limits for module name length. In summary:

You are not required to choose identifiers that use the maximum length.

The maximum lengths are not additive.

The target (or table set), version, and group attributes are optional.
\
An unqualified module name is limited to maximum 128 characters, as is an externally
qualified module name (for example, GRP^MOD^TABLESET^VER). You can choose a
catalog name, schema name, or module name each between one character and 128
characters long.
For example, a three-character catalog name plus a three-character schema name
plus a 128-character module name plus the two dots (.) between the catalog, schema,
and module names constitute a 136-character, three-part module name:
CAT.SCH.externally-qualified-module-name-that-is-128-characters
For embedded SQL C/C++ programs, the limit on a fully qualified, three-part module
name is 248 characters because this name is eventually used for an OSS file. OSS file
names can have a maximum length of 248 characters. For more information, see the
Open System Services User’s Guide.
Note. To fully understand the effects of using or not using each of the module
management attributes, see Table 17-3
on page 17-13.
Figure 17-1. Module Name Length
C/C++: 248-char. max. length COBOL: 160-char max. length
/usr/tandem/sqlmx/USERMODULES/CatalogName.SchemaName.Group^ModuleName^Target^Version
128-character maximum length
128-character maximum length
31-character maximum length
128-character maximum length
31-character maximum length
31-character maximum length
1023-character maximum length
128-character maximum length
VST143.vsd