IBM DB2: Difference between revisions
no edit summary
(New page) |
No edit summary |
||
Line 6: | Line 6: | ||
#Its free, with unlimited database size (but server memory <= 4Gb) | #Its free, with unlimited database size (but server memory <= 4Gb) | ||
#DB2 server runs on Windows but also Linux and many others | #DB2 server runs on Windows but also Linux and many others | ||
#The DB2 data can be accessed from DF32 Linux programs as well as VDF and other programmnig environments | #The DB2 data can be accessed from [[DF32]] Linux programs as well as VDF and other programmnig environments | ||
#It is really fast and self tuning, no DBA hours required | #It is really fast and self tuning, no DBA hours required | ||
# | #[[Data Access]] And [[Mertech Data]] have fantastic Connectivity Kits, not only from VDF but also from Linux DataFlex Console Mode systems. | ||
== Running Character Mode DF32 == | == Running Character Mode DF32 == | ||
If you still have a lot of | If you still have a lot of *[[DataFlex| Character mode]] programming. And it is not an option to move to VDF (Because of bandwith, factory environment, etc), I recommend that you have a serious look at: | ||
*Convert your Console Mode program to Linux | |||
*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 | 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]]. | ||
== 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) | |||
*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'. |