consider this query.
--WARNING! ERRORS ENCOUNTERED DURING SQL PARSING!
WITH XMLNAMESPACES (DEFAULT 'http://www.xxxx.com/api/yyyy')
SELECT a
,b
,SOME XML 's fields from RR.TT
from TABLE
cross apply xml.nodes(' / MYROOT ') [RR]([TT])'
I need just to add this literal string before select, but I don't know how to
achieve this.
WITH XMLNAMESPACES (DEFAULT 'http://www.xxxx.com/api/yyyy')
I know just how to add literal with DSL.VAL('') but how about before query?
Tks
Denis
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.