Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Problem with Odbc for AS 400

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 ?

1 Solution

Accepted Solutions
llauses243
Contributor III

Problem with Odbc for AS 400

Hi,

This is my offer ...

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

SQL SELECT COMPANY, CHIU_CONT, NUMBER YES

Good luck, Luis.



4 Replies
Not applicable

Problem with Odbc for AS 400

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,

JA

llauses243
Contributor III

Problem with Odbc for AS 400

Hi,

This is my offer ...

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

SQL SELECT COMPANY, CHIU_CONT, NUMBER YES

Good luck, Luis.



Not applicable

Problem with Odbc for AS 400

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 ?

llauses243
Contributor III

Problem with Odbc for AS 400

Hi,

This my offer ...

Good luck, Luis