Named query table (ARSNAMEQ)

This table maintains a catalog of named queries.

Table 1. Named query table (ARSNAMEQ)
Column Name	Data Type	Description
fid	INTEGER	Folder identifier
id	INTEGER	User identifier
name	VARCHAR(60)	Name of named query
buf	CLOB(32700) (Db2®), VARCHAR(MAX) (SQL Server), CLOB (Oracle)	Named query

Table 2. Indexes for named query table (ARSNAMEQ)
Index name	Columns in index	Type of index
arsnameq_idx	fid, id, name	Unique cluster index for Db2; Unique index for Oracle and SQL Server