Pointer Processing from .Net SQL call to RPG processor

["Needles,Stephen J" <SNEEDLES@xxxxxxxxxxxxxxxx>]

OK...I don't know enough about pointers to even understand what questions I need to ask.  So I beg, in advance, for forgiveness of my ignorance.

I have been tasked with finding a way to accept a 16M CLOB from .net via an SQL Stored Procedure call.  This SQL will contain a 16M CLOB containing XML.

I know that I can't define a receiver for data this big in RPG, so I suspect I will need to convert it (somehow?) to a pointer before allowing it to get to an RPG program.

So now this pointer needs to be passed into the Processor (RPG/SQL) as a parameter.  Is this possible?

Then I need to feed this monster to XML-INTO (probably need to write a %handler to pull this part off).  From there, the logic is simple.

It seems that I need a crash course in pointer handling and CLOBs in general.  

Problem is that this is new ground for this shop and I've not done this before...not even the pointer processing.

Can someone point me to the correct manuals/books to set me on the right course?

Thanks!

Steve Needles

==============================================================================
This communication, including attachments, is confidential, may be subject to legal privileges, and is intended for the sole use of the addressee. Any use, duplication, disclosure or dissemination of this communication, other than by the addressee, is prohibited. If you have received this communication in error, please notify the sender immediately and delete or destroy this communication and all copies.