Re: XML Field in DB2 table

Yes, Henrik - that makes sense - this is new enough that I've never really taken time to figure that out.

I was looking at using the XML support in a project, but it was easier to just use XML-INTO for parsing and use CGIDEV2 to generate the XML, at least in this project.

Hey, who has the time, right, to get all the syntax correct?

Cheers
Vern

----- Original Message -----
Vern,

the reason I think they are CLOB's is that any varying field in DB2 are
defined as max length
and takes up diskspace accordingly - a CLOB field is like connecting an IFS
file - just pointers
to variable large storage. They don't take up more bytes in the DB2 table
than the pointer.


On Tue, Aug 27, 2013 at 9:13 PM, Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>wrote:

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.