Re: Good way to identify malformed XML?

from: "Birgitta Hauser" <Hauser@xxxxxxxxxxxxxxx>
subject: RE: Good way to identify malformed XML?

You can define a CLOB variable with the Keyword SQLTYPE:

DCL-S YourCLOBVar SQLTYPE(CLOB: 16000000);

... but a CLOB Variable is restricted to 16MB (RPG's limit of character
variables).
That's why I suggested to use an SQL Global Variable, which is a permanent
Object that works similar to a data area in the QTEMP, i.e. the same SQL
Global variable can have different values in different jobs.
An SQL LOB (CLOB, BLOB, DBCLOB, XML) can be defined up to 2 GB.
An SQL Global Variable can only be accessed in a SQL Statement, i.e. you
either need a SET or VALUES ... INTO statement to populate your SQL Global
Variable.

Examples for Generating SQL Global Variables
Create Variable YourSchema/YourglobalCLOB Clob(2G) Default '';
Create Variable YourSchema/YourglobalXML Xml Default Null;

Examples for populating SQL Global Variables:
Exec SQL Set YourSchema.YourGlobalCLOB = 'ABC';
Exec SQL Set YourSchema.YourGlobalXML = xmlparse(document
httpgetCLOB('https://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml
',
'' ));

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)