IBM DB2: Difference between revisions

80 bytes added ,  29 November 2007
no edit summary
No edit summary
No edit summary
Line 22: Line 22:


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'.
Anonymous user