Matt,
Aside from the obvious - redesign your queries to the lowest common
denominator (such as V4R5) - you might ask the folks at Hit Software
(www.hitsw.com). I used their DB2 drivers (for OS/400 & mainframe)
several years ago (before IBM offered a type 4 driver of their own), and
was very happy with the product & the support.
In fact, at the time, my client had a similar issue and we also
considered the DDM approach. However, we didn't really get far with it,
as performance was critical for the application at hand, and the DDM
server would have just introduced another layer.
In the end, we just went ahead and rewrote the queries.
--
Mike Mills
www.MikeMillsConsulting.com
Arnett, Matt wrote:
Is anyone aware of a DB2 JDBC Driver that can “interpret/convert/dumb
down” SQL queries that have features supported by higher levels of
OS/400 (i.e. V5R2) to lower levels of OS/400 (i.e. V4R5)? Does
Hibernate have any support like this?
We are using the jt400.jar (v5.3) from IBM (IBM Toolbox for Java,
JTOpen 4.1, _http://jt400.sourceforge.net/_).
We have several versions of OS/400 floating around on several remote
systems. We have found some queries that were designed against OS/400
V5R2 will not work on older versions of OS/400. I have heard that
there is a way to use DDM on a central AS400 to act as a view to the
remote AS400s and the DDM can convert the queries to the supported
version of OS/400 on the target system. Although, this is yet to be
tested/proven to work.
Thanks,
Matt
This e-mail transmission contains information that is intended to be
confidential and privileged. If you receive this e-mail and you are
not a named addressee you are hereby notified that you are not
authorized to read, print, retain, copy or disseminate this
communication without the consent of the sender and that doing so is
prohibited and may be unlawful. Please reply to the message
immediately by informing the sender that the message was misdirected.
After replying, please delete and otherwise erase it and any
attachments from your computer system. Your assistance in correcting
this error is appreciated.
|