Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
During the load of an Universe database I get the following error and the load ends:
QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: S1000, ErrorCode: 0, ErrorMsg: [Rocket U2][UVODBC][2301131]Error ID: 13 Severity: ERROR Facility: DATUMERR - Incorrectly formatted date/time.Error noticed at the character or token ending at column 6 of line 65535 of the input SQL statement.
I use the Universe ODBC driver from Rocket U2.
Does anybody know how to change the format so it will load the line, or is there a way to input a default value so I can check which lines give the error?
Thanks in advance!!
Can you attach your scripts so that I can try !
Vikas
My script is very basic:
SQL SELECT
FIELD_A,
FIELD_B,
FIELD_C
FROM SOURCE_A;
The only way I can now load from SOURCE_A is by removing the field which gives the error.