Have you tried pointing your variable to a user space?


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Needles,Stephen J
Sent: Wednesday, April 20, 2011 2:52 PM
To: Midrange Systems Technical Discussion
Subject: RE: Pointer Processing from .Net SQL call to RPG processor

Thanks for your reply Alan.

I had hoped that it could have been this simple. But I haven't been
successful in finding a way to define an RPG variable as a CLOB in any
manual I've access to.

It boils down do I get this 16M CLOB into my processor program
written in RPG?


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Campin
Sent: Wednesday, April 20, 2011 4:37 PM
To: Midrange Systems Technical Discussion
Subject: Re: Pointer Processing from .Net SQL call to RPG processor

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
parameters. The SQL pre-processor converts the CLOB declaration to a
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
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

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

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


Steve Needles

This communication, including attachments, is confidential, may be
to legal privileges, and is intended for the sole use of the
addressee. Any
use, duplication, disclosure or dissemination of this communication,
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
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives

This thread ...


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

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