<< view-Name | Interaction with the dependency system >>

cursor-Name

<< view-Name | Interaction with the dependency system >>

Derby Reference Manual

cursor-Name

A cursor-Name refers to a cursor. No SQL language command exists to assign a name
to a cursor. Instead, you use the JDBC API to assign names to cursors or to retrieve
system-generated names. For more information, see the Derby Developer's Guide. If you
assign a name to a cursor, you can refer to that name from within SQL statements.

You cannot qualify a cursor-Name.

Syntax

SQL92Identifier

Example

stmt.executeUpdate("UPDATE SAMP.STAFF SET COMM = " +
"COMM + 20 " + "WHERE CURRENT OF " + ResultSet.getCursorName());

TriggerName

A TriggerName refers to a trigger created by a user.

Syntax

[

schemaName

. ]

SQL92Identifier

Example

DROP TRIGGER TRIG1

AuthorizationIdentifier

User names within the Derby system are known as authorization identifiers. The
authorization identifier represents the name of the user, if one has been provided in the
connection request. The default schema for a user is equal to its authorization identifier.
User names can be case-sensitive within the authentication system, but they are always
case-insensitive within Derby's authorization system unless they are delimited. For more
information, see the Derby Developer's Guide.

Syntax

SQL92Identifier

Example

CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
'derby.database.fullAccessUsers', 'Amber,FRED')

RoleName

A RoleName refers to an SQL role. A role in a database is uniquely identified by its role
name.

Syntax

SQL92Identifier

In terms of SQL, a role name is also technically an

AuthorizationIdentifier

, but that term is

often used for user names in Derby for historical reasons.