Datatrieve DATE type conversion to Oracle?

From: John Perkins <jperkins_at_cwcom.zap.net>
Date: Mon, 25 Jun 2001 19:00:27 +0100
Message-ID: <aruejtkse7lo0pgskddpvm0a6e6r08ijjm@4ax.com>

We are importing large DEC Rdb tables into Oracle, but what makes it a very lengthy process is the need to use a complex function in the mapping to convert the Double Long Word (64 bit QUAD data type) of Datatrieve into the Oracle DATE type.

Does anyone know of a more efficient method?

Sample from a Datatrieve Record Definition:

10 ISSUE_DATE_LONG LONG OCCURS 2 TIMES. 10 ISSUE_DATE REDEFINES ISSUE_DATE_LONG USAGE IS DATE. LONG data type: 32 bit integer, max ±2,147,483,647 QUAD data type: 64 bit integer, max ±9.2 x 10E18 1 second is 1E7 and 1 day is 864E9

TIA,
John Received on Mon Jun 25 2001 - 13:00:27 CDT