Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Creator III
Creator III

Hi,

This is my offer ...

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

SQL SELECT COMPANY, CHIU_CONT, NUMBER YES

Good luck, Luis.



View solution in original post

4 Replies
Not applicable

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
Creator III
Creator III

Hi,

This is my offer ...

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

SQL SELECT COMPANY, CHIU_CONT, NUMBER YES

Good luck, Luis.



View solution in original post

Not applicable

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
Creator III
Creator III

Hi,

This my offer ...

Good luck, Luis