Re: XML Field in DB2 table

Thanks for the info Vern, I will definitely take a look at it. As a side
note, I was looking at some of Scott's xml parser docs and using DS. One
immediate problem I see is some of our clients get very verbose in their
tags, I have one document right now that is the following:

<PrimaryInterchangeResourceDocumentHeader>

There is no way I'm going to fit that in a DS :)

Dutch

What do you mean by "interactively"? DSPPFM? RUNQRY ()? I don't even think
you'll see anything else in STRSQL but haven't tried in a while, if ever.

If, as Henrik says, they are CLOBs, you will not see anything else in
these interfaces.

There are SQL functions that you need to use - a search for XML in these
groups can lead you to some white papers and examples of using the new DB2
for i support for XML.

One of those papers is "Replacing DB2 XML Extender with Integrated DB2 for
i XML capabilities", written by Nick Lawrence, Kent Milligan, and Yi Yuan.

Nick also has a blog, "i Can Use XML in a Relational World", and he has
links there to other resources, including the new "SQL XML Reference" in
InfoCenter.

HTH
Vern

----- Original Message -----
Ok, thanks I was digging and digging :) I know I can read them in a
program but interactively it kept coming up *pointer

*POINTER fields are CLOB fields


On Tue, Aug 27, 2013 at 7:45 PM, RPGLIST <rpglist@xxxxxxxxxxx> wrote:

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.

--
Regards,
Henrik Rützou

http://powerEXT.com <http://powerext.com/>
--
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.

--
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.

--
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.

--
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.