Db2

Db2

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

Announcing the Latest Version of DCW: Database Conversion Workbench 4.0.37

By Jordan Hodges posted Thu January 16, 2020 01:24 PM

  
Release notes for Database Conversion Workbench 4.0.37

March 16, 2020
 
What's new in this release?
 
PDA :
  • The default expression is now converted to CURRENT TIME in relevant scenarios.
  • INSTR function is now converted to INSTR4.
  • DCW now flags DROP SESSION and EXECUTE AS statements.
Oracle :
  • DCW now flags the use of the RETURN keyword in the UPDATE statement.
  • DCW now parses ACCESSIBLE By clause correctly.
  • SYSTIMESTAMP" in the default clause of CREATE TABLE definition is now converted to "CURRENT TIMESTAMP".
  • DCW now supports alter session set clause.
  • VISIBLE and INVISIBLE column constraints are now converted to NOT HIDDEN and IMPLICITLY HIDDEN respectively.
  • DCW now supports indexes with names ENABLE and DISABLE.
  • Period definition in the CREATE TABLE statement is now parsed for Oracle databases.
Known Issues:
  • For the DCW application launch issue with macOS version 10.15 (Catalina), Please refer <DCW Install Dir>/Readme.txt file in the DCW Mac package.
  • On MacOS double click on dcw executable doesn't work. You can workaround it by running it from command line.
  • On MacOS download using Safari browser, other browsers have problems.
 
Best Practice:
  • For Windows DCW Full Client download, use Download Director instead of HTTP method

#Db2
0 comments
61 views

Permalink

https://community.ibm.com/community/user/blogs/jordan-hodges1/2020/01/16/introducing-database-conversion-workbench-4