Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I am getting below ODBC error while trying to reload data from Teradata connection:
"SQL##f - SqlState: S1000, ErrorCode: 0, ErrorMsg: [Teradata][ODBC Teradata Driver] Major Status=0xd0000 Minor Status=0x80090303-Failure ODBC CONNECT TO TD1"
ODBC driver is working fine if I do just select. Only during reload I am getting this error.
Any help will on this please? I did some google but didnt get any resolution. I tried OLE DB as well, but that has its own set off issues which I think better to avoid for the scope of this discussion.
Thanks,
Debi
Can you set this before load statement and then run
SET ErrorMode = 0;
Thanks Anil,
I added that in script and now my script looks like below:
SET ErrorMode = 0;
ODBC CONNECT TO TD1;
SQL SELECT * FROM "PDL_BASE_VIEWS"."ADDRESS_D";
But now there is no error, but no output as well.