SYSTEM Tables and SYSCA Views › SYSCA Objects › Example

Example

In this example, columns from SYSCA.TABLE are selected. The column values in the result table represent information about tables for which the issuing user holds SELECT privilege:

SET OPTIONS COMPRESS ON;
*+ Status = 0
SELECT SCHEMA, NAME, SEGMENT, AREA, TYPE, UPDATABLE
FROM SYSCA.TABLE
WHERE SCHEMA <> 'SYSCA'
ORDER BY 1, 2, 3, 4, 5;
*+
*+ SCHEMA            NAME              SEGMENT  AREA             TYPE UPDATABLE
*+ ──────            ────              ───────  ────             ──── ─────────
*+ DEMOEMPL          EMP_WORK_INFO     SYSCAT   DDLCATX          V    Y
*+ DEMOEMPL          JOB               SQLDEMO  INFOAREA         T
*+ DEMOPROJ          EXPERTISE         PROJSEG  PROJAREA         T
*+ DEMOPROJ          PROJECT           PROJSEG  PROJAREA         T
*+ DEMOPROJ          SKILL             PROJSEG  PROJAREA         T

Note: The SYSCA.TABLE view excludes tables of type N because most columns of SYSTEM.TABLE do not contain meaningful values for non-SQL-defined tables.

SYSCA Other Objects

A number of table-like objects such as views, table procedures, functions, and procedures are created in the schema SYSCA. These objects are needed by CA IDMS for miscellaneous purposes, or provide for generally useful procedures or functions.

SYSCA Pseudo Table SINGLETON_NULL

The SYSCA.SINGLETON_NULL is a pseudo table that can be used to return the results of expressions whose parameters are constants. It is defined to have one row and no columns. This table is a pseudo table because it does not exist in the catalog. However, it can be queried through a SELECT statement. Used internally by CA IDMS, it is also useful when evaluating SQL functions and other expressions with constant parameters.

Example

select USER01.TLANG1('James    ', 'Last   ')
  from SYSCA.SINGLETON_NULL;

*+
*+ USER_FUNC
*+ ---------
*+ James Last