Topic
  • No replies
trymes
trymes
1 Post

Pinned topic Got hex back from SQL

‏2010-07-13T11:26:26Z |
Hi
I am running this SQL on DataStudio 2.2. It is acessing data on OS/Z. When I got the result it is in HEX. Why ?

(SELECT XMLELEMENT ( NAME "STEDER",
XMLELEMENT ( NAME "POSTSTED", E.ADRESSE_3 ),
XMLAGG
( XMLELEMENT ( NAME "NAVN", E.NAVN)
ORDER BY E.NAVN
)
)
AS "STEDER"
FROM utv04.GKM0033 E
WHERE substr(e.adresse_3, 1, 4) in ('1404')
GROUP BY ADRESSE_3