Re: Select Stmts. in TSM - Outer join is not needed

2002-04-07 Thread Zlatko Krastev
ev IT Consultant Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Sent by:"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: Subject:Re: Select Stmts. in TSM Here is a script that does a join; it'

Re: Select Stmts. in TSM: Manuals

2002-03-11 Thread Michael Bartl
irement to Tivoli to provide a SQL Statements > Manual solution. > > -Original Message- > From: ARhoads [mailto:[EMAIL PROTECTED]] > Sent: Sunday, March 03, 2002 4:14 PM > To: [EMAIL PROTECTED] > Subject: Re: Select Stmts. in TSM > > Holly, > > I use the DB2

Re: Select Stmts. in TSM: Manuals

2002-03-11 Thread Seay, Paul
We are going to submit a requirement to Tivoli to provide a SQL Statements Manual solution. -Original Message- From: ARhoads [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 03, 2002 4:14 PM To: [EMAIL PROTECTED] Subject: Re: Select Stmts. in TSM Holly, I use the DB2 SQL docs from the

Re: Select Stmts. in TSM

2002-03-03 Thread ARhoads
periods. Steffan - Original Message - From: "Peppers, Holly" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, February 22, 2002 9:42 AM Subject: Select Stmts. in TSM > Has anybody tried to do a join in the TSM tables? I went looking thru the > help util

Re: Select Stmts. in TSM: What is an OUTER JOIN

2002-02-25 Thread Mark Bertrand
Is anyone else getting multiple (about one an hour) of this message from Paul? -Original Message- From: Seay, Paul [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 2:10 PM To: [EMAIL PROTECTED] Subject: Re: Select Stmts. in TSM: What is an OUTER JOIN An OUTER join really

Re: Select Stmts. in TSM: What is an OUTER JOIN

2002-02-22 Thread Seay, Paul
:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 1:02 PM To: [EMAIL PROTECTED] Subject: Re: Select Stmts. in TSM Here is a script that does a join; it's just std SQL syntax. /* Show filespaces not backed up in 6 months w/space on server */ /* This query runs a long time; suggest writing outp

Re: Select Stmts. in TSM

2002-02-22 Thread Brown, Bud
To: [EMAIL PROTECTED] Subject: Re: Select Stmts. in TSM Yes, it is very possible. These are most of the supported verbs from the help. There are predicates that are not listed here. If you do a HELP SELECT you get this: The SELECT command supports the following expressions, clauses

Re: Select Stmts. in TSM

2002-02-22 Thread Seay, Paul
-Original Message- From: taford [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 12:58 PM To: [EMAIL PROTECTED] Subject: Re: Select Stmts. in TSM I don't believe it's possible. I've researched this too. If anyone else has found otherwise, please let me know. Timothy A.

Re: Select Stmts. in TSM

2002-02-22 Thread Magura, Curtis
ou're looking to do some housekeeping. Curt Magura Lockheed Martin EIS Gaithersburg, Md. 301-240-6305 -Original Message- From: Prather, Wanda [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 1:02 PM To: [EMAIL PROTECTED] Subject: Re: Select Stmts. in TSM Here is a script

Re: Select Stmts. in TSM

2002-02-22 Thread PINNI, BALANAND (SBCSI)
For Joins go to oracle.com and do search on join u get tons of info using select statements. -Original Message- From: Peppers, Holly [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 11:43 AM To: [EMAIL PROTECTED] Subject: Select Stmts. in TSM Has anybody tried to do a join in

Re: Select Stmts. in TSM

2002-02-22 Thread Prather, Wanda
] Sent: Friday, February 22, 2002 12:43 PM To: [EMAIL PROTECTED] Subject: Select Stmts. in TSM Has anybody tried to do a join in the TSM tables? I went looking thru the help utility and the manuals, but did not see the syntax of how to do this. Let me know please. Thanks. Holly L. Peppers

Re: Select Stmts. in TSM

2002-02-22 Thread taford
002 10:43 AM To: [EMAIL PROTECTED] Subject: Select Stmts. in TSM Has anybody tried to do a join in the TSM tables? I went looking thru the help utility and the manuals, but did not see the syntax of how to do this. Let me know please. Thanks. Holly L. Peppers Blue Cross & Blue Shield of Flori

Select Stmts. in TSM

2002-02-22 Thread Peppers, Holly
Has anybody tried to do a join in the TSM tables? I went looking thru the help utility and the manuals, but did not see the syntax of how to do this. Let me know please. Thanks. Holly L. Peppers Blue Cross & Blue Shield of Florida [EMAIL PROTECTED] Blue Cross Blue Shield of Florida, Inc., an