Re: Substitution Variables
Robertson Lee NTSE wrote:
>
> Hi,
>
> Apologies for mentioning the dreaded O word but I am an Oracle DBA and
> when I need to be prompted for a variable when running some SQL in an
> sqlplus session I use an '&' character. Is there anything similar to use
> within dbaccess to achieve the same results. I am using Online 7.23 UC4
> on HP-UX 10.01
>
> Regards
>
> Lee Robertson
>
> Lee Robertson
> Oracle DBA
> Siemens Microelectronics Ltd
> Tel 0191-2804037
Not directly in dbaccess. But you could easily write a filter in awk,
perl etc to do this while piping into dbaccess. I have a vague
recollection of seeing something like that somewhere once but I can't
remember where. Anyone else got a functioning memory?
--
Peter Lancashire
Information Systems Specialist, Bayer plc
Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK
Tel: +44-1635-562258, Fax: +44-1635-562281
Mail: Peter.Lancashire.PL1@bayer.co.uk
---
My Internet plumbing does not allow me to mail and post news together.
Sorry.
All opinions are my own and not those of Bayer plc.
---
Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/