Thank you to all who have responded. It is much appreciated!
Laura
To
ADSM-L AT VM.MARIST DOT EDU
cc
From
Sent by
Steven Harris <steve AT STEVENHARRIS DOT INFO> on 05/25/2006 10:00
PM
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Subject
Re: [ADSM-L] SQL Select commands
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Luc said
>
> Hi all
>
> I'm not that good with SQL commands .... is there any documentation
> available ...
>
> any idea ... thanks
>
> Luc Beaudoin
> Administrateur Réseau / Network Administrator
> Hopital General Juif S.M.B.D.
> Tel: (514) 340-8222 ext:8254
>
Laura said
> Where do you get the syntax information for the select statement? i.e.
substr , etc. Thank you.
Andy Raibeck once put out an sql manual which was specific to the TSM
database. I've lost my copy along the way so if you still have a link Andy
that would be nice!
But, whilst the TSM database is *not* DB2, it looks as if the SQL interface
was modelled on DB2 sql. Bear in mind that you only have a select statement
and that many of the more complicated subselection constructs are not
supported, neither is UNION.
but go to the DB2 infocenter
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm
.
db2.udb.doc/core/c0008880.htm
then under Reference, SQL you will find explanations of functions and
queries that may prove useful. I most recently used this when I wanted to
find the function that returns the day-of-month protion of a timestamp
because I wanted to run something different in my housekeeping script on
the
9th of every month. The function is DAY.
Regards
Steve
Steven Harris
AIX and TSM Admin
Brisbane Australia
DISCLAIMER:
This communication, along with any documents, files or attachments, is intended
only for the use of the addressee and may contain legally privileged and
confidential information. If you are not the intended recipient, you are hereby
notified that any dissemination, distribution or copying of any information
contained in or attached to this communication is strictly prohibited. If you
have received this message in error, please notify the sender immediately and
destroy the original communication and its attachments without reading,
printing or saving in any manner. This communication does not form any
contractual obligation on behalf of the sender or, the sender's employer, or
the employer's parent company, affiliates or subsidiaries.
|