SQL0750N in the upgrade during conversion,how drop trigger?
ERROR: Detected the following errors:
# /media/SP702/SUM/SUM/abap/log/EU_SWITCH03.XUT: 2 ETQ399 Connecting to
database 'db6'. 3 ETQ398 SQL: RENAME "DD08L" TO "DD08L~~OLD" 4 ETQ010
Date & Time: 20150511090752 1 ETQ000
================================================== 4 ETQ010 Date &
Time: 20150511090752 1EETQ008 Error message: DBSL error 99 (db code -
750): SQL0750N Thesource table cannot be renamed because it is
referenced in a view, materialized query table, trigger, SQL function,
SQL method, check constraint, referential constraint, or XSR object.
SQLSTATE=42986 1EETQ003 exit code: "12"
saptest:db2hd1 63> cat /media/SP702/SUM/SUM/abap/log/EUSWITCH.ELG
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~SQL EXECUTION ERRORS and RETURN CODE in EU_SWITCH01.XUT
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~2 ETQ399 Connecting to database 'db6'.
3 ETQ398 SQL: RENAME "DD02L" TO "DD02L~~OLD"
4 ETQ010 Date & Time: 20150511090751
1 ETQ000 ==================================================
4 ETQ010 Date & Time: 20150511090751
1EETQ008 Error message: DBSL error 99 (db code -750):
SQL0750N Thesource table cannot be renamed because it is referenced
in a view, materialized query table, trigger, SQL function, SQL method,
check constraint, referential constraint, or XSR object.
SQLSTATE=429861EETQ003 exit code: "12"
<NO EXIT CODE FOUND - PROGRAM ABORTED?>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~SQL EXECUTION ERRORS and RETURN CODE in EU_SWITCH02.XUT
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~2 ETQ399 Connecting to database 'db6'.
3 ETQ398 SQL: RENAME "DD02T" TO "DD02T~~OLD"
4 ETQ010 Date & Time: 20150511090751
1 ETQ000 ==================================================
4 ETQ010 Date & Time: 20150511090751
1EETQ008 Error message: DBSL error 99 (db code -750):
SQL0750N Thesource table cannot be renamed because it is referenced
in a view, materialized query table, trigger, SQL function, SQL method,
check constraint, referential constraint, or XSR object.
SQLSTATE=429861EETQ003 exit code: "12"
<NO EXIT CODE FOUND - PROGRAM ABORTED?>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~SQL EXECUTION ERRORS and RETURN CODE in EU_SWITCH03.XUT
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~2 ETQ399 Connecting to database 'db6'.
3 ETQ398 SQL: RENAME "DD08L" TO "DD08L~~OLD"
4 ETQ010 Date & Time: 20150511090752
1 ETQ000 ==================================================
4 ETQ010 Date & Time: 20150511090752
1EETQ008 Error message: DBSL error 99 (db code -750):
SQL0750N Thesource table cannot be renamed because it is referenced
in a view, materialized query table, trigger, SQL function, SQL method,
check constraint, referential constraint, or XSR object.
SQLSTATE=429861EETQ003 exit code: "12"
<NO EXIT CODE FOUND - PROGRAM ABORTED?>
I found note 381518,nofound solution.
saptest:db2hd1 5> db2level
DB21085I Instance "db2hd1" uses "64" bits and DB2 code
release "SQL09058" with
level identifier "06090107".
Informational tokens are "DB2
v9.5.0.8", "special_27408", "IP23263_27408", and
Fix Pack "8".
Product is installed at "/db2/db2hd1/db2_software".
saptest:db2hd1 6> db2 connect to hd1
Database Connection Information
Database server = DB2/AIX64 9.5.8
SQL authorization ID = DB2HD1
Local database alias = HD1
saptest:db2hd1 6> db2 " select viewnamefrom syscat.viewdep where
viewschema = 'SAPHD1' and bname = 'DD08L' "
VIEWNAME
--------------------------------------------------------------------------------------------------------------------------------
0 record(s) selected.
saptest:db2hd1 7> db2 " select viewnamefrom syscat.viewdep where
viewschema = 'SAPR3' and bname = 'DD08L' "
VIEWNAME
--------------------------------------------------------------------------------------------------------------------------------
0 record(s) selected.
saptest:db2hd1 10> db2 "select trigschema,trigname,tabschema,tabname
from syscat.triggers where tabname='DD08L'"
TRIGSCHEMA TRIGNAME TABSCHEMA TABNAME
SAPHD1 /1LT/00000443INS SAPHD1 DD08L
SAPHD1 /1LT/00000443UPD1 SAPHD1 DD08L
SAPHD1 /1LT/00000443DEL SAPHD1 DD08L
3 record(s) selected.
saptest:db2hd1 12> "drop trigger SAPHD1./1LT/00000441INS"
drop trigger SAPHD1./1LT/00000441INS: Command not found.
saptest:db2hd1 13> db2 "drop trigger SAPHD1./1LT/00000441INS"
DB21034E Thecommand was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0103N Thenumeric literal "1LT" is not valid. SQLSTATE=42604
saptest:db2hd1 14> db2 "drop view SAPHD1./1LT/00000441INS"
DB21034E Thecommand was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0103N Thenumeric literal "1LT" is not valid. SQLSTATE=42604