Problem with Odbc for AS 400

[#1]

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 ?

[#2]

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 · Accepted solution]

Hi,

This is my offer ...

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

SQL SELECT COMPANY, CHIU_CONT, NUMBER YES

Good luck, Luis.

[#4]

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]

Hi,

This my offer ...

Good luck, Luis