gistfile1.txt

ij> describe app.markup;
COLUMN_NAME         |TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL&
------------------------------------------------------------------------------
ID                  |INTEGER  |0   |10  |10    |GENERATED&|NULL      |NO
PROCESS_ID          |INTEGER  |0   |10  |10    |NULL      |NULL      |NO
SECTION_ID          |INTEGER  |0   |10  |10    |NULL      |NULL      |NO
RED                 |SMALLINT |0   |10  |5     |NULL      |NULL      |NO
GREEN               |SMALLINT |0   |10  |5     |NULL      |NULL      |NO
BLUE                |SMALLINT |0   |10  |5     |NULL      |NULL      |NO
ALPHA               |SMALLINT |0   |10  |5     |NULL      |NULL      |YES
LOCATION            |BLOB     |NULL|NULL|21474&|NULL      |NULL      |NO

8 rows selected
ij> select count(*) from app.markup with ur;