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

    ERROR: Detected the following errors:# /media/SP702/SUM/SUM/abap/log/EU_SWITCH03.XUT: 2 ETQ399 Connecting todatabase 'db6'. 3 ETQ398 SQL: RENAME "DD08L" TO "DD08L~~OLD" 4 ETQ010Date & 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 isreferenced 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: 201505110907511 ETQ000 ==================================================4 ETQ010 Date &…

    SQL0750N in the upgrade during conversion,how drop trigger?

    Very Helpfull

    User Rating: Be the first one !
    Add Comment
    1 Answer(s)

      Dear all,

       

      I use the DB2 control center drop trigger,this problem has been solved.

       

      Thanks for all the replies!

      Best regards!

      Kong

      Add Comment

        Dear all,

         

        I use the DB2 control center drop trigger,this problem has been solved.

         

        Thanks for all the replies!

        Best regards!

        Kong

        Add Comment

        Your Answer

        By posting your answer, you agree to the privacy policy and terms of service.