Sending data from iSeries db query to Local storage converts a Date field to Char(6) (4305571)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Sending data from iSeries db query to Local storage converts a Date field to Char(6)
Description

When sending the results of a query on an iSeries database to local storage, Toad reads a DATE field as a CHAR(6) field. If CHAR(6) is manually changed to DATETIME (the only date option) then the date field is imported as NULL.
Resolution

WORKAROUND

none

STATUS

Waiting for fix in a future release of Toad Data Point
Defect ID

QAT-1654

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title