Vizag Legend(STG_MSC_CDR)

[srini84]

SESSIONS 5;
RECORD 1 THRU 100;
TENACITY 5;
SLEEP 5;
ERRLIMIT 50;
.logon tdp6/POC_ETLUSER,POC_ETLUSER;
delete from POC_WORKDB.STG_MSC_CDR all;
DROP TABLE POC_WORKDB.STG_MSC_CDR_WT;
DROP TABLE POC_WORKDB.STG_MSC_CDR_ET;
DROP TABLE POC_WORKDB.STG_MSC_CDR_UV;

.SET RECORD VARTEXT "|";

DEFINE

Structure (VARCHAR (20)),
Record_ID (VARCHAR (20)),
Call_Type (VARCHAR (10)),
Charge_Amount (VARCHAR (10)),
Calling_IMSI (VARCHAR (30)),
A_TON (VARCHAR (10)),
A_NPI (VARCHAR (10)),
A_Subscriber (VARCHAR (22)),
Called_IMSI (VARCHAR (30)),
B_TON (VARCHAR (10)),
B_NPI (VARCHAR (10)),
B_Subscriber (VARCHAR (22)),
Redirecting_IMSI (VARCHAR (30)),
C_TON (VARCHAR (10)),
C_NPI (VARCHAR (10)),
C_Subscriber (VARCHAR (22)),
DateForStartOfCharge (VARCHAR (19)),
TimeForStartOfCharge (VARCHAR (19)),
ChargeableUnit (VARCHAR (10)),
UsageUnit (VARCHAR (10)),
O_MSC_ID (VARCHAR (20)),
D_MSC_ID (VARCHAR (20)),
CalledCellId (VARCHAR (10)),
CallingCellId (VARCHAR (10)),
BearerService (VARCHAR (10)),
TeleService (VARCHAR (10)),
Incoming_Route (VARCHAR (20)),
Outgoing_Route (VARCHAR (20)),
Tariff_Class (VARCHAR (20)),
Channel_Rate (VARCHAR (10)),
Transparency (VARCHAR (10)),
CallingIMEI (VARCHAR (30)),
CalledIMEI (VARCHAR (30)),
CUG_Index (VARCHAR (10)),
CUG_Interlock_Code (VARCHAR(10)),
CUG_Outgoing_Indicator (VARCHAR (10)),
Cause_of_Call_End (VARCHAR(10)),
MSR_TON (VARCHAR(10)),
MSR_NPI (VARCHAR(10)),
MSR_Number (VARCHAR(22)),
SS_Code (VARCHAR(10)),
SS_Request (VARCHAR(10)),
Rerouting_Indicator (VARCHAR (10)),
Subscriber_Service_Indicator (VARCHAR (10)),
Roamer_Indicator (VARCHAR (10)),
AB_PartyCallHoldIndicator (VARCHAR (10)),
AB_PartyMultiPartyIndicator (VARCHAR (10))


FILE= / root /storage;

SHOW;
BEGIN LOADING POC_WORKDB.STG_MSC_CDR ERRORFILES
POC_WORKDB.STG_MSC_CDR_ET,POC_WORKDB.STG_MSC_CDR_UV
CHECKPOINT 1000;
INSERT INTO POC_WORKDB.STG_MSC_CDR VALUES(
:Structure,
:Record_ID,
:Call_Type,
:Charge_Amount,
:Calling_IMSI,
:A_TON,
:A_NPI,
:A_Subscriber,
:Called_IMSI,
:B_TON,
:B_NPI,
:B_Subscriber,
:Redirecting_IMSI,
:C_TON,
:C_NPI,
:C_Subscriber,
ateForStartOfCharge,
:TimeForStartOfCharge,
:ChargeableUnit,
:UsageUnit,
:O_MSC_ID,
_MSC_ID,
:CalledCellId,
:CallingCellId,
:BearerService,
:TeleService,
:Incoming_Route,
:Outgoing_Route,
:Tariff_Class,
:Channel_Rate,
:Transparency,
:CallingIMEI,
:CalledIMEI,
:CUG_Index,
:CUG_Interlock_Code,
:CUG_Outgoing_Indicator,
:Cause_of_Call_End,
:MSR_TON,
:MSR_NPI,
:MSR_Number,
:SS_Code,
:SS_Request,
:Rerouting_Indicator,
:Subscriber_Service_Indicator,
:Roamer_Indicator,
:AB_PartyCallHoldIndicator,
:AB_PartyMultiPartyIndicator,


);

END LOADING;
.LOGOFF;
.QUIT;