IBM DB2: Difference between revisions
m
Improve link
No edit summary |
m (Improve link) |
||
| (5 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
For many years IBM DB2 was exclusive to the very expensive Mainframes and other heavy servers, and the only connnectivity from DataFlex was for minor applications. | For many years IBM DB2 was exclusive to the very expensive Mainframes and other heavy servers, and the only connnectivity from DataFlex was for minor applications. | ||
Nowadays IBM DB2 UDB has a free version for use in commercial environments. It is the | Nowadays IBM DB2 UDB has a free version for use in commercial environments. It is the [http://www-306.ibm.com/software/data/db2/express/ Express-C] edition. | ||
The great things about this database are: | The great things about this database are: | ||
| Line 17: | Line 17: | ||
*Convert your DataFlex tables to DB2 | *Convert your DataFlex tables to DB2 | ||
This opens up a new world for unleashing your data in a safe way. You can do datamining, run crystal without DataFlex CK, even create Java, .Net or any other applications all using your data. Offcourse this does not take [[Data Dictionaries]] into effect, but you most likely did not have these anyway in [[DF32]]. | This opens up a new world for unleashing your data in a safe way. You can do datamining, run crystal without DataFlex CK, even create Java, .Net or any other applications all using your data. Offcourse this does not take [[Data Dictionaries]] into effect, but you most likely did not have these anyway in [[DataFlex|DF32]]. | ||
== Conversion == | == Conversion == | ||
The conversion from Embedded DataFlex to DB2 has some gotcha's; | The conversion from Embedded DataFlex to DB2 has some gotcha's; | ||
*DB2 has several options for Collating Sequence. Please carefully select this prior to creating your database matching with your collate.cfg. (Hint: use 'Fill_Field' rather than move 'zzzz' in your old programs) | *DB2 has several options for Collating Sequence. Please carefully select this prior to creating your database matching with your collate.cfg. (Hint: use 'Fill_Field' rather than move 'zzzz' in your old programs), or use the DAW utility CreaDb to create the database matching the Collate.cfg. | ||
*Some nested reports might run slower. Concider creating an SQL View, link this as a table using the Filelist and a INT file, then report from the 'Flat file'. | *Some nested reports might run slower. Concider creating an SQL View, link this as a table using the Filelist and a INT file, then report from the 'Flat file'. | ||
[[Category:DB2]] | |||