IBM Support

System naming convention expanded to permit (slash) and (dot) qualifiers

News


Abstract

System naming convention expanded to permit (slash) and (dot) qualifiers

Content

You are in: IBM i Technology Updates > Db2 for i - Technology UpdatesDb2 for i Functional Enhancements > System naming convention expanded to permit (slash) and (dot) qualifiers

Historically, system naming qualification of names required a slash (/) between the schema-name and the SQL identifier.

Now, when using system naming, both the slash (/) and dot (.) can be used for object qualification. This change makes it possible to qualify objects such as functions or sequences in a query. It also makes it easier to adapt an application to system naming, as the SQL statement text doesn’t need to be updated.

This enhancement does not affect the difference in qualifying unqualified object references that exists when using *SYS or *SQL naming. For example, an unqualified table in *SYS naming will still use the library list, while an unqualified table in *SQL naming uses the authorization ID of the statement.

The following example works when using NAMING(*SYS), but fails when using NAMING(*SQL)

Example:
SELECT a.ibmreqd, b.ibmreqd
FROM sysibm.sysdummy1 a, sysibm/sysdummy1 b
When using system naming, the SQL5016 failure will no longer be sent for object qualification.
SQL5016 Message Information
Message ID . . . . . . : SQL5016 Severity . . . . . . . : 30
Message type . . . . . : Diagnostic
Date sent . . . . . . : 08/20/12 Time sent . . . . . . : 17:02:24

Message . . . . : Qualified object name SYSDUMMY1 not valid.
Cause . . . . . : One of the following has occurred:
-- The syntax used for the qualified object name is not valid for the
naming option specified. With system naming, the qualified form of an
object name is schema-name/object-name. With SQL naming the qualified form
of an object name is authorization-name.object-name.

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB08","label":"Cognitive Systems"}}]

Document Information

Modified date:
14 January 2020

UID

ibm11167412