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)