da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: DB/2

Forum List » AnyDAC » v 2.0 Beta English

sally
User

Junior Boarder

Posts: 18

Karma: 0

DB/2

Posted: 2007/09/20 12:37

DB/2, fieldnames and tablenames are all uppercase.

when I enter:

"select * from {id Test}"

it response: Error:
"No table from "DATBASE.Test".

--------------

when I enter:

"select * from {id TEST}"

it response: OK.

Can the DB/2 driver be fixed so the fieldnames are case-insensitive?

thank you.

Diman

Admin

Posts: 1461

Karma: 18

Re:DB/2

Posted: 2007/10/17 03:35

Hello

That is not a AnyDAC issue. Escape sequence {id xxx} just quotes xxx name using target DBMS rules and the xxx name case is preserved. So, on MySQL {id xxx} will be `xxx`, on DB2 - "xxx", etc

Regards,
Dmitry

Forum List » AnyDAC » v 2.0 Beta English