Remove LANSA Composer database tables from the earlier version
This procedure applies if you are upgrading from LANSA Composer version 4.0. It does not apply if you are installing LANSA Composer Server.
The database tables for LANSA Composer version 4.0 were contained in schema (or collection or owner) named F4XF3LIB.
The database tables for LANSA Composer version 5.0 are contained in schema (or collection or owner) named LC_DTA.
The LANSA Composer Windows Server installer will have created the version 5.0 database tables and copied the version 4.0 data into them. However, the version 4.0 database tables contained in schema F4XF3LIB will remain in the database, even though they are no longer used.
You should use your database management tool (for example MS ) to remove the schema F4XF3LIB and the database tables and views it contains.
Note: For future LANSA Composer versions, the schema name LC_DTA will always be used and this procedure will no longer be necessary.
The following is a sample SQL script that you may be able to copy and adapt to your database management system to perform this task. (The specific syntax required for your DBMS may vary from the sample script shown below)
USE [database-name];
DROP VIEW [F4XF3LIB].[DXCVV02_V];
DROP VIEW [F4XF3LIB].[MWBHFL3_V];
DROP TABLE [F4XF3LIB].[DX02];
DROP TABLE [F4XF3LIB].[DX62];
DROP TABLE [F4XF3LIB].[DXAG];
DROP TABLE [F4XF3LIB].[DXAP];
DROP TABLE [F4XF3LIB].[DXAR];
DROP TABLE [F4XF3LIB].[DXAT];
DROP TABLE [F4XF3LIB].[DXCV];
DROP TABLE [F4XF3LIB].[DXDB];
DROP TABLE [F4XF3LIB].[DXDC];
DROP TABLE [F4XF3LIB].[DXDX];
DROP TABLE [F4XF3LIB].[DXEN];
DROP TABLE [F4XF3LIB].[DXEV];
DROP TABLE [F4XF3LIB].[DXFA1];
DROP TABLE [F4XF3LIB].[DXFA2];
DROP TABLE [F4XF3LIB].[DXFC];
DROP TABLE [F4XF3LIB].[DXHC];
DROP TABLE [F4XF3LIB].[DXJM];
DROP TABLE [F4XF3LIB].[DXL1];
DROP TABLE [F4XF3LIB].[DXL2];
DROP TABLE [F4XF3LIB].[DXL3];
DROP TABLE [F4XF3LIB].[DXL4];
DROP TABLE [F4XF3LIB].[DXL5];
DROP TABLE [F4XF3LIB].[DXL6];
DROP TABLE [F4XF3LIB].[DXLK];
DROP TABLE [F4XF3LIB].[DXM2];
DROP TABLE [F4XF3LIB].[DXM9];
DROP TABLE [F4XF3LIB].[DXMAPWORK];
DROP TABLE [F4XF3LIB].[DXMFCAT0];
DROP TABLE [F4XF3LIB].[DXMFCAT1];
DROP TABLE [F4XF3LIB].[DXMFCAT2];
DROP TABLE [F4XF3LIB].[DXMFCAT3];
DROP TABLE [F4XF3LIB].[DXMFCAT4];
DROP TABLE [F4XF3LIB].[DXMFCAT5];
DROP TABLE [F4XF3LIB].[DXMFCAT6];
DROP TABLE [F4XF3LIB].[DXMP];
DROP TABLE [F4XF3LIB].[DXMS];
DROP TABLE [F4XF3LIB].[DXNN];
DROP TABLE [F4XF3LIB].[DXNT];
DROP TABLE [F4XF3LIB].[DXP1];
DROP TABLE [F4XF3LIB].[DXP2];
DROP TABLE [F4XF3LIB].[DXP3];
DROP TABLE [F4XF3LIB].[DXP4];
DROP TABLE [F4XF3LIB].[DXP5];
DROP TABLE [F4XF3LIB].[DXP6];
DROP TABLE [F4XF3LIB].[DXP7];
DROP TABLE [F4XF3LIB].[DXP8];
DROP TABLE [F4XF3LIB].[DXPC];
DROP TABLE [F4XF3LIB].[DXPRTCTL];
DROP TABLE [F4XF3LIB].[DXPV];
DROP TABLE [F4XF3LIB].[DXR1];
DROP TABLE [F4XF3LIB].[DXR2];
DROP TABLE [F4XF3LIB].[DXR3];
DROP TABLE [F4XF3LIB].[DXSD];
DROP TABLE [F4XF3LIB].[DXSD02];
DROP TABLE [F4XF3LIB].[DXSK];
DROP TABLE [F4XF3LIB].[DXSM];
DROP TABLE [F4XF3LIB].[DXSP];
DROP TABLE [F4XF3LIB].[DXSRC256];
DROP TABLE [F4XF3LIB].[DXST];
DROP TABLE [F4XF3LIB].[DXSV];
DROP TABLE [F4XF3LIB].[DXSY];
DROP TABLE [F4XF3LIB].[DXT2];
DROP TABLE [F4XF3LIB].[DXT3];
DROP TABLE [F4XF3LIB].[DXT4];
DROP TABLE [F4XF3LIB].[DXT5];
DROP TABLE [F4XF3LIB].[DXT9];
DROP TABLE [F4XF3LIB].[DXTG];
DROP TABLE [F4XF3LIB].[DXTP];
DROP TABLE [F4XF3LIB].[DXTXT1];
DROP TABLE [F4XF3LIB].[DXX1EN];
DROP TABLE [F4XF3LIB].[DXX2IN];
DROP TABLE [F4XF3LIB].[DXX3GP];
DROP TABLE [F4XF3LIB].[DXX4MS];
DROP TABLE [F4XF3LIB].[DXX5AK];
DROP TABLE [F4XF3LIB].[DXXDCT];
DROP TABLE [F4XF3LIB].[DXXDSHF1];
DROP TABLE [F4XF3LIB].[DXXDST];
DROP TABLE [F4XF3LIB].[DXXDTR];
DROP TABLE [F4XF3LIB].[DXXECN];
DROP TABLE [F4XF3LIB].[DXXH];
DROP TABLE [F4XF3LIB].[DXXI];
DROP TABLE [F4XF3LIB].[DXXJ];
DROP TABLE [F4XF3LIB].[DXXSQN];
DROP TABLE [F4XF3LIB].[DXXTNLOG];
DROP TABLE [F4XF3LIB].[DXXTNREG];
DROP TABLE [F4XF3LIB].[DXXTNVLR];
DROP TABLE [F4XF3LIB].[EDI810IT1];
DROP TABLE [F4XF3LIB].[EDI810IT1P];
DROP TABLE [F4XF3LIB].[EDI810IT1R];
DROP TABLE [F4XF3LIB].[EDI810IT1S];
DROP TABLE [F4XF3LIB].[EDI810IT1T];
DROP TABLE [F4XF3LIB].[EDI810ITD];
DROP TABLE [F4XF3LIB].[EDI810MSG];
DROP TABLE [F4XF3LIB].[EDI810N1];
DROP TABLE [F4XF3LIB].[EDI810REF];
DROP TABLE [F4XF3LIB].[EDI810SAC];
DROP TABLE [F4XF3LIB].[EDI810TXI];
DROP TABLE [F4XF3LIB].[EDI850FOB];
DROP TABLE [F4XF3LIB].[EDI850MSG];
DROP TABLE [F4XF3LIB].[EDI850N1];
DROP TABLE [F4XF3LIB].[EDI850N1RF];
DROP TABLE [F4XF3LIB].[EDI850PER];
DROP TABLE [F4XF3LIB].[EDI850PO1];
DROP TABLE [F4XF3LIB].[EDI850PO1M];
DROP TABLE [F4XF3LIB].[EDI850REF];
DROP TABLE [F4XF3LIB].[EDI850TD5];
DROP TABLE [F4XF3LIB].[EDI855MSG];
DROP TABLE [F4XF3LIB].[EDI855N1];
DROP TABLE [F4XF3LIB].[EDI855PO1];
DROP TABLE [F4XF3LIB].[EDI855REF];
DROP TABLE [F4XF3LIB].[EDI997AK2];
DROP TABLE [F4XF3LIB].[EDI997AK3];
DROP TABLE [F4XF3LIB].[EDI997AK4];
DROP TABLE [F4XF3LIB].[EDI997MSG];
DROP TABLE [F4XF3LIB].[MWBDF];
DROP TABLE [F4XF3LIB].[MWBHF];
DROP TABLE [F4XF3LIB].[TUTORDH];
DROP TABLE [F4XF3LIB].[TUTORDL];
DROP SCHEMA [F4XF3LIB];
When you have finished, continue with: