 |
 |
Archives of the TeradataForum
Message Posted: Fri, 09 Jun 2006 @ 14:17:23 GMT
| Subj: | | Re: Can we get Bteq output in HTML format? |
| |
| From: | | John Adams |
| | I want to know Can we get Bteq output in HTML format? | |
I don't believe there's an option to get HTML out directly, but you can do it with only a little hackery by using SET SEPARATOR to put
</td><td> between columns. Then SELECT literals for <tr><td> and </td></tr> at the beginning and ending of
each record, and a literal before and after the query to open and close the HTML. That's for one table via one query--to get more than one table,
put literals between the queries to close and open the tables. You can also get XML output in this manner.
| |
