Re: DB2 V8.2 versus V5R2

Alex Jayasundara <edjayasundara-/[email protected]> Fri, 9 Sep 2005 07:48:05 -0700 (PDT)
Newsgroups gmane.comp.systems.as400.open-source
Message-ID <[email protected]>
Hi,

Can you kindly be more specific? Most probably a line
of an example may be better.

Alex

--- "John S. Brumbelow" <[email protected]>
wrote:

> Please help,
> 
> 	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 th!
>  e DB2 become different? And what about V5R2? Can I
> develop queries for V8.2, that will work for V5R2?
> And vice versa.
> 
> Please someone help,
> 
> Thanks in advance,
> 
> John
> 
> 
> 
> -- 
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.344 / Virus Database: 267.10.19/92 -
> Release Date: 9/7/2005
>  
> 
> _______________________________________________
> 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.
> 



	
		
______________________________________________________
Click here to donate to the Hurricane Katrina relief effort.
http://store.yahoo.com/redcross-donate3/
_______________________________________________
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.