[DERBY-6121] Regularize how we refer to object names in the Reference Manual

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.10.1.1
• Fix Version/s: 10.10.2.0, 10.11.1.1
• Component/s: Documentation
• Urgency: Normal
• Assignee: Camilla Haase
• Reporter: Richard N. Hillegas
• Created: 21/Mar/13 18:22
• Updated: 16/Apr/14 02:41
• Resolved: 03/Oct/13 19:44

Description

This issue came up during the buddy testing of user-defined aggregates. Here's what Dag discovered:

identifiers (seen when looking at GRANT USAGE of aggregates): "table-Name" occurences are linked to a section explainig them (rreftablename.html), but UDA names are defined in-lined as

GRANT USAGE ON DERBY AGGREGATE [ schemaName. ] SQL92Identifier TO grantees

In a third variant,

GRANT EXECUTE ON

{ FUNCTION | PROCEDURE }

routine-designator TO grantees

routine-designator is defined locally as

routine-designator

{ function-name | procedure-name }

without links to what "function-name" or "procedure-name" might look like. It would be good to harmonize the latter two forms to a central definition as for "table-Name".

Finally, I noted that the definition page for SchemaName doesn't link to the SQL92Identifier page...

Issue Links

• is related to: DERBY-6353 Update syntax description in Getting Started, use in Reference Manual too
• relates to: DERBY-6345 Correct Getting Started syntax topic and include it in Reference Manual