Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2013
    Posts
    8

    Unanswered: Need Help "UNDEFINED NAME"

    Hi guys...i hope you can help with this issue. I am trying to update a table with this script;

    db2 "import from ./edr_calendar.dat of del
    insert into EDR.CALENDAR
    (CALENDAR_DATE_ID,DATE_OF_DAY,YEAR,MONTH,WEEK,DAY, WEEK_OF_MONTH,WEEKS_IN_MONTH,WEEKS_IN_YEAR,DAYS_IN _MONTH,DAYS_IN_YEAR,DAY_OF_WEEK,FIRST_DAY_OF_MONTH ,LAST_DAY_OF_MONTH,FIRST_DAY_OF_WEEK
    ,LAST_DAY_OF_WEEK,FULL_MONTH_NAME_ENG,FULL_MONTH_N AME_FRN,SHORT_MONTH_NAME_ENG,SHORT_MONTH_NAME_FRN, FULL_DAY_OF_WEEK_ENG,FULL_DAY_OF_WEEK_FRN,SHORT_DA Y_OF_WEEK_ENG,SHORT_DAY_OF_WEEK_FRN,
    FISCAL_YEAR_ID,FISCAL_QUARTER_ID,FISCAL_PERIOD_ID, FISCAL_WEEK_ID)"


    ..i get the error of;

    dove1:edrbatch/bbj> import_edr_calendar.ksh
    SQL2018N The utility encountered an error "-204" while attempting to verify
    the user's authorization ID or database authorizations.

    SQL0204N "EDR.CALENDAR " is an undefined name. SQLSTATE=42704

    SQL2018N The utility encountered an error "" while attempting to verify the
    user's authorization ID or database authorizations.

    ...The table edr.calendar does exists. I am running it as the owner of the file and the table. I cannot figure out what is wrong.

    Thanks
    Brad

  2. #2
    Join Date
    May 2005
    Posts
    29
    Did you already check the syscat.tables to see if the table exist? To make sure its a table, check the TYPE column in the syscat.tables.

    Also, make sure there are no special characters in the tablename

  3. #3
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    Also, check if the table's name is case sensitive or not.
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

  4. #4
    Join Date
    Apr 2012
    Posts
    156
    Check if you can run a select on the table, using both cases.

  5. #5
    Join Date
    Jan 2013
    Posts
    2
    you can use the below selects to check what are the "real" schema/name of you table

    1) select session_user from sysibm.sysdummy1;
    It will give you the userid under which you are currently executing statements

    2) select tabschema, tabname, owner from syscat.tables where type = 'T';
    That will give you a list of all tables in your database (you can potentially use additionnal where clause to limit the list!)

    With the above info, you should be able to find where is the problem.

Posting Permissions

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