Re: Good way to identify malformed XML?

[Peter Dow <petercdow@xxxxxxxxx>]

I'm not sure when it was introduced, but at least on 7.4 there's a 
keyword on the D-spec, e.g.

DCL-S MYBLOB SQLTYPE(BLOB:500);

or

D MYBLOB S SQLTYPE(BLOB:500)

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx>
pdow@xxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxx> /

On 9/15/2021 11:58 AM, Justin Taylor wrote:
> How do you define those in RPG?  When I try to use a large char(), the SQL
> precompiler gives me:
> SQL0312: Position 22 Variable RDBUF not defined or not usable. Reason: No
> declaration for the variable exists, the declaration is not within the
> current scope, or the variable does not have an equivalent SQL data type.
>
> Thanks
>
> date: Wed, 15 Sep 2021 05:17:45 +0200
> > from: "Birgitta Hauser" <Hauser@xxxxxxxxxxxxxxx>
> > subject: RE: Good way to identify malformed XML?
> >
> > You can move big amounts of data (up to 2 GB) it into SQL Global Variables.
> > When trying to move the data into a SQL Global Variable with Data Type XML,
> > you can directly use the XMLPARSE.
> > Alternatively you can try to insert the XML document into a (temporary)
> > table with an XML column. When inserting it is not even necessary to
> > execute
> > the XMLPARSE. The insert will fail for an non-wellformed XML document.
> >
> > 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!"
> > ?Train people well enough so they can leave, treat them well enough so they
> > don't want to.? (Richard Branson)