Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Hi,
This is my offer ...
SQL SELECT "COMPANY", "CHIU_CONT", "NUMBER" NON
SQL SELECT COMPANY, CHIU_CONT, NUMBER YES
Good luck, Luis.
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
Hi,
This is my offer ...
SQL SELECT "COMPANY", "CHIU_CONT", "NUMBER" NON
SQL SELECT COMPANY, CHIU_CONT, NUMBER YES
Good luck, Luis.
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 ?