× 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 part of the AppServer4RPG I provided a link to...

Charles

On Fri, Jan 12, 2024 at 2:06 PM Rob Berendt <robertowenberendt@xxxxxxxxx>
wrote:

If you want to do it directly from an RPG program or sql procedure you may
want to look at ARDGATE. I've never used it. Not my product. Basically
it's a driver to put something in an exit to allow you to simply sql MS
SQL. It's from Dieter Bender.

On Fri, Jan 12, 2024 at 2:47 PM Javier Sanchez <
javiersanchezbarquero@xxxxxxxxx> wrote:

I confess I have never done this before.
I am writing a CGI program, where I will receive a request asking to
search
for and return two images, may be png, jpeg, bmp, etc.

These images live in a SQL Server table, I understand it's one column for
each image, and I also understand that these should be of type BLOB.

I have found quite a few documents that show how to configure the IBM i,
and it also says that on the side of the MS SQL Server it is required
that
some service called msdrdaservice be up and running. I have been unable
to
get this part of the process done, because I depend on the team that's on
the other side of the IBM i.

Even so, I think we're close to getting it. But I just don't know how to
manage the query that's going to give me back the two BLOB columns
containing the images. Moreover, I have never returned, say, a multipart
http response. I have read material but I need to do that by myself now.
:-D

I would greatly appreciate comments, suggestions, recommendations,
everything.

TIA

Javier.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
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.