Quering TSM db

[rahulpawar]

Dear Friends,

which best way to query Tsm db is it by sql select statements
or by simply writing q libvol, q vol , q node statement

which is the best practice??

where can i find update statements for tsm db

Please help

 

[BBB]

Use the "q" commands unless you need to customise them in which case use select statements. There are plenty of select queries documented on this site just search for them.

You cannot update the db with sql update commands.

 

[rahulpawar]

Update query


so sql select statement can used for report and customised data purpose.

and for update any query we cannot user sql update statements.

for example update vol Week1 access=readonly

Use the "q" commands unless you need to customise them in which case use select statements. There are plenty of select queries documented on this site just search for them.

You cannot update the db with sql update commands.

 

[BBB]

and for update any query we cannot user sql update statements.

for example update vol Week1 access=readonly

Yes you can do that command, but it is not an sql update command, its just a tsm admin command.

 

[rahulpawar]

Thanks for your valuable reply

Thanks for valuable reply