Vizag Legend(STG_Churners)

[srini84]

SESSIONS 5;
RECORD 1 THRU 100;
TENACITY 5;
SLEEP 5;
ERRLIMIT 50;
.logon tdp6/POC_ETLUSER,POC_ETLUSER;
delete from POC_WORKDB.STG_Churners all;
DROP TABLE POC_WORKDB.STG_Churners_WT;
DROP TABLE POC_WORKDB.STG_Churners_ET;
DROP TABLE POC_WORKDB.STG_Churners_UV;

.SET RECORD VARTEXT "|";

DEFINE

MSISDN_ID (VARCHAR (22)),
LANGUAGE_PREF (VARCHAR (20)),
TEST_SUB_IND (VARCHAR (10)),
BRAND (VARCHAR (20)),
CALL_GROUP (VARCHAR (10)),
SUBS_STATE (VARCHAR (20)),
ACTIVATION_DATE (VARCHAR (40)),
CREDIT_EXP_DATE (VARCHAR (19)),
RECHARGE_ONLY_DATE (VARCHAR (19)),
DEACTIVATION_DATE (VARCHAR (19)),
LAST_RECHARGE_DATE (VARCHAR(40)),
NO_CREDIT_DATE (VARCHAR (40)),
TOTAL_CALLS_MADE (VARCHAR (10)),
TOTAL_CALLS_SUCCESS (VARCHAR (10)),
CREDIT_REMAINING (VARCHAR (10)),
PACKAGE_TYPE (VARCHAR (90)),
REGION (VARCHAR (80)),
PRODUCT (VARCHAR (20)),
NETWORK_USAGE (VARCHAR (8)),
SHELF_EXPIRY_DATE (VARCHAR (19)),
STATUS_DATE (VARCHAR (19)),
DATA_DATE (VARCHAR (19)),
SUB_STATE (VARCHAR(30)),
DISTRIBUTOR_NAME (VARCHAR(100))



FILE= / root /storage;

SHOW;
BEGIN LOADING POC_WORKDB.STG_Churners ERRORFILES
POC_WORKDB.STG_Churners_ET,POC_WORKDB.STG_Churners_UV
CHECKPOINT 1000;
INSERT INTO POC_WORKDB.STG_Churners VALUES(
:MSISDN_ID,
:LANGUAGE_PREF,
:TEST_SUB_IND,
:BRAND,
:CALL_GROUP,
:SUBS_STATE,
:ACTIVATION_DATE,
:CREDIT_EXP_DATE,
:RECHARGE_ONLY_DATE,
EACTIVATION_DATE,
:LAST_RECHARGE_DATE,
:NO_CREDIT_DATE,
:TOTAL_CALLS_MADE,
:TOTAL_CALLS_SUCCESS,
:CREDIT_REMAINING,
ACKAGE_TYPE,
:REGION,
RODUCT,
:NETWORK_USAGE,
:SHELF_EXPIRY_DATE,
:STATUS_DATE,
ATA_DATE,
:SUB_STATE,
ISTRIBUTOR_NAME


);

END LOADING;
.LOGOFF;
.QUIT;