Re: Pointer Processing from .Net SQL call to RPG processor

[Alan Campin <alan0307d@xxxxxxxxx>]

Not sure you even need to worry about this. You declare the parameter as
CLOB in the SQL Procedure declaration and then declare it as a CLOB on the
parameters. The SQL pre-processor converts the CLOB declaration to a data
structure declaration which you should be able to process it.

On Wed, Apr 20, 2011 at 3:26 PM, Needles,Stephen J <
SNEEDLES@xxxxxxxxxxxxxxxx> wrote:

> 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.
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.