Re: Variable for Filename ISQL

In article 13156@duquesne.ie, asmall2@duquesne.ie (Alastair J. Small) writes: >Hi there, > >Hopefully someone can give me some help on this. I'm using ACE ReportWriter >to generate some ASCII files for importing into another system. I've set it >up to prompt for some variables depending on what is needed, and would like >also to either prompt for the output filename, or combine the variables >obtained to a string representing what the output file contains. > >I've tried using REPORT TO $variable and > REPORT TO variable > >and even have variable containing the quotes. Is there an easy way to do this, >and if so please let me know, Thanks for any help, > >p.s. using Informix Standard Engine 5.00.04.05 > Informix ISQL 4.10.05.02 > >Alastair J. Small Tel: +353-1-676-0666 >duQuesne Limited Fax: +353-1-676-8417 >4 Merrion Square Email: asmall2@duquesne.ie >Dublin, Ireland I don't think it will work as you have described, but you can use an environment variable if on a UNIX platform: REPORT TO PIPE "cat > $HOME/file" or REPORT TO PIPE "cat > $FILENAME" Good luck, John. ------------------------------------------------------------------------------- . . | ... ... | John M. Shoemaker internet: shoe@forte.sps.mot.com ..... ..... | Software Engineer voice: (602) 244-6074 fax: 5898 .. ... .. | Business Integration Group pager: (602) 219-1679 . . . | Semiconductor Products Sector | 5005 E McDowell Road Motorola-SPS | Phoenix, AZ 85008 ------------------------------------------------------------------------------- EXEC SQL include "disclaimer.h" -------------------------------------------------------------------------------