Re: SQL Select manuals
2003-04-25 10:45:50
Christian,
I have been down this road. There is no publication with what you are looking
for. As mentioned previously, the HELP option and Admin guide is the best your
going to get. You will have to look at each table and the columns associated
with the tables. Then create your own SQL statements. I took me a while, but
this is the path I took. And actually the research doing this has made my
administration faster and more detailed.
Good Luck,
Danny
Danny Groulx
Project Manager
SALEM GROUP | WE PUT DATA IN ITS PLACE
465 Corporate Square Drive
Winston-Salem, NC 27105
P 336 744 5999
F 336 661 3400
M 919 602 3407 (preferred #)
danny.groulx AT salemgroup DOT com <outbind://8/danny.groulx AT salemgroup DOT
com>
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Christian Svensson
Sent: Friday, April 25, 2003 10:20 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: SQL Select manuals
Thanks John!
But I need to go realy, realy deep in the SQL92/SQL93 select commands and
understand exactly how everything work.
I want to be a expert on all select statement.
What I searching for is a documentation who explain each parametar what is
does and what you can do with it way you use it.
And the link I got from Richard is good document. But that not enough for
me.
It´s should be perfect if there is a RedBook for just only TSM Select
statement. Who explain everything.
There is maybe a idea for everyone who write alot of books. A Select
statement bible. :-)
Best Regard / Med vänlig hälsning
Christian Svensson
…………………………………………………………………………....
Cristie Nordic AB
Box 2 Phone : +46-(0)8-718 43 30
SE-131 06 Nacka Mobil : +46-(0)70-32 15 77
Sweden eMail : Christian.svensson AT cristie DOT se
Visit : Gamla Värmdövägen 4, Plan 2
web : www.cristie.com
…………………………………………………………………………....
"Talafous, John
G." To: ADSM-L AT VM.MARIST
DOT EDU
<Talafous@TIMKEN. cc:
COM> Subject: Re: SQL Select manuals
Sent by: "ADSM:
Dist Stor
Manager" <ADSM-
L AT VM.MARIST DOT EDU>
2003-04-25 15:39
Please respond to
"ADSM: Dist Stor
Manager"
Richard Sims' reply was a very good one. If you need more information, the
only other thing I can think of is to start an admin command line session
and trap the output of the HELP SELECT command. This will give you the
syntax of TSM's SQL SELECT statement.
Additionally, you can get documentation about the TSM SQL tables with these
commands:
Select * from tables
Select * from columns
Select * from enumtypes
Piece all these together and you have the bulk of the documentation for the
TSM SQL environment.
Happy studying, and enjoy the sunshine!!!
John G. Talafous IS Technical Principal
The Timken Company Global Software Support
P.O. Box 6927 Data Management
1835 Dueber Ave. S.W. Phone: (330)-471-3390
Canton, Ohio USA 44706-0927 Fax : (330)-471-4034
talafous AT timken DOT com http://www.timken.com
**********************************************************************
This message and any attachments are intended for the
individual or entity named above. If you are not the intended
recipient, please do not forward, copy, print, use or disclose this
communication to others; also please notify the sender by
replying to this message, and then delete it from your system.
The Timken Company
**********************************************************************
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- SQL Select manuals, Christian Svensson
- Re: SQL Select manuals, Richard Sims
- Re: SQL Select manuals, Christian Svensson
- Re: SQL Select manuals, Talafous, John G.
- Re: SQL Select manuals, Christian Svensson
- Re: SQL Select manuals,
Danny Groulx <=
- Re: SQL Select manuals, Baines, Paul
- Re: SQL Select manuals, Prather, Wanda
- Re: SQL Select manuals, Peter Ford
|
|
|