PDA

View Full Version : Error encountered trying to convert to DB2 8.02 using DB2-CK4



Stephen W. Meeley
5-Dec-2005, 12:15 AM
Raveen,

The issue with the bad conversion (missing recnum) is a known bug when
using the 4.0 CKs with pre-VDF 11.

http://www.dataaccess.com/BugTracker/SecPrintBug.asp?ArticleID=3604

It is fixed in the 4.1 CKs that are part of the 11.1 Studio. We'll be
updating the CK installations this week and will have them posted as
soon as they pass testing.

Best regards,

-SWM-


-----Original Message-----
From: Raveen Ryan Sundram [mailto:raveen@xls.co.nz]
Posted At: Sunday, December 04, 2005 6:51 PM
Posted To: data-connectivity
Conversation: Error encountered trying to convert to DB2 8.02 using
DB2-CK4
Subject: Error encountered trying to convert to DB2 8.02 using DB2-CK4

Hi,

I'm currently testing DataFlex with DB2.
I installed DB2 last weekend and also DB2-CK4

I'm using VDF10.1 with DB-Builder 10.1.7.0

And am trying to convert my (currently dataflex) database to DB2.

My database contains the following features:

1. Wide usage of OVERLAP fields used for file-relationships
2. Some indexes with UCASE
3. Some indexes with OVERLAP fields

My Problem:
--------------------
The DB2-CK4 converts the data-files WITHOUT DFRECNUM support.
I'm using the "Convert to DB2" under "Database" Menu option

My parameters are:
1. "Generate RID Method" = "Identify Column"
2. "Get Record Identity After Create" = "True"
3. "RECNUM Index Conversion" = "Always use Record Identity"

And another thing, where I've set UCASE true for my dataflex indexes,
the
DB2-CK4 driver creates a new field with a "U_" prefix. I'm assuming that
its
for storing the uppercase value of field in concern. But does it also
create
a trigger to populate these fields? Or must my add extra code for this
in
program?


But strangely,

If I use the standard ODBC driver to convert my database to DB2, using
the
"Convert to ODBC" under "Database" Menu option

The Database is converted properly with DFRECNUM support/columns. And no

"U_" prefixes for UCASE indexed fields.

Please help!?

--
Regards,
Raveen Ryan Sundram
Excellent Software (NZ) Ltd.