Query syntax

Edit online

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

Syntax

Figure 1. TDPSQLC query

1  TDPSQLC  Query
2.1  SQL
2.2.1 + , dbname *
2.1  TDP
2.1  TSM
2.2.1 + , dbname
2.2.1 *
2.1 %A

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

Figure 2. Query Optional Parameters:

1?  /BUFFers
2.1! =3 [or cfg value]
2.1 
2.1 =numbuffers?  /BUFFERSIze
2.1! =1024 [or cfg value]
2.1 
2.1 =buffersizeinkb?  /COMPATibilityinfo?  /CONFIGfile
2.1! =tdpsql.cfg
2.1 
2.1 =configfilename?  /FILEInfo=?  /FROMSQLSERVer=
2.1! =sqlserver value [or cfg. value]
2.1 
2.1 =sqlservername?  /LOGFile
2.1! =tdpsql.log [or cfg value]
2.1 
2.1 =logfilename?  /LOGPrune
2.1! =60 [or cfg value]
2.1 
2.1 =numdays
2.1 =No?  /OBJect=
2.1 + , objectname
2.1 *?  /QUERYNode
2.1! =DP
2.1 =ALWAYSON
2.1 =BOTH?  /SQLAUTHentication
2.1! =INTegrated [or cfg value]
2.1 
2.1 =SQLuserid?  /SQLPassword
2.1! =" "
2.1 
2.1 =sqlpasswordname?  /SQLSERVer
2.1! =[local computer name or cfg value]
2.1 
2.1 =sqlserver-connection?  /SQLUSer
2.1! =sa
2.1 
2.1 =sqlusername?  /TSMNODe
2.1! =[dsm.opt value]
2.1 
2.1 =tsmnodename?  /TSMOPTFile
2.1! =dsm.opt
2.1 
2.1 =dsmoptfilename?  /TSMPassword
2.1! =[dsm.opt value]
2.1 
2.1 =tsmpasswordname
A Query TSM Options

1! *
1 Full
1 Difffull
1  Log=
2.1 + , logobjectname
2.1 *
1  FIle=
2.1 + , logicalfilename
2.1 *
1  Group=
2.1 + , groupname
2.1 *
1  Set=
2.1 + , setobjectname
2.1 *
1 Types
1+ 
2.1! /ACtive
2.1 
2.1 /ALl
1  /OBJect=
2.1 + , objectname
2.1 *
3?  /FILEInfo
Note: The /QUERYNode parameter is not an optional parameter for all query commands. It is relevant only for query TSM.