Cloudscape System Tables
Page 2 of 17

SYSALIASES

Describes the method aliases, work units, user defined aggregates, and class aliases in the database.

Column Name

Type

Length

Nullability

Contents

ALIASID

CHAR

36

false

unique identifier for the alias

ALIAS

VARCHAR

128

false

alias

JAVACLASSNAME

LONGVARCHAR

255

false

the Java class name

ALIASTYPE

CHAR

1

false

`A' (user aggregate)

`C' (class alias)

`M' (method alias)

`W' (work unit)

NAMESPACE

CHAR

1

false

`C' (class alias)

`M' (method alias)

SYSTEMALIAS

BOOLEAN


false

true (system supplied or built-in alias)

false (alias created by a user)

ALIASINFO

SERIALIZE(COM.cloudscape.types.AliasInfo)


true

A java interface that encapsulates the additional information that is specific to an alias

Indexes

  • SYSALIASES_INDEX1, unique btree index on (ALIAS, NAMESPACE)
  • SYSALIASES_INDEX2, unique btree index on (ALIASID)

Useful Queries

The query for returning all of the class aliases is:

SELECT ALIASID, ALIAS, JAVACLASSNAME
FROM SYS.SYSALIASES WHERE ALIASTYPE = 'C'

The query for returning all the built-in aliases is:

SELECT ALIASID, ALIAS, JAVACLASSNAME,
    ALIASINFO.getMethodName(), ALIASINFO.getTargetClassName(),
    ALIASINFO.getTargetMethodName()
FROM SYS.SYSALIASES WHERE SYSTEMALIAS

The query for returning all the method aliases is:

SELECT ALIASID, ALIAS, JAVACLASSNAME, ALIASINFO.getMethodName()
FROM SYS.SYSALIASES WHERE ALIASTYPE = 'M'

The query for returning all the user aggregates is:

SELECT ALIASID, ALIAS, JAVACLASSNAME
FROM SYS.SYSALIASES WHERE ALIASTYPE = 'A'

The query for returning all the work units is:

SELECT ALIASID, ALIAS, JAVACLASSNAME, ALIASINFO.getMethodName(), ALIASINFO.getTargetClassName(), ALIASINFO.getTargetMethodName()
FROM SYS.SYSALIASES WHERE ALIASTYPE = 'W'