Results 1 to 5 of 5
  1. #1
    Join Date
    May 2006
    Posts
    20

    Unanswered: How to find the Creator Name for a perticular table

    Hi,


    If I know the table name how to find the creator for that table?
    I am unable run queries for that table without the creator name.


    Thanks

  2. #2
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    definer in syscat.tables
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by shrivatsa
    I am unable run queries for that table without the creator name.
    I think that you may be confusing schema name with creator name; they are not necessarily the same, and you definitely don't need the creator name to query the table.
    ---
    "It does not work" is not a valid problem statement.

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    It is always good practice to fully qualify all your database objects (tables, functions, ...) anyway, i.e. use schema and object name.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  5. #5
    Join Date
    May 2006
    Posts
    82
    You told that you know the table name. Try with this query.

    SELECT STRIP(CREATOR)||'.'||NAME FROM SYSIBM.SYSTABLES WHERE NAME = 'table_name' AND TYPE = 'T';

    you should get the fully qualified table name for the above query. (1 or more)
    Proved the table name you will provide really exists.

    I am unable run queries for that table without the creator name.
    What error are you getting. Is that saying OBJECT does not exists ..?
    you cannot query the table with out the owner's name unless you are an owner for that table. If you wont give the creator name in the query, then CURRENT SQLID will be considered as the table owner.
    Give us the information about platform, and version details. If its z/os it should be giving -204.

Posting Permissions

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