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



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.





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.