TBSTATS—retrieve table statistics

Command invocation format


>>-ISPEXEC--TBSTATS--table-name--+--------------------------+--->
                                 '-CDATE(date-created-name)-'   

>--+--------------------------+--+--------------------------+--->
   '-CTIME(time-created-name)-'  '-UDATE(date-updated-name)-'   

>--+--------------------------+--+-----------------+------------>
   '-UTIME(time-updated-name)-'  '-USER(user-name)-'   

>--+----------------------------+--+----------------------+----->
   '-ROWCREAT(row-created-name)-'  '-ROWCURR(rownum-name)-'   

>--+--------------------------+--------------------------------->
   '-ROWUPD(row-updated-name)-'   

>--+------------------------------+----------------------------->
   '-TABLEUPD(table-updated-name)-'   

>--+-----------------------+--+---------------------------+----->
   '-SERVICE(service-name)-'  '-RETCODE(return-code-name)-'   

>--+-----------------------+--+-----------------------+--------->
   '-STATUS1(status1-name)-'  '-STATUS2(status2-name)-'   

>--+-----------------------+--+------------------+-------------->
   '-STATUS3(status3-name)-'  '-LIBRARY(library)-'   

>--+-------------------------------------+---------------------->
   '-VIRTSIZE(virtual-storage-size-name)-'   

>--+------------------------------------+----------------------->
   '-CDATE4D(date-created-name-4-digit)-'   

>--+------------------------------------+----------------------><
   '-UDATE4D(date-updated-name-4-digit)-'

Call invocation format


>>-CALL--ISPEXEC--(buf-len,--buffer);--------------------------><


>>-CALL--ISPLINK--('TBSTATSb',--table-name---------------------->

>--,-+-------------------+--,-+-------------------+------------->
     '-date-created-name-'    '-time-created-name-'   

>--,-+-------------------+--,-+-------------------+------------->
     '-date-updated-name-'    '-time-updated-name-'   

>--,-+-----------+--,-+------------------+--,-+-------------+--->
     '-user-name-'    '-row-created-name-'    '-rownum-name-'   

>--,-+------------------+--,-+--------------------+------------->
     '-row-updated-name-'    '-table-updated-name-'   

>--,-+--------------+--,-+------------------+------------------->
     '-service-name-'    '-return-code-name-'   

>--,-+--------------+--,-+--------------+--,-+--------------+--->
     '-status1-name-'    '-status2-name-'    '-status3-name-'   

>--,-+---------+--,-+---------------------------+--------------->
     '-library-'    '-virtual-storage-size-name-'   

>--,-+---------------------------+------------------------------>
     '-date-created-name-4-digit-'   

>--,-+---------------------------+-);--------------------------><
     '-date-updated-name-4-digit-'

Return codes

0: Normal completion (returned even if the table does not exist).
16: Variable value has been truncated.
20: Severe error.