Gregory,
this suggests you need an SQL parser written in XSLT...or how would
you otherwise process and then pretty-print the SQL?
HTH,
Jan
On Nov 2, 2006, at 6:28 PM, Gregory Jungels wrote:
> I have an XML file that contains a SQL Statement inside one of the
> tags. I am using FO to â€˜documentâ€™ this query XML file. The
> problem is, the SQL statement is not formatted very neat. I would
> like to break or parse it so the output would look something like:
>
>
>
> SELECT
>
> A.COL1,
>
> A.COL2,
>
> A.COL3 as SOME_COLUMN,
>
> B.COL1 as B_COL_1,
>
> B.COL2 as B_COL_2
>
> FROM
>
> FILE1 A
>
> FILE2 B
>
> WHERE
>
> A.COL1 = B.COL1 AND
>
> A.COL2 = B.COL2
>
> ORDER BY SOME_COLUMN
>
>
>
>
>
>