SQL Report & Delimited output 
Author Message
 SQL Report & Delimited output

Is is possible to program a report in Informix SQL 4.0
that will send the output to an ASCII comma delimited file.

Reason: I need to develop a production application that will
ask the user for example

        Enter Starting Part#:
        Enter Ending Part#:

Based upon the input from the user the program/report queries
the database finds the matched records and saves them out to
a ascii file for further use (used in FrameMaker to produce
a price sheet for ranges of parts)

If this can be done better in an Informix SQL program I am
not opposed to that. I only have Informix SQL/SE and would
like to make it as user friendly as possible.

Your help is greatly appreciated.

Shane Trammel



Thu, 13 Oct 1994 04:08:44 GMT
 SQL Report & Delimited output

Quoting D Trammel...
Quote:

> Is is possible to program a report in Informix SQL 4.0
> that will send the output to an ASCII comma delimited file.

Using ACE, it's easier than you realize... remember to use CLIPPED on your
variables so you don't have any additional white space.  I really hope that
none of your data has commas in it.

DAS
--

                                                               is db4glgen-3.5



Thu, 13 Oct 1994 09:38:06 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Delimited reports in dBase SQL

2. SELECT output in comma delimited form

3. isql - tab delimited output

4. space delimited in the output file

5. Outputting to a PIPE delimited file

6. Tab delimited output results?

7. Output Comma-delimited with quotes

8. ISQL tab delimited output

9. Creating delimited output in a file

10. Delimited Output

11. ISQL - tab delimited Output????

12. Need to output query results to a delimited text file


 
Powered by phpBB® Forum Software