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

What release level are you at? You can process directly if you have V6R1.
You might also check the archives. If you are at a previous release you
would probably have to process via pointers. Also do a CLOB search on
google. Here is one

http://as400blog.blogspot.com/2010/02/updating-as400-db2-clob-with-64k-rpg.html

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

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.

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

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