IBM Tivoli Storage FlashCopy Manager for Windows, Version 4.1

Query SQL syntax

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


TDPSQLC command

>>-TDPSQLC--Query SQL--+--------------------+------------------->
                       '-/COMPATibilityinfo-'   

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

>--+--------------------------------+--------------------------->
   |            .-tdpsql.log------. |   
   '-/LOGFile=--+-+-------------+-+-'   
                  '-logfilename-'       

>--+-------------------------+---------------------------------->
   |             .-60------. |   
   '-/LOGPrune=--+-numdays-+-'   
                 '-No------'     

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

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

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

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

Feedback