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

Steve,

Have you tried pointing your variable to a user space?

Gary

-----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 to...how do I get this 16M CLOB into my processor program
written in RPG?

steve

-----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
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.