analytics/informix/etc/dropcdr.sql

--
--
--  Licensed Materials - Property of IBM and/or HCL
--
--  IBM Informix Dynamic Server
--  (c) Copyright IBM Corporation 1996, 2004 All rights reserved.
--  (c) Copyright HCL Technologies Ltd. 2017.  All Rights Reserved.
--
--
--
--   Title:  dropcdr.sql
--
--   For internal use only
--	N.B. - Commands should be in lowercase only
--

database sysmaster;

drop view syscdrhost;
drop view syscdrserver;
drop view syscdrerror;
drop view syscdrgrp;
drop procedure bityesno;
drop procedure replfloattype;
drop procedure replid2Name;
drop procedure bitrow;
drop view syscdrrepl;
drop view syscdrreplset;
drop view syscdrpart;
drop view syscdrqueued;
drop view syscdrtxproc;

delete from flags_text where tabname = 'cdrstate';

delete from flags_text where tabname = 'cdr_rsncjob_state';

close database;