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
