IDMS

IDMS SQL DELETE statement issue

  • 1.  IDMS SQL DELETE statement issue

    Posted Dec 19, 2006 08:23 PM
    Hi, List knowledge needed with error message ""*+ DB006052 T431 C-4M330:
    Table name required in searched UPDATE or DELETE *+ statement.""

    We have a table in which we can execute the following and get data
    returned.

    SELECT * FROM DEFAULT.PROBLEMS WHERE KEY_1 = '00001'; *+
    *+ KEY_1       KEY_2       KEY_3       KEY_4       KEY_5       KEY_6
    *+ -----       -----       -----       -----       -----       -----
    *+ 00001       00004       <null>      <null>      <null>      <null>
    *+
    *+ 00001       00004       <null>      <null>      <null>      <null>
    *+
    *+ 00001       00004       <null>      <null>      <null>      <null>
    *+
    *+ 00001       00004       <null>      <null>      <null>      <null>
    *+

    The above data was placed into table with INSERT statment.

    In trying to delete selected records with following statement an error
    is returned in which we can not figure out root cause;

    DELETE FROM DEFAULT.PROBLEMS WHERE KEY_1 = '00001';
    *+ Status = -4       SQLSTATE = 42000        Messages follow:
    *+ DB006052 T431 C-4M330: Table name required in searched UPDATE or
    DELETE

    *+ statement.

    The message.

    DB006052 C<sqlcode>M<module-number>: Table name required in searched
    UPDATE or DELETE statement.
    Reason: A searched UPDATE or DELETE statement must identify the target
    table.
    Module: IDMSSPSQ (SQLYACC)
    Severity: 0

    The table.

    *+ Status = 0        SQLSTATE = 00000
    *+   CREATE TABLE DEFAULT.PROBLEMS
    *+       DEFINITION TIMESTAMP 1992-03-09-14.00.45.529150
    *+       DATE CREATED 1992-03-09-13.45.31.252316   BY ADMORLT
    *+       DATE LAST UPDATED 1992-03-09-13.45.31.252316   BY ADMORLT
    *+     ( KEY_1                            CHARACTER(10),
    *+       KEY_2                            CHARACTER(10),
    *+       KEY_3                            CHARACTER(10),
    *+       KEY_4                            CHARACTER(10),
    *+       KEY_5                            CHARACTER(10),
    *+       KEY_6                            CHARACTER(10),
    *+       TEXT_1                           CHARACTER(80),
    *+       TEXT_2                           CHARACTER(80),
    *+       TEXT_3                           CHARACTER(80)
    *+     )
    *+       IN DEFAULT.DEFAULT_AREA
    *+       DEFAULT INDEX ON DBKEY
    *+       KEY_INDEX_1 INDEX ON ( KEY_1 )
    *+       KEY_INDEX_2 INDEX ON ( KEY_2 )
    *+       KEY_INDEX_3 INDEX ON ( KEY_3 )
    *+       KEY_INDEX_4 INDEX ON ( KEY_4 )
    *+       KEY_INDEX_5 INDEX ON ( KEY_5 )
    *+       KEY_INDEX_6 INDEX ON ( KEY_6 )
    *+       ;

    Anyone seen this before?

    Rob Klan/Cincinnati/IBM
    Phone: 1-877-205-4871 (T/L: 349-2446)
    ITN: 23492446
    Email: rklan@us.ibm.com
    "
    IDMS Public Discussion Forum
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP
    IDMS-L@LISTSERV.IUASSN.COM
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP








    Normal

    Normal
    Re: Writing to Internal Reader Issue
    "We don't have a DCB coded on the DD statement, just:

    //JESRDR DD SYSOUT=(N,INTRDR)