Mark A
"tmugavero" <tmugavero@gmail.com> wrote in message
news:1127167175.888556.152740@g44g2000cwa.googlegr oups.com...[color=blue]
> Hello,
>
> This is my first time starting a topic here so I hope this is the right
> place. I am having problems running SQL queries on a Version 8 DB2
> database for Windows Server using the type 4 driver. I get a connection
> but when I run a query, I get this error:
>
> DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704
>
> For example if my query was "SELECT * from TABLE" , I would get the
> error:
>
> "DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704 DB2ADMIN.TABLE" [SELECT
> * FROM IDSC.TABLE]
>
> I looked at the error codes online and they do not provide me with any
> information I did not already know. Any help would be greatly
> appreciated.
>
> Kindest Regards,
>
> Tony
>[/color]
If the userid you are using is db2admin, and you don't supply a high level
qualifier on the table name, the DB2 assumes that DB2ADMIN is the qualifier
(schema) name. You can use the SET SCHEMA statement before hand, use an
alias, or use the a userid with the same name as your schema.
| 
