Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
QlikView 12.02.04 - Error while fetching tables through ODBC connection
SQL##f - SqlState: S1C00, ErrorCode: 3, ErrorMsg: [Oracle][ODBC][Ora]Driver not capable.
LOAD CONNID,
DATA_UPDATE,
FLOW,
FLOW_STEP;
SQL SELECT *
FROM "CRM_SF_IF".PROVA2;
I’m trying to fetch a column that is defined as TIMESTAMP with TIMEZONE, that is causing the problem.
If I comment the column with that datatype into the load script, it doesn’t work yet.
I would not change the column size on the db, is there some solution to keep the TIMEZONE?
Thanks a lot
Paolo
Try fetching only the needed columns
LOAD CONNID,
DATA_UPDATE,
FLOW,
FLOW_STEP;
SQL SELECT
CONNID,
DATA_UPDATE,
FLOW,
FLOW_STEP
FROM "CRM_SF_IF".PROVA2;
wqwefregf
Hi Clever,
I tried to fetch only the needed columns but it didn't work.
The error remains.
I have to change the field datatype of the table removing the TIMEZONE,
in this way the load script works well.
Is not possible to fetch a column that is defined as TIMESTAMP with TIMEZONE.
Paolo
Did you try casting the field?
SQL
SELECT
CONNID,
TO_DATE(DATA_UPDATE,'MM/DD/YYYY') AS DATA_UPDATE,
FROM "CRM_SF_IF".PROVA2
yes Idid.
I had the same error.
The only solution I've found is to change the field type in the data warehouse table
Paolo
As I understand, tt is not possible to fetch a Timestamp with Timezone field via ODBC - this is an ODBC limitation that has nothing to do with QlikView.
Some workarounds are suggested here:
Try without the preceeding load
SQL SELECT
CONNID,
DATA_UPDATE,
FLOW,
FLOW_STEP
FROM "CRM_SF_IF".PROVA2;
Hi Sasidhar,
doesn't work
May be try
SQL SELECT
CONNID,
TO_TIMESTAMP(DATA_UPDATE,'YYYY-MM-DD HH24:MI:SS') As DATA_UPDATE,
FLOW,
FLOW_STEP
FROM "CRM_SF_IF".PROVA2;
or
SQL SELECT
CONNID,
TO_char(DATA_UPDATE,'YYYY-MM-DD HH24:MI:SS') As DATA_UPDATE,
FLOW,
FLOW_STEP
FROM "CRM_SF_IF".PROVA2;