Re: sql query question

Now you are probably talking about within a dsmc and not a dsmadmc ('cause
it works under dsmadmc)

so to do a dsmc and capture its output do something like...

 eval nohup dsmc q sched  -pass=xxxpswd  >testit.out 2>&1

zdec23@ttcstg02/home/zdec23 > more testit.out
Tivoli Storage Manager
Command Line Backup Client Interface - Version 3, Release 7, Level 2.0
(C) Copyright IBM Corporation, 1990, 2000, All Rights Reserved.

Node Name: TTCSTG02
Session established with server MYADSMSEV: AIX-RS/6000
  Server Version 3, Release 7, Level 2.0
  Server date/time: 07/06/00   10:24:29  Last access: 07/05/00   18:15:20

    Schedule Name: UNIX-1800
      Description:
           Action: Incremental
          Options: -subdir=yes
          Objects:
         Priority: 5
   Next Execution: 7 Hours and 36 Minutes
         Duration: 2 Hours
           Period: 1 Day
      Day of Week: Any
           Expire: Never

testit.out: END

use the "eval" to force the break and the evaluation of the ">" and not
allow it to be passed to "adsm/tsm"

Dwight
> ----------
> From:         Palmadesso Jack[SMTP:Jack.Palmadesso AT SWPC.SIEMENS DOT COM]
> Reply To:     ADSM: Dist Stor Manager
> Sent:         Thursday, July 06, 2000 9:53 AM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      sql query question
>
> I'd like to do something similar.  I have a large query I'd like put into
> a
> file.  How can one redirect the output to a file?
>
> I keep getting invalid SQL token | everytime I use the pipe symbol.  Can I
> redirect inside of ADSM?
> Thanks
>
> -----Original Message-----
> From: Remeta, Mark
> Sent: Wednesday, July 05, 2000 15:58
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: sql NT query question
>
>
> Hello all, how do you do a sql query from the command prompt
> using a > in
> the where clause?
> everytime I try adsm tries redirecting the output to whatever is to the
> right of the >.
> sorry if this is a stupid question...
>
> Thanks,
>
> Mark Remeta
> Seligman Data Corporation
> 100 Park Avenue
> New York, NY 10017
>
>
>
> Confidentiality Note: The information transmitted is intended
> only for the
> person or entity to whom or which it is addressed and may contain
> confidential and/or privileged material. Any review, retransmission,
> dissemination or other use of this information by persons or
> entities other
> than the intended recipient is prohibited. If you receive this in error,
> please delete this material immediately.
>