LOAD DATA LOCAL INFILE '/$FilePath/$FileName'
REPLACE
INTO TABLE $TableName
FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '\"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES
*********************************************************************************
LOAD DATA LOCAL INFILE '/vol2/HCC_DATA/COVENTRY/201507/HCC_Report_Existing_Lost_201507_460-74-9142.csv'
REPLACE
INTO TABLE imports_payer_data.cov_member_hccs_raw_table
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES (msotin,msonam,membno,lname,fname,dob,gender,eff_date,category,sort_order,hcc1,hcc2,hcc3,hcc4,hcc5,hcc6,hcc7,hcc8,hcc9,hcc10,hcc11,hcc12,hcc13,hcc14,hcc15, hcc16, hcc17, hcc18, hcc19, hcc20, hcc21, planid, medprac, provno, pcp_name, gpaparent, adrln1, adrln2, citycd, stacod, zipcod, pcp_county, current_period_begin, current_period_end, datestamp, hic, @received_date) SET received_date = now()
***********************************************************************************
REPLACE
INTO TABLE $TableName
FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '\"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES
*********************************************************************************
LOAD DATA LOCAL INFILE '/vol2/HCC_DATA/COVENTRY/201507/HCC_Report_Existing_Lost_201507_460-74-9142.csv'
REPLACE
INTO TABLE imports_payer_data.cov_member_hccs_raw_table
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES (msotin,msonam,membno,lname,fname,dob,gender,eff_date,category,sort_order,hcc1,hcc2,hcc3,hcc4,hcc5,hcc6,hcc7,hcc8,hcc9,hcc10,hcc11,hcc12,hcc13,hcc14,hcc15, hcc16, hcc17, hcc18, hcc19, hcc20, hcc21, planid, medprac, provno, pcp_name, gpaparent, adrln1, adrln2, citycd, stacod, zipcod, pcp_county, current_period_begin, current_period_end, datestamp, hic, @received_date) SET received_date = now()
***********************************************************************************
0 comments:
Post a Comment