Re: Redirecting select statement output from a script

Hi Matthew


I notice you have a space after the '>'.  I remember a discussion on how
the
'> redirect' gets confused with '> greater than'  and the (rather vague)
solution
was to interpret the space after the '>' as an indicator that this was a

greater than, and not a redirect... hence the illegal sql operator
message.

Try dropping the space.. maybe.


Someone who recognises this 'feature' could possibly correct me on its
actual
usage.


Regards,

David le Blanc

--              
Senior Technical Specialist             
I d e n t i t y   S o l u t i o n s     
        
Level 1, 369 Camberwell Road, Melbourne, Vic 3124       
Ph 03 9813 1388 Fax 03 9813 1688 Mobile 0417 595 550
Email david.leblanc AT identity-solutions.com DOT au    

-----Original Message-----
From: Matthew Large [mailto:Matthew.Large AT AVIVA DOT COM] 
Sent: Thursday, 2 June 2005 9:21 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Redirecting select statement output from a script

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.