Re: DB2 V8.2 versus V5R2

This list is for discussion of Open Source Software on the iSeries ...
as this question doesn't seem to relate to Open Source, I would suggest
this question be posted to MIDRANGE-L instead
(http://list.midrange.com/listinfo/midrange-l).

John S. Brumbelow wrote:
> I am a developer trying to make software work on DB2 for the AS/400
> V5R2. I have worked with DB2 on the AS/400 way back when it was V3R7,
> in 1997, and I swear, there is a HUGE difference between the DB2 on
> the AS/400 of V3R7, versus IBM's DB2 V8.2, which one can download
> today from IBM's website. And this gives me concern about developing
> for DB2, period, let alone V5R2 of the AS/400. Of particular change,
> is "semi-colons" and transaction handling. I can not remember for
> sure, for V3R7, but I swear the queries back then let one use "begin
> transaction", "commit transaction", and "rollback transaction", and
> that queries nested together did not have to be separated by
> semi-colons. But, V8.2 does not have the various aforementioned
> "transaction" syntax, and its queries require statements to be
> separated by semi-colons. And, this implies to me, that queries made
> for V3R7, would not work on V8.2. Now, please correct me, if I'm
> wrong, but if this is true, then at what point did the DB2 become
> different? And what about V5R2? Can I develop queries for V8.2, that
> will work for V5R2? And vice versa.


_______________________________________________
This is the Open Source Software for the AS400/iSeries (OSS400) mailing list
To post a message email: OSS400-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/oss400
or email: OSS400-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/oss400.