Query syntax

Use the query command syntax diagrams as a reference to view available options and truncation requirements.

Syntax

Read syntax diagramSkip visual syntax diagram
TDPSQLC SQL query

>>-TDPSQLC--Query--+-SQL--+---------------+-----+--------------><
                   |      | .-,---------. |     |   
                   |      | V           | |     |   
                   |      '---dbname--*-+-'     |   
                   +-TDP------------------------+   
                   '-TSM--+------------+--| A |-'   
                          | .-,------. |            
                          | V        | |            
                          +---dbname-+-+            
                          '-*----------'            

The syntax diagram of the Tivoli® Storage Manager options corresponding to the letter A is shown following the Optional Parameters below.

Read syntax diagramSkip visual syntax diagram
Query Optional Parameters:

>>-+---------------------------------+-------------------------->
   |           .-=3 [or cfg value]-. |   
   '-/BUFFers--+-------------------+-'   
               '-=numbuffers-------'     

>--+---------------------------------------+-------------------->
   |              .-=1024 [or cfg value]-. |   
   '-/BUFFERSIze--+----------------------+-'   
                  '-=buffersizeinkb------'     

>--+--------------------+--------------------------------------->
   '-/COMPATibilityinfo-'   

>--+----------------------------------+--+------------+--------->
   |              .-=tdpsql.cfg-----. |  '-/FILEInfo=-'   
   '-/CONFIGfile--+-----------------+-'                   
                  '-=configfilename-'                     

>--+-------------------------------------------------------+---->
   |                  .-=sqlserver value [or cfg. value]-. |   
   '-/FROMSQLSERVer=--+----------------------------------+-'   
                      '-=sqlservername-------------------'     

>--+------------------------------------------+----------------->
   |           .-=tdpsql.log [or cfg value]-. |   
   '-/LOGFile--+----------------------------+-'   
               '-=logfilename---------------'     

>--+-----------------------------------+------------------------>
   |            .-=60 [or cfg value]-. |   
   '-/LOGPrune--+--------------------+-'   
                +-=numdays-----------+     
                '-=No----------------'     

>--+------------------------------+----------------------------->
   |             .-,----------.   |   
   |             V            |   |   
   '-/OBJect=--+---objectname-+-+-'   
               '-*--------------'     

>--+---------------------------+-------------------------------->
   |             .-=DP-------. |   
   '-/QUERYNode--+-----------+-'   
                 +-=ALWAYSON-+     
                 '-=BOTH-----'     

>--+----------------------------------------------------+------->
   |                     .-=INTegrated [or cfg value]-. |   
   '-/SQLAUTHentication--+----------------------------+-'   
                         '-=SQLuserid-----------------'     

>--+------------------------------------+----------------------->
   |               .-=" "-------------. |   
   '-/SQLPassword--+------------------+-'   
                   '-=sqlpasswordname-'     

>--+-----------------------------------------------------+------>
   |             .-=[local computer name or cfg value]-. |   
   '-/SQLSERVer--+-------------------------------------+-'   
                 '-=sqlprotocol:sqlservername----------'     

>--+----------------------------+------------------------------->
   |           .-=sa----------. |   
   '-/SQLUSer--+--------------+-'   
               '-=sqlusername-'     

>--+--------------------------------+--------------------------->
   |           .-=[dsm.opt value]-. |   
   '-/TSMNODe--+------------------+-'   
               '-=tsmnodename-----'     

>--+----------------------------------+------------------------->
   |              .-=dsm.opt--------. |   
   '-/TSMOPTFile--+-----------------+-'   
                  '-=dsmoptfilename-'     

>--+------------------------------------+----------------------><
   |               .-=[dsm.opt value]-. |   
   '-/TSMPassword--+------------------+-'   
                   '-=tsmpasswordname-'     


Read syntax diagramSkip visual syntax diagram
A  Query TSM Options

   .-*------------------------------.   
|--+--------------------------------+--------------------------->
   +-Full---------------------------+   
   +-Difffull-----------------------+   
   |         .-,-------------.      |   
   |         V               |      |   
   +-Log=--+---logobjectname-+-+----+   
   |       '-*-----------------'    |   
   |          .-,---------------.   |   
   |          V                 |   |   
   +-FIle=--+---logicalfilename-+-+-+   
   |        '-*-------------------' |   
   |           .-,---------.        |   
   |           V           |        |   
   +-Group=--+---groupname-+-+------+   
   |         '-*-------------'      |   
   |         .-,-------------.      |   
   |         V               |      |   
   +-Set=--+---setobjectname-+-+----+   
   |       '-*-----------------'    |   
   '-Types--------------------------'   

   .----------------------------------.                  
   V                                  |                  
>----+------------------------------+-+--+-----------+----------|
     | .-/ACtive-.                  |    '-/FILEInfo-'   
     +-+---------+------------------+                    
     | '-/ALl----'                  |                    
     |             .-,----------.   |                    
     |             V            |   |                    
     '-/OBJect=--+---objectname-+-+-'                    
                 '-*--------------'