2463049 - SQL0428N The SQL statement is only allowed as the first statement in a unit of work.

• Error can occur during SUM/DMO upgrade in phase RUN_SMIGRCREATEDDL_740(RSUPG_SMIGR_CREATE_DDL.SID):
  A3EERS_UPG_TOOL 215 No DB Version provided!"MIGRDDL"
• The following error is found in the developer work process trace file dev_w*:
• SQL0428N  The SQL statement is only allowed as the first statement in a unit of work.  SQLSTATE=25001
  TRUNCATE TABLE "MIGRDDL" REUSE STORAGE RESTRICT WHEN DELETE TRIGGERS IMMEDIATE      LOCATION( SAPLSDB2 , 00000 ) -
   - SYSTEM( SID , SAPSID )
  ABAP location info 'SAPLSDB2', 00000
  C  *** ERROR in ExecuteDirect[dbdb6.c, 17199] (END)
  B  ***LOG BY2=> sql error -428       performing EXE        [dbds#1 @ 691] [dbds    0691 ]
  B  ***LOG BY0=> SQL0428N  The SQL statement is only allowed as the first statement in a unit of work.  SQLSTATE=25001 [dbds#1 @ 691]
  B  ***LOG BY2=> sql error -428       performing EXE        [dbacds#2 @ 893] [dbacds  0893 ]

DB2 for LUW database releases:

upgrade, DMO, SUM, sluigui, BW_SMIGRCREDDL.ELG, RS_UPG_SMIGR_CREATE_DDL, migration, truncate, disp+work , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem