The following script can be used to clear the TConnectEDI999 database. It should only be used in a non-production environment as it will delete all files processed in the TConnectEDI999 database. The How to Clear the Tctep Database article details the process to clear the TctepDb database, and in turn removing traces of the file's history from the Gateway Portal.
Note: the script may need to be executed multiple times to clear all tables due to key constraints
Use TConnectEDI999
GO
DELETE FROM dbo.OutboundStage_Failures
DELETE FROM EDI999.EdiXml
DELETE FROM EDI999.EDIFileInformation
DELETE FROM EDI999.EDI999_Seg_CTX_Seg1
DELETE FROM EDI999.EDI999_L2110_Loop
DELETE FROM EDI999.EDI999_L2110_CTX_Ele
DELETE FROM EDI999.EDI999_L2100_Loop
DELETE FROM EDI999.EDI999_L2100_CTX_Seg
DELETE FROM EDI999.EDI999_L2100_CTX_BU1
DELETE FROM EDI999.EDI999_L2000_Loop
DELETE FROM EDI999.EDI999_L1000_Loop
DELETE FROM EDI999.EDI999_Ele_CTX_Ele1