Certain table processing commands return information about their status while they execute. When such a command finishes executing, it displays the number of records processed if the SET TALK command is set to ON. If the command is executed against local views and tables, it stores this number to the _TALLY system variable.

The INSERT - SQL command changes _TALLY if a SQL SELECT command is used to specify the data to insert.

The following table lists the commands and functions that return status information and store the number of records processed in _TALLY only when executed against local tables and views.

The following example returns the number of U.S. customers from a Customer table using the SQL SELECT command and stores the to _TALLY automatically. The ? command displays the value stored in _TALLY.

SELECT * FROM customer ;
   WHERE country = 'USA' ;
   INTO CURSOR temp
? _TALLY

For more information, see ? | ?? Command.

Reference

Other Resources