count

Counts the number of fetches or parameters.

Available in:

Apps (win)	Apps (char)	Reportwriter	RPC	Standalone PL
X	X	X	X	X

Syntax

int count(field | parm)
ident     field
keyword   parm

field	(only used in Reportwriter) specifies that `count` returns the number of fetches that returned a non-NULL value for that field in the invocation of the current block.
parm	specifies that `count` returns the number of parameters used in calling the current trigger.

If field is not a database field, the result is undefined. count(parm) is always valid.

Counts the number of non-NULL salaries.

cnt_sal = count(SAL);

Count the number of parameters passed to the trigger.

parm_cnt = count(parm);