Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2012

    Unanswered: With two different schmeas same table name is created or not

    Hi My name is narasimha,i want to do create two differenet schemas, in that two schemas i want to create two same tablenames in db2 ese of testing server.
    I created two schemas and two same tablesnames it is created but not showing
    the table, what was the reason please help to me
    i used the following querries.
    db2 "create table emp(eno int,ename varchar(15),sal int)"
    emp table is default under the schmea is userid

    db2 "create schema myschematest"
    db2 set current schema myschmeatest
    db2 "create table myschematest.emp(eno int,ename varchar(15),sal int)"
    if i issue the command
    db2 list tables for all
    it is showing db2inst1 emp
    myschematest emp
    but when i was quering it is not showing
    db2 list tables for schema myschematest

    Thanks and Regards
    Narasimha A

  2. #2
    Join Date
    May 2003
    Look in syscat.tables and figure out what is wrong.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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