× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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

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

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.