×

Good News Everybody!

The new search engine is LIVE!

Please report any problems to david (at) midrange.com.




Used some of the knowledge picked up at COMMON to build my XML in SQL. Woohoo.

I'm creating the XML as a CLOB
                      Select xmlserialize(xmlelement(Name "tXML",
                           xmlconcat(headerxml, messagexml))
                      As Clob(2M) Including XMLDECLARATION) Into :XMLClob
                      From header Cross Join watermark;

Now I'm stumbling all over myself trying to manage the clob.

The program is written with a declared MAIN.  Originally the CLOB was defined within a subprocedure.  After creating it I wanted to pass it to another procedure for MQ processing.  However I could not quite figure out the correct definition for the procedure interface for the called subprocedure.  How do I define a prototype for passing the clob?

I realize when you declare a CLOB that you actually get a DS created with the length and data.  So do I pass the data structure?  Or is this the point where I need to understand pointers and pass a pointer?

For now - I broke down and defined the CLOB globally.

Also I'm wondering what the difference between XML_CLOB, CLOB and CLOB_FILE are?

We are on v7r1 and I'm using RDI 9.1.1.1

Vicki Wilson



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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

This mailing list archive is Copyright 1997-2026 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.