Answers to 1 and 2: True

http://www.db2expert.com/index.php?page=transitionclass


Answer to 3: True





-----Original Message-----
From: Edwards Ed
[mailto:db2udbdba-ezmlmshield-x54563381.[Email address protected]
Sent: Thursday, August 30, 2007 8:28 AM
To: LazyDBA Discussion
Subject: RE: db2 udb v9.0 new fetures

All right, everybody! Listen up! This is me (Ed Edwards), Oracle DBA
Guru (that's pronounced Glue Root - hehe) #1! Are the following
statements true? Hehe.

1. In DB2 version 9 for LUW, there is no "rename column". That is a
feature of DB2 version 9 for z/OS and OS/390.

2. In DB2 version 9 for z/OS and OS/390, you can use multiple
"distinct" in your "SELECT" statement.

3. In DB2 version 9 for LUW, the TRIM and STRIP functions have been
added.





Please take a few minutes to provide feedback on the quality of service
you received from our staff. The Department of Education values your
feedback as a customer. Commissioner of Education Jeanine Blomberg is
committed to continuously assessing and improving the level and quality
of services provided to you.Simply use the link below. Thank you in
advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Schleicher Jeremy D.
[mailto:db2udbdba-ezmlmshield-x6899791.[Email address protected]
Sent: Wednesday, August 22, 2007 7:31 AM
To: LazyDBA Discussion
Subject: RE: db2 udb v9.0 new fetures

Go here for all of the version 9 manuals. For what you want to know,
look at the What's New book.

http://www-1.ibm.com/support/docview.wss?rs=71&uid=swg27009552

-----Original Message-----
From: Devang Mehta
[mailto:db2udbdba-ezmlmshield-x36912135.[Email address protected]
Sent: Wednesday, August 22, 2007 7:27 AM
To: LazyDBA Discussion
Subject: db2 udb v9.0 new fetures

Hi,
I want to know the difference between 2 version of db2 udb 8.0 and 9.0.
Can any body give me link or documentaion where i can compare both of
them?

Regards,


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

DB2 & UDB email list listserv db2-l LazyDBA home page