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

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

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

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

Holly, I use the DB2 SQL docs from the IBM software site. Between the TSM online help (that shows you available verbs/syntax) & the DB2 docs I can generally figure out whatever I need. Please remember that TSM is not the best SQL engine & should not be overused during otherwise busy periods. S

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

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

:[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

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

-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

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

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

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 to a file */ /* Also strongly recommend running in commadelimited mode*/ select oc.node_name, oc.filespac

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 Services Micron Technology, Inc. -Original Message- From: Peppers, Holly [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 10:43 AM To: [