IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

SQL changes needed when you migrate from v8


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
boo_sri

New User


Joined: 26 Jul 2005
Posts: 36
Location: charlotte

PostPosted: Fri Apr 25, 2008 11:03 pm
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
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Sat Apr 26, 2008 12:49 pm
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
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Mainframe Programmer with CICS Skill... Mainframe Jobs 0
No new posts Help needed to assemble IMS sample co... ABENDS & Debugging 4
No new posts RABBIT HOLE NEEDED - "Live"... All Other Mainframe Topics 0
No new posts Mainframe profiles needed @ Cognizant Mainframe Jobs 0
No new posts COBOL Student learning COBOL File Han... COBOL Programming 3
Search our Forums:

Back to Top