Vizag Legend(STG_CUSTOMER_PROFILE)

[srini84]

SESSIONS 5;
RECORD 1 THRU 100;
TENACITY 5;
SLEEP 5;
ERRLIMIT 50;
.logon tdp6/POC_ETLUSER,POC_ETLUSER;
delete from POC_WORKDB.STG_CUSTOMER_PROFILE all;
DROP TABLE POC_WORKDB.STG_CUSTOMER_PROFILE_WT;
DROP TABLE POC_WORKDB.STG_CUSTOMER_PROFILE_ET;
DROP TABLE POC_WORKDB.STG_CUSTOMER_PROFILE_UV;

.SET RECORD VARTEXT "|";

DEFINE

SUB_CD (VARCHAR (40)),
MSISDN_CD (VARCHAR (22)),
VERSION_NUM (VARCHAR (10)),
ACTUAL_FG (VARCHAR (10)),
PORTED_FG (VARCHAR (10)),
ACCOUNT_CD (VARCHAR (20)),
MNO_ID (VARCHAR (10)),
MVNO_ID (VARCHAR (10)),
ACTIVE_FG (VARCHAR (10)),
MARKET_ID (VARCHAR (10)),
CUST_TYPE_ID (VARCHAR (10)),
RACE_ID (VARCHAR (10)),
ZIP_CD (VARCHAR (10)),
AGE (VARCHAR (10)),
GENDER (VARCHAR (10)),
BILL_PLAN (VARCHAR (90)),
IC_NO (VARCHAR (20)),
NATIONALITY (VARCHAR (20)),
DEALER_CD (VARCHAR (20)),
ACTIVATION_DT (VARCHAR (19)) ,
VALID_FROM_DT (VARCHAR (19)),
VALID_UNTIL_DT (VARCHAR(19))

FILE= / root /storage;

SHOW;
BEGIN LOADING POC_WORKDB.STG_CUSTOMER_PROFILE ERRORFILES
POC_WORKDB.STG_CUSTOMER_PROFILE_ET,POC_WORKDB.STG_CUSTOMER_PROFILE_UV
CHECKPOINT 1000;
INSERT INTO POC_WORKDB.STG_CUSTOMER_PROFILE VALUES(
:SUB_CD,
:MSISDN_CD,
:VERSION_NUM,
:ACTUAL_FG,
ORTED_FG,
:ACCOUNT_CD,
:MNO_ID,
:MVNO_ID,
:ACTIVE_FG,
:MARKET_ID,
:CUST_TYPE_ID,
:RACE_ID,
:ZIP_CD,
:AGE,
:GENDER,
:BILL_PLAN,
:IC_NO,
:NATIONALITY,
EALER_CD,
:ACTIVATION_DT,
:VALID_FROM_DT,
:VALID_UNTIL_DT


);

END LOADING;
.LOGOFF;
.QUIT;