SQL/MX Programming Manual for C and COBOL (G06.24+, H06.03+)

Program and Module Management
HP NonStop SQL/MX Programming Manual for C and COBOL—523627-004
17-11
How Modules Are Named
\
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.
For embedded SQL COBOL programs, the limit on a fully qualified three-part module
name is 160-characters because COBOL restricts nonumeric literals to at most 160
characters. For more information, see the HP COBOL85 for NonStop Systems Manual.
Examples
This example is invalid:
cat.sch.grp.modname.target.ver
However, this example is valid:
cat.sch."grp^modname^target^ver”
Note that the third part of the name (“grp^modname^target^ver”) is a delimited
identifier.
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