The NoOfRows function returns the number of rows (records) in a previously loaded table. If the function is used within a LOAD statement, it must not reference the table currently being loaded.
Syntax:
NoOfRows(table_name)
Arguments:
| Argument | Description |
|---|---|
| table_name | The name of the table. |
Example:
LET a = NoOfRows('tab1');