i am working with the sample database.i have a login table in sample database.when i am working in db2 control center and issuing any sql ,it is working very fine.but when i am issuing this sql from a java application it is showing a error.my username and password for the database is db2admin and db2admin.connection to the database is successful.
please help me.i tried this in xp and win7.same result.
error is:

[IBM][CLI Driver][DB2/NT] SQL0204N "DB2ADMIN.LOGIN" is an undefined name. SQLS
TATE=42704


i am issuing the sql----> select * from login
but it is not working.
i have also tried-------> select * from LOGIN
select * from sample.login
select * from db2admin.login
how to solve it?

Clearly, the LOGIN table belongs to some other schema. You can find out what schema that is by running

thank u sir.i got ur point.problem solved.thank u.