Re: ACE 4.1
>=20
> Is there a way to get ACE print out in a comma delimited form =
automatically,
> without having to go 'print column """,filed_a, "",", filed_b, ""," =
etc.... ?
> thanks.
>=20
>=20
Hi,
I'm a little confused about all the double quotes (") in the print
statement, but I am assuming you want something like:
column1,column2,column3,
The following SQL statement will give this output:
unload to "filename" delimiter ","=20
select column1, column2, column3 from tablename;
(BTW if you want an ACE report to print a double quote, use print ascii =
34)
HTH
Richard.
----------------------------------------------------------------- =20
| _ =AF\\ | Richard Thomas |
| \\ 0_ | r.thomas@csl.gov.uk |
| \\ / | |
| oo/ | "20 Regal and a four-pack, |
| / \\ | I guess I'm set for the night" |
| \\_/ | - "TV Tan" The Wildhearts |
-----------------------------------------------------------------