Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
SQL changes needed when you migrate from v8

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
Author Message
boo_sri

New User


Joined: 26 Jul 2005
Posts: 19
Location: charlotte

PostPosted: Fri Apr 25, 2008 11:03 pm    Post subject: SQL changes needed when you migrate from v8
Reply with quote

What kind of SQL changes/enhancements needed when you migrate from DB2 v8 compatibilty mode to new function mode. I am giving one example of SQL change (ORDER by Clause) :
Collating sequence (ordering):
Compatibility Mode = EBCDIC
New Function Mode = ASCII

So please let me know where can i find the list of all changes needed from application (like compiler options etc) and SQL perspective.
Back to top
View user's profile Send private message
References
PostPosted: Fri Apr 25, 2008 11:03 pm    Post subject: Re: SQL changes needed when you migrate from v8 Reply with quote

dbzTHEdinosauer

Senior Member


Joined: 20 Oct 2006
Posts: 1067
Location: germany

PostPosted: Sat Apr 26, 2008 12:49 pm    Post subject:
Reply with quote

each release of db2 has several documents. there will always be 3: Application Programmers guide, SQL reference and migration guide.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1