banner_bild_01 banner_bild_02 banner_bild_03 banner_bild_04 banner_bild_05
banner_bild_06 banner_bild_07 banner_bild_08

TSM SQL Advanced Tutorial (6)

button-home

Home SQL

arrow

Previous

Next

TSM data is scattered across a lot of tables, each holding information about a specific topic. But what if we need data from more than one table at the same time? SQL can not only get to any data from any table in a database, but also identify similar fields across tables which allow us to set data from different tables into senseful relation to one another. This principle is called "joining". We can join tables by choosing identical information ("keys") from the tables and making sure these keys match during our query. Before joining tables, we introduce an alternative way of referencing columns. So far we've only addressed columns using the principle "select column from table". SQL can also refer to a column by writing "select table.column from table". This seems a litle redundant at first glance, however as soon as we work a single query across more than one table, it starts making sense. We proceed with a trivial example that shows filespace capacity and the node's compression setting for each filespace. So we need the "compression" column from the "nodes" table, the "filespace_name" column from the "filespaces" table, the "capacity" column from the "filespaces" table and the "node_name" column which can be found in either of the two tables. This "node_name" column is also the "key" bindung our tables together, since its presumably the same information in both tables, allowing us to identify which compression setting relates to which filespace:

select nodes.node_name, filespaces.filespace_name, nodes.compression, -
filespaces.capacity from nodes, -
filespaces where nodes.node_name=filespaces.node_name

 Alle erwähnten Produkte und Bezeichnungen können eingetragene Warenzeichen der jeweiligen Hersteller sein und werden als solche betrachtet.
Bei Fragen oder Problemen kontaktieren Sie bitte info@general-storage.de

Navigation  | Über GS  |  Lösungen  |  ServiceReferenzen  |  Impressum  |  Download

© 2016 by General Storage GbR. Alle Rechte vorbehalten

arrow

Previous

Next

Kontaktieren Sie uns:

Telefon: +49 6206 157686
Telefax:  +49 6206 157687
E-Mail: info@general-storage.de

arrow
arrow
GS_Logo1_Neu
gse-logo

13th ISP Symposium 2017
26.-29. September 2017,
Cologne Marriott Hotel


IBM

SSW-2258:
An Alternative to NDMP for Network Attached Storage Backup 
with dsmISI MAGS


Kundenforum
IBM Spectrum Protect und Veeam Kundenform, 28. Juni 2017, Skyloft Frankfurt Airport


Pressemitteilung:
dsmISI for Veeam ermöglicht unbegrenzte Speicher für Backups

Hier nachlesen


General Storage Lösungen
Ready for IBM Tivoli Software

tivoli_ready