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 ),
( XMLELEMENT ( NAME "NAVN", E.NAVN)
ORDER BY E.NAVN
FROM utv04.GKM0033 E
WHERE substr(e.adresse_3, 1, 4) in ('1404')
GROUP BY ADRESSE_3
Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.