Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2011
    Posts
    8

    Unanswered: please help me for the error SQL0204N in db2

    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?

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Clearly, the LOGIN table belongs to some other schema. You can find out what schema that is by running
    Code:
    select tabschema from syscat.tables where tabname = 'LOGIN'

  3. #3
    Join Date
    Jun 2011
    Posts
    8

    thank u

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •