Results 1 to 5 of 5

Thread: table creator

  1. #1
    Join Date
    Oct 2013
    Posts
    1

    Question Unanswered: table creator

    Hi guys, i am really not good at this so i would very much appreciate some help in sql for dummies.
    I need to make a LOAD RESUME into a table. I am trying to use the Load utility but i am being asked for creator of the table..
    My table is orladm.indice_referenci
    How can i find out the creator? Is it very stupid to assume the creator is "orladm" or that is the owner??
    PLease help!!!!!
    Much appreciated

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Please provide your DB2 version, Operating System/Version.

    If you can copy and paste the exact commands you issued and error messages/prompts, that would be good also.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    that is the owner/creator

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by bergwald21 View Post
    my table is orladm.indice_referenci
    how can i find out the creator?
    Code:
    select owner from syscat.tables
    where tabschema = 'ORLADM' 
    and tabname = 'INDICE'
    ---
    "It does not work" is not a valid problem statement.

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by bergwald21 View Post
    How can i find out the creator? I
    IBM Information Management Software for z/OS Solutions Information Center

Posting Permissions

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