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



ArdGate is a Bridge from embedded SQL (RPG/COBOL, interactive SQL, QMQRY, etc.) to JDBC. There are install doc and examples at the sourceforge link already posted. There are some limitations, one of these: BLOB/CLOB is not supported.
There are two (untested) workarounds:
- send an sql statement inserting the BLOB in a linked table, residing on AS/400.
- calling a ms sql stored procedure, copying the blob to a location propagated as parameter

AppServer4RPG is the base layer of ArdGate, you will find some doc here: https://de.slideshare.net/comeur/app-server4rpg-english
These presentation contains how to extend the functionality by writing a Handler by extending a Java Interface. In your case the Handler takes the sourceLocation of the BLOB (table, column, id) and the targetLocation (path and name) and returns success or errorInformation.
It shouldn't be too hard to do this by using Java. As a Bluebrint you could look at the sources of ArdGate on sourceforge.

I Would prefer writing a Handler its easier design: If you need to navigate through the MS SQL database to find the location of the BLOB from RPG ArdGate could do this and afterwards a customized Handler could do rest of the work.

D*B

<Javier>
Java knowledge is no problem at all. Embedded RPG has been my essential
experience for many years, even ILE C programming has been too.
You have said the exact intention: pull up the image's binary stream, put
it on an IFS folder and then send it back as MIME type "image/jpeg" or
whatever, either by sending the whole stream or by a "Location" http
header. There are options for that.

Testing your tool is what I'd like to do. What I would need is, where can
I find more information, as sample usage code? Is that in the same
project's site?

</Javier>



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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.