ca.portal.admin

IDMS SQL DELETE statement issue

Discussion created by ca.portal.admin on Dec 20, 2006
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)

Outcomes