: 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's just std SQL syntax.
/* Show filespaces not backed up in 6 months w/space on server
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
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 IBM software site. Between the TSM online
help
.
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 utility and the manuals, but did not see
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
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.,
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 Florida
[EMAIL PROTECTED
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 Florida
[EMAIL PROTECTED]
Blue Cross
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
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 that does
-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. Ford, MCSE
LAN
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
:[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 output
13 matches
Mail list logo