It is normal when using STRSQL, which is stabilized and was not enhanced
since release V4R5.
If you want to see the content of an XML (or and other Large Object Column,
data types CLOB, DBCLOB, BLOB) just run your SQL Statement through the IBM i
Database - Run an SQL Scripting interface.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im
Auftrag von RPGLIST
Gesendet: Tuesday, 27.8 2013 19:46
An: rpg400-l@xxxxxxxxxxxx
Betreff: XML Field in DB2 table
I took some time to play around with the xml field type today, but I'm
seeing someting a little strange.
To keep things simple, I created a simple table (two fields - primary key as
int and an xml field) and inserted a record.
It parsed it find, no troubles...
When I do a select statement, the xml field comes back with *pointer is
that normal? Or did I do something wrong?
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
midrange.com
