RE: A CLOB in my RPG code?

Hi David

You'd be better off comparing it before you write it to the CLOB IMHO, so
add a parameter that allows you to save the raw XML file before you delete
it.

In the event that you solve the problem of comparing the CLOB fields as
you've asked, it's almost inevitable that when you detect a difference
you're almost certainly going to ask "what's changed" and want to compare
the two files, maybe even look at them.

Of course, you could go the whole hog and extract the CLOB field from the
two files and do it that way.

Regards
Evan Harris

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of David FOXWELL
Sent: Tuesday, 6 January 2009 11:01 p.m.
To: Midrange Systems Technical Discussion
Subject: RE: A CLOB in my RPG code?

Sorry all, I had difficulty expressing this problem so I'll try and rephrase
it.


My programme creates an XML file. It is called by a generic calling program
that figures out which program to call and thus which XML to create.


The caller writes my XML file to a CLOB field in a table MyClobFile and
deletes the original XML file.

In my test library, MyClobFile is copied to MyClobFile_Saved at the end of
the test.

If I now modifiy my program, I will want to compare the new MyClobFile with
MyClobFile_Saved.

How do I compare these two tables and thus detect the differences in the XML
that is saved in the CLOBs?



I will probably separate my programme from the caller and compare the XML
files manually. However I'd like to be able to automate that as well. Is
there a way of comparing 2 XML files line by line other than copying them to
PFs and comparing these PF's?

Thanks.