Hi all !

I have to use DB2 to test something, and when i want to connect me i have an error :

Warning: odbc_exec(): SQL error: [IBM][CLI Driver][DB2/NT] SQL0204N Le nom "ROOT2.SCAT" n'est pas défini. SQLSTATE=42704 , SQL state S0002 in SQLExecDirect in c:\appserv\www\***\ins\RWconnect.php on line 184

My login is root2 and i want to send this query : SELECT type FROM scat WHERE id=1.

Do you have already seen this error ?
Thanks for your help !

It means there's no table named "SCAT" in the "ROOT2" schema.

Yes sorry, i start with db2
There's no table scad in the root2 schema, there's in the ADMINISTRATEUR schema.

so : SELECT type FROM ADMINISTRATEUR.scat WHERE id=1
And it works fine

Thx