Vizag Legend(STG_Amdocs)

[srini84]

SESSIONS 5;
RECORD 1 THRU 100;
TENACITY 5;
SLEEP 5;
ERRLIMIT 50;
.logon tdp6/POC_ETLUSER,POC_ETLUSER;
delete from POC_WORKDB.STG_Amdocs all;
DROP TABLE POC_WORKDB.STG_Amdocs_WT;
DROP TABLE POC_WORKDB.STG_Amdocs_ET;
DROP TABLE POC_WORKDB.STG_Amdocs_UV;

.SET RECORD VARTEXT "|";

DEFINE

CASE_TYPE_LVL1 (VARCHAR (30))
CASE_TYPE_LVL2 (VARCHAR (30)),
CASE_TYPE_LVL3 (VARCHAR (30)),
CREATION_TIME (VARCHAR (19)),
HANGUP_TIME (VARCHAR (19)),
ID_NUMBER (VARCHAR (30)),
MODIFY_STMP (VARCHAR (19)),
PHONE_NUM (VARCHAR (22)),
S_TITLE (VARCHAR (100)),
S_X_PROD_SUBTYPE (VARCHAR (30)),
S_X_PROD_TYPE (VARCHAR (20)),
X_ALT_CALLER_NAME (VARCHAR (50)),
X_ARBOR_ORDER_TRX_DT (VARCHAR (19)),
X_CASE_ELEMENT (VARCHAR (50)),
X_CASE_SUBTYPE (VARCHAR (30)),
X_CCNUM (VARCHAR (20)),
X_CHANNEL (VARCHAR (20)),
X_CURRENT_REOPEN_DT (VARCHAR (19)),
X_CYCLE_TIME (VARCHAR (10)),
X_REOPENED (VARCHAR (10)),
X_SERVICE_NUM (VARCHAR (19)),
X_IS_FCR (VARCHAR (10)),
X_OCS_TRANS_NUM (VARCHAR (20)),
X_PAYAMT (VARCHAR (10)),
X_PROB_CATEGORY (VARCHAR (20))

FILE= / root /storage;

SHOW;
BEGIN LOADING POC_WORKDB.STG_Amdocs ERRORFILES
POC_WORKDB.STG_Amdocs_ET,POC_WORKDB.STG_Amdocs_UV
CHECKPOINT 1000;
INSERT INTO POC_WORKDB.STG_Amdocs VALUES(
:CASE_TYPE_LVL1,
:CASE_TYPE_LVL2,
:CASE_TYPE_LVL3,
:CREATION_TIME,
:HANGUP_TIME,
:ID_NUMBER,
:MODIFY_STMP,
HONE_NUM,
:S_TITLE,
:S_X_PROD_SUBTYPE,
:S_X_PROD_TYPE,
:X_ALT_CALLER_NAME,
:X_ARBOR_ORDER_TRX_DT,
:X_CASE_ELEMENT,
:X_CASE_SUBTYPE,
:X_CCNUM,
:X_CHANNEL,
:X_CURRENT_REOPEN_DT,
:X_CYCLE_TIME,
:X_REOPENED,
:X_SERVICE_NUM,
:X_IS_FCR,
:X_OCS_TRANS_NUM,
:X_PAYAMT,
:X_PROB_CATEGORY

);

END LOADING;
.LOGOFF;
.QUIT;