× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.





As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.