Re: _Ropen on a file containing datalink fields

Sorry Bruce I completely understand, I was just curious about another process to access SQL objects.

Duane Christen

--


Duane Christen
Senior Software Engineer
(319) 790-7162
Duane.Christen@xxxxxxxxxx

Visit PAETEC.COM

-----Original Message-----
From: c400-l-bounces+duane.christen=paetec.com@xxxxxxxxxxxx [mailto:c400-l-bounces+duane.christen=paetec.com@xxxxxxxxxxxx] On Behalf Of Bruce Vining
Sent: Monday, November 08, 2010 6:07 PM
To: C programming iSeries / AS400
Subject: Re: [C400-L] _Ropen on a file containing datalink fields

I requested an off-line exchange as I wanted to provide contact information
to Pete and was reluctant to post the name of a third person (without their
knowledge).

Bruce

On Mon, Nov 8, 2010 at 8:14 AM, Christen, Duane
<Duane.Christen@xxxxxxxxxx>wrote:

Bruce;

Just out of curiosity, why off line? If it is something proprietary to you
or IBM, I understand that, if not???

I use embedded SQL to access BLOBs, UDTs, and datalinks, in RPG, but it
would be interesting, to me anyway, to know another solution.

Duane Christen


--


Duane Christen
Senior Software Engineer
(319) 790-7162
Duane.Christen@xxxxxxxxxx

Visit PAETEC.COM <http://paetec.com/>


-----Original Message-----
From: c400-l-bounces+duane.christen=paetec.com@xxxxxxxxxxxx [mailto:
c400-l-bounces+duane.christen <c400-l-bounces%2Bduane.christen>=paetec.com
@midrange.com] On Behalf Of Bruce Vining
Sent: Saturday, November 06, 2010 10:24 AM
To: C programming iSeries / AS400
Subject: Re: [C400-L] _Ropen on a file containing datalink fields

If you need to use _Ropen to open a file containing BLOBs, UDTs, and (yes)
datalinks then please contact me offline at bvining@xxxxxxxxxxxxxxx

Your current approach of simply using undocumented options also means
you're working in an unsupported environment from an IBM point of view.
Assuming that you want your code to be supported I can help you along that
path. Note that, as I'm sure you've found, opening is not the same as using
:)

Bruce Vining
http://www.brucevining.com/

On Fri, Nov 5, 2010 at 11:27 AM, Peter Clifford <
peter.clifford@xxxxxxxxxxxxxxxxxxxxx> wrote:

I have a need to carry out an _Ropen on a file that contains datalink
fields and have not so far been able to find a way of doing this.

I recently managed to get _Ropen to allow me to open files containing
BLOBs and SQL UDTs by means of the (apparently undocumented?) open
options "lobptrs=Y, sqludt=Y", which I stumbled across in Google, but
so far I've not found anything equivalent that allows the use of
datalinks. I guess at "datalink=Y" and "dlink=Y" but no joy.

Anyone know the answer?

Thanks

Pete

--
This is the C programming iSeries / AS400 (C400-L) mailing list To
post a message email: C400-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/c400-l
or email: C400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/c400-l.

--
Regards,
Bruce
www.brucevining.com
www.powercl.com
--
This is the C programming iSeries / AS400 (C400-L) mailing list To post a
message email: C400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change
list options,
visit: http://lists.midrange.com/mailman/listinfo/c400-l
or email: C400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/c400-l.

--
This is the C programming iSeries / AS400 (C400-L) mailing list
To post a message email: C400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/c400-l
or email: C400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/c400-l.