• Is accessed when no lock is in place
• Is accessed by a thread that isn't the lock holder

SELECT tabname, owner, tabid
FROM informix.systables
WHERE (tabid > 99) and (tabname <> 'ANSI')
ORDER BY tabname

SELECT TABLE_NAME
FROM USER_TABLES
ORDER BY TABLE_NAME

SELECT TABLE_NAME
FROM USER_TABLES
ORDER BY TABLE_NAME
WHERE table_name NOT IN ('MY_USELESS', 'FOO')

select name
from sysobjects
where type = 'U' or type = 'V'

SELECT a.name attr_name, b.type attr_type,
     b.name type_name, b.allownulls allownulls,
     c.type primary_key, a.length width,
     a.prec prec, a.scale scale
FROM syscolumns a, systypes b, syskeys c
WHERE a.id = object_id('%@') and a.id *= c.id and
     (a.colid *= c.key1 or a.colid *= c.key2
     or a.colid *= c.key3 or a.colid *= c.key4) and
     (c.type = 1 or c.type is null) and
     a.usertype = b.usertype and
     datalength(a.name) > 0
ORDER BY a.name

SELECT a.keycnt, b.name tname, c.name cname,
     d.name dtname, e.name dcname
FROM syskeys a, sysobjects b, syscolumns c,
     sysobjects d, syscolumns e
WHERE (b.type = 'U' or b.type = 'V') and
     a.depid is not null and a.depid > 0 and
     b.id = a.id and b.id = c.id  and
     ((c.colid = a.key1 and e.colid = a.depkey1) or
     (c.colid = a.key2 and e.colid = a.depkey2) or
     (c.colid = a.key3 and e.colid = a.depkey3) or
     (c.colid = a.key4 and e.colid = a.depkey4))
     and d.id = a.depid and d.id = e.id
ORDER BY b.name, d.name

SELECT name, id FROM sysobjects WHERE type = 'P'

sp_sproc_columns %@

• Attributes with NSNumber as a value class have a value type defined.
• That attributes with a custom value class have a value factory method and a adaptor value conversion method set.
• The source attributes of a relationship that propagate primary keys contain the source entity's primary key attributes; that the destination attributes contain the primary key attributes of the destination entity, and that the inverse relationship doesn't also propagate primary key.

• All the attributes in the parent entity exist in the child.
• The relationships in the parent exist in the child, and their relationship definitions match.
• The primary key definition in the parent matches the primary key definition in the child.
• The parent and child have restricting qualifiers if their columns reside in the same table.

• All relationships have at least one join defined.
• The destination attributes of to one relationships are the primary keys of the destination entities.
• The source attributes of a relationship that propagate primary keys contain the source entity's primary key attributes; that the destination attributes contain the primary key attributes of the destination entity, and that the inverse relationship doesn't also propagate primary key.