ADSM-L

Redirecting select statement output from a script

2005-06-02 07:35:02
Subject: Redirecting select statement output from a script
From: Matthew Large <Matthew.Large AT AVIVA DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 2 Jun 2005 12:20:42 +0100
Hi chaps/chappesses,

I've had a look in the archives, and there doesn't seem to be an immediate
solution to this one, so please help!
I'm trying to redirect the output of a script containing select statements
to a file in the file system. I can see that the redirect works from the
command line but from within scripts I just get errors.

tsm: TSML003A>run large_monitor
ANR2907E Unexpected SQL operator token - '>'.

                                                           |
         ..................................................V............
         from occupancy where stgpool_name='APPS_DISKPOOL' > stgdisk.txt

ANR2907E Unexpected SQL operator token - '>'.

I've also tried with double right-angled bracket, without success.
The Quickfacts state there is no escape character to render it
'unspecial', but that was written a while ago, perhaps there is now a way?


Thanks
Matthew




Aviva plc
Registered Office: St. Helen's, 1 Undershaft, London EC3P 3DQ
Registered in England Number 02468686
www.aviva.com

This message and any attachments are confidential.
If you are not the intended recipient, please telephone
or e-mail the sender and delete this message and any
attachment from your system. Also, if you are not the
intended recipient you must not copy this message or
attachment or disclose the contents to any other person.