z/OS ISPF Reference Summary
Previous topic | Next topic | Contents | Contact z/OS | Library | PDF


TBQUERY—obtain table information

z/OS ISPF Reference Summary
SC19-3624-00

Command invocation format

Read syntax diagramSkip visual syntax diagram
>>-ISPEXEC--TBQUERY--table-name--+----------------+------------->
                                 '-KEYS(key-name)-'   

>--+-----------------+--+---------------------+----------------->
   '-NAMES(var-name)-'  '-ROWNUM(rownum-name)-'   

>--+---------------------+--+-----------------------+----------->
   '-KEYNUM(keynum-name)-'  '-NAMENUM(namenum-name)-'   

>--+--------------------+--+--------------------+--------------->
   '-POSITION(crp-name)-'  '-SORTFLDS(srt-name)-'   

>--+--------------------+--+---------------------+-------------->
   '-SARGLIST(lst-name)-'  '-SARGCOND(cond-name)-'   

>--+-------------------+---------------------------------------><
   '-SARGDIR(dir-name)-'   

Call invocation format

Read syntax diagramSkip visual syntax diagram
>>-CALL--ISPEXEC--(buf-len,--buffer);--------------------------><

OR

Read syntax diagramSkip visual syntax diagram
>>-CALL--ISPLINK--('TBQUERYb',--table-name--,-+----------+------>
                                              '-key-name-'   

>--,-+----------+--,-+-------------+--,-+-------------+--------->
     '-var-name-'    '-rownum-name-'    '-keynum-name-'   

>--,-+--------------+--,-+----------+--,-+----------+----------->
     '-namenum-name-'    '-crp-name-'    '-srt-name-'   

>--,-+----------+--,-+-----------+--,-+----------+-);----------><
     '-lst-name-'    '-cond-name-'    '-dir-name-'      

Return codes

 0
Normal completion.
12
Table is not open.
16
Not all keys or names were returned because insufficient space was provided.
20
Severe error.

Go to the previous page Go to the next page




Copyright IBM Corporation 1990, 2014