topic Problem with Odbc for AS 400 in QlikView

Problem with Odbc for AS 400

Fri, 04 Mar 2011 15:22:35 GMT

the command "where" doesn't work.

This is the code that I use :

ODBC CONNECT32 TO [AS/400 EDP];

Test:

SQL SELECT "COMPANY", "CHIU_CONT", "NUMBER"

FROM DIREODBC.TABLEDTA09.PPFDST02

WHERE CHIU_CONT > "01/01/2011";

I have this error :

SQL##f - SqlState: S0022, ErrorCode: 4294967090, ErrorMsg: [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0206 - Colonna "01/01/2011" non specificata nelle tabelle.

The translationin of the error message :

SQL##f - SqlState: S0022, ErrorCode: 4294967090, ErrorMsg: [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0206 - Column "01/01/2011" is not specified in the tables.

( I have also used #01/01/2011# and not this "01/01/2011").

Is there a solution at this problem ?

Problem with Odbc for AS 400

Tue, 08 Mar 2011 21:02:43 GMT

Hi,

try single quotes instead of double in predicate:

SQL SELECT "COMPANY", "CHIU_CONT", "NUMBER"

FROM DIREODBC.TABLEDTA09.PPFDST02

WHERE CHIU_CONT > '01/01/2011';

kr,

Problem with Odbc for AS 400

llauses243 — Tue, 08 Mar 2011 21:56:17 GMT

Hi,

This is my offer ...

SQL SELECT "COMPANY", "CHIU_CONT", "NUMBER" NON

SQL SELECT COMPANY, CHIU_CONT, NUMBER YES

Good luck, Luis.

Problem with Odbc for AS 400

Fri, 18 Mar 2011 21:24:19 GMT

It is ok.

Now it works in correct way :

ODBC CONNECT32 TO [AS/400 EDP];

LOAD COMPANY, CHIU_CONT, NUMBER;

SQL SELECT COMPANY, CHIU_CONT, NUMBER

FROM DIREODBC.TABLEDTA09.PPFDST02

WHERE CHIU_CONT > "01/01/2011";

But I am not able to add the option "TOP". Do you have some idea to resove the problem ?

Problem with Odbc for AS 400

llauses243 — Sat, 19 Mar 2011 11:07:23 GMT

Hi,

This my offer ...

Good luck, Luis