Fastload error: I/O Error on File Open 34

Tools

Fastload error: I/O Error on File Open 34

I have a large text file with 366 columns, pipe delimited.   Fastload fails with this error: Error : I/O Error on File Open: 34, Text: pmUnxDskOpen: fopen error (Invalid argument)

This is this script being run:

SHOW VERSION;

SESSIONS 4;

ERRLIMIT 500;

RUN file C:\scripts\fastload_logon.prn;

DATABASE HP_MU_OWN_TABLES;

DROP TABLE NPI_DOWNLOAD_ERROR1;

DROP TABLE NPI_DOWNLOAD_ERROR2;

DROP TABLE HP_MU_OWN_TABLES.dim_NPI_BAK;

CREATE MULTISET TABLE HP_MU_OWN_TABLES.dim_NPI_BAK ,NO FALLBACK ,

NO BEFORE JOURNAL,

NO AFTER JOURNAL,

CHECKSUM = DEFAULT,

DEFAULT MERGEBLOCKRATIO

(

NPI VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

ENTITY_TYPE_CODE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

REPLACEMENT_NPI VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

EIN VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_ORGANIZATION_LEGAL_BUSINE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_LAST_NAME VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_FIRST_NAME VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_MIDDLE_NAME VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_NAME_PREFIX VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_NAME_SUFFIX VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_CREDENTIAL_TEXT VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_OTHER_ORGANIZATION VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_OTHER_ORGANIZATION_CODE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_OTHER_LAST_NAME VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_OTHER_FIRST_NAME VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_OTHER_MIDDLE_NAME VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_OTHER_NAME_PREFIX VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_OTHER_NAME_SUFFIX VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_OTHER_CREDENTIAL VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_OTHER_LAST_NAME_CODE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_FIRST_LINE_BUSINESS_MAILI VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_SECOND_LINE_BUSINESS_MAIL VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_BUSINESS_MAILING_CITY VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_BUSINESS_MAILING_STATE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_BUSINESS_MAILING_POSTAL_C VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_BUSINESS_MAILING_COUNTRY VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_BUSINESS_MAILING_TELEPHON VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_BUSINESS_MAILING_FAX VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_FIRST_LINE_BUSINESS_LOCAT VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_SECOND_LINE_BUSINESS_LOCA VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_BUSINESS_PRACTICE_CITY VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_BUSINESS_PRACTICE_STATE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_BUSINESS_PRACTICE_POSTAL_ VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_BUSINESS_PRACTICE_COUNTRY VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_BUSINESS_PRACTICE_TELEPHO VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_BUSINESS_PRACTICE_FAX VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_ENUMERATION_DATE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

LAST_UPDATE_DATE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

NPI_DEACTIVATION_REASON_CODE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

NPI_DEACTIVATION_DATE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

NPI_REACTIVATION_DATE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_GENDER_CODE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

AUTHORIZED_OFFICIAL_LAST_NAME VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

AUTHORIZED_OFFICIAL_FIRST_NAME VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

AUTHORIZED_OFFICIAL_MIDDLE_NAM VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

AUTHORIZED_OFFICIAL_TITLE_OR_P VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

AUTHORIZED_OFFICIAL_TELEPHONE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

HLTHCARE_PROV_TAXO_CODE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_LIC_NBR VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_LIC_NBR_STATE_CODE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

HLTHCARE_PROV_PRIM_TAXO_SW VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

HLTHCARE_PROV_TAXO_CODE_2 VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_LIC_NBR_2 VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_LIC_NBR_STATE_CODE_2 VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

HLTHCARE_PROV_PRIM_TAXO_SW_2 VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

HLTHCARE_PROV_TAXO_CODE_3 VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_LIC_NBR_3 VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_LIC_NBR_STATE_CODE_3 VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

HLTHCARE_PROV_PRIM_TAXO_SW_3 VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

HLTHCARE_PROV_TAXO_CODE_4 VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_LIC_NBR_4 VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_LIC_NBR_STATE_CODE_4 VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

HLTHCARE_PROV_PRIM_TAXO_SW_4 VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

HLTHCARE_PROV_TAXO_CODE_5 VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_LIC_NBR_5 VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PROV_LIC_NBR_STATE_CODE_5 VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

HLTHCARE_PROV_PRIM_TAXO_SW_5 VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

OTHER_PROV_IDENTIFIER VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

OTHER_PROV_IDENTIFIER_TYPE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

OTHER_PROV_IDENTIFIER_STATE VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

OTHER_PROV_IDENTIFIER_ISSUER VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

IS_SOLE_PROPRIETOR VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

IS_ORGANIZATION_SUBPART VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PARENT_ORGANIZATION_LBN VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

PARENT_ORGANIZATION_TIN VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

HEALTHCARE_PROV_TAXONOMY_GROUP VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,

MAILING_ZIP5 VARCHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC,

PRACTICE_ZIP5 VARCHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC)

PRIMARY INDEX ( NPI );

SET RECORD VARTEXT DELIMITER '|';

DEFINE

NPI001_NPI  (VARCHAR(128)), 

NPI002_Entity_Type_Code  (VARCHAR(128)), 

NPI003_Replacement_NPI  (VARCHAR(128)), 

NPI004_Employer_Identification_Number_EIN  (VARCHAR(128)), 

NPI005_Provider_Organization_Name_Legal_Business_Name  (VARCHAR(128)), 

NPI006_Provider_Last_Name_Legal_Name  (VARCHAR(128)), 

NPI007_Provider_First_Name  (VARCHAR(128)), 

NPI008_Provider_Middle_Name  (VARCHAR(128)), 

NPI009_Provider_Name_Prefix_Text  (VARCHAR(128)), 

NPI010_Provider_Name_Suffix_Text  (VARCHAR(128)), 

NPI011_Provider_Credential_Text  (VARCHAR(128)), 

NPI012_Provider_Other_Organization_Name  (VARCHAR(128)), 

NPI013_Provider_Other_Organization_Name_Type_Code  (VARCHAR(128)), 

NPI014_Provider_Other_Last_Name  (VARCHAR(128)), 

NPI015_Provider_Other_First_Name  (VARCHAR(128)), 

NPI016_Provider_Other_Middle_Name  (VARCHAR(128)), 

NPI017_Provider_Other_Name_Prefix_Text  (VARCHAR(128)), 

NPI018_Provider_Other_Name_Suffix_Text  (VARCHAR(128)), 

NPI019_Provider_Other_Credential_Text  (VARCHAR(128)), 

NPI020_Provider_Other_Last_Name_Type_Code  (VARCHAR(128)), 

NPI021_Provider_First_Line_Business_Mailing_Address  (VARCHAR(128)), 

NPI022_Provider_Second_Line_Business_Mailing_Address  (VARCHAR(128)), 

NPI023_Provider_Business_Mailing_Address_City_Name  (VARCHAR(128)), 

NPI024_Provider_Business_Mailing_Address_State_Name  (VARCHAR(128)), 

NPI025_Provider_Business_Mailing_Address_Postal_Code  (VARCHAR(128)), 

NPI026_Provider_Business_Mailing_Address_Country_Code  (VARCHAR(128)), 

NPI027_Provider_Business_Mailing_Address_Telephone_Number  (VARCHAR(128)), 

NPI028_Provider_Business_Mailing_Address_Fax_Number  (VARCHAR(128)), 

NPI029_Provider_First_Line_Business_Practice_Location_Address  (VARCHAR(128)), 

NPI030_Provider_Second_Line_Business_Practice_Location_Address  (VARCHAR(128)), 

NPI031_Provider_Business_Practice_Location_Address_City_Name  (VARCHAR(128)), 

NPI032_Provider_Business_Practice_Location_Address_State_Name  (VARCHAR(128)), 

NPI033_Provider_Business_Practice_Location_Address_Postal_Code  (VARCHAR(128)), 

NPI034_Provider_Business_Practice_Location_Address_Country_Code  (VARCHAR(128)), 

NPI035_Provider_Business_Practice_Location_Address_Telephone_Number  (VARCHAR(128)), 

NPI036_Provider_Business_Practice_Location_Address_Fax_Number  (VARCHAR(128)), 

NPI037_Provider_Enumeration_Date  (VARCHAR(128)), 

NPI038_Last_Update_Date  (VARCHAR(128)), 

NPI039_NPI_Deactivation_Reason_Code  (VARCHAR(128)), 

NPI040_NPI_Deactivation_Date  (VARCHAR(128)), 

NPI041_NPI_Reactivation_Date  (VARCHAR(128)), 

NPI042_Provider_Gender_Code  (VARCHAR(128)), 

NPI043_Authorized_Official_Last_Name  (VARCHAR(128)), 

NPI044_Authorized_Official_First_Name  (VARCHAR(128)), 

NPI045_Authorized_Official_Middle_Name  (VARCHAR(128)), 

NPI046_Authorized_Official_Title_or_Position  (VARCHAR(128)), 

NPI047_Authorized_Official_Telephone_Number  (VARCHAR(128)), 

NPI048_Healthcare_Provider_Taxonomy_Code_1  (VARCHAR(128)), 

NPI049_Provider_License_Number_1  (VARCHAR(128)), 

NPI050_Provider_License_Number_State_Code_1  (VARCHAR(128)), 

NPI051_Healthcare_Provider_Primary_Taxonomy_Switch_1  (VARCHAR(128)), 

NPI052_Healthcare_Provider_Taxonomy_Code_2  (VARCHAR(128)), 

NPI053_Provider_License_Number_2  (VARCHAR(128)), 

NPI054_Provider_License_Number_State_Code_2  (VARCHAR(128)), 

NPI055_Healthcare_Provider_Primary_Taxonomy_Switch_2  (VARCHAR(128)), 

NPI056_Healthcare_Provider_Taxonomy_Code_3  (VARCHAR(128)), 

NPI057_Provider_License_Number_3  (VARCHAR(128)), 

NPI058_Provider_License_Number_State_Code_3  (VARCHAR(128)), 

NPI059_Healthcare_Provider_Primary_Taxonomy_Switch_3  (VARCHAR(128)), 

NPI060_Healthcare_Provider_Taxonomy_Code_4  (VARCHAR(128)), 

NPI061_Provider_License_Number_4  (VARCHAR(128)), 

NPI062_Provider_License_Number_State_Code_4  (VARCHAR(128)), 

NPI063_Healthcare_Provider_Primary_Taxonomy_Switch_4  (VARCHAR(128)), 

NPI064_Healthcare_Provider_Taxonomy_Code_5  (VARCHAR(128)), 

NPI065_Provider_License_Number_5  (VARCHAR(128)), 

NPI066_Provider_License_Number_State_Code_5  (VARCHAR(128)), 

NPI067_Healthcare_Provider_Primary_Taxonomy_Switch_5  (VARCHAR(128)), 

NPI068_Healthcare_Provider_Taxonomy_Code_6  (VARCHAR(128)), 

NPI069_Provider_License_Number_6  (VARCHAR(128)), 

NPI070_Provider_License_Number_State_Code_6  (VARCHAR(128)), 

NPI071_Healthcare_Provider_Primary_Taxonomy_Switch_6  (VARCHAR(128)), 

NPI072_Healthcare_Provider_Taxonomy_Code_7  (VARCHAR(128)), 

NPI073_Provider_License_Number_7  (VARCHAR(128)), 

NPI074_Provider_License_Number_State_Code_7  (VARCHAR(128)), 

NPI075_Healthcare_Provider_Primary_Taxonomy_Switch_7  (VARCHAR(128)), 

NPI076_Healthcare_Provider_Taxonomy_Code_8  (VARCHAR(128)), 

NPI077_Provider_License_Number_8  (VARCHAR(128)), 

NPI078_Provider_License_Number_State_Code_8  (VARCHAR(128)), 

NPI079_Healthcare_Provider_Primary_Taxonomy_Switch_8  (VARCHAR(128)), 

NPI080_Healthcare_Provider_Taxonomy_Code_9  (VARCHAR(128)), 

NPI081_Provider_License_Number_9  (VARCHAR(128)), 

NPI082_Provider_License_Number_State_Code_9  (VARCHAR(128)), 

NPI083_Healthcare_Provider_Primary_Taxonomy_Switch_9  (VARCHAR(128)), 

NPI084_Healthcare_Provider_Taxonomy_Code_10  (VARCHAR(128)), 

NPI085_Provider_License_Number_10  (VARCHAR(128)), 

NPI086_Provider_License_Number_State_Code_10  (VARCHAR(128)), 

NPI087_Healthcare_Provider_Primary_Taxonomy_Switch_10  (VARCHAR(128)), 

NPI088_Healthcare_Provider_Taxonomy_Code_11  (VARCHAR(128)), 

NPI089_Provider_License_Number_11  (VARCHAR(128)), 

NPI090_Provider_License_Number_State_Code_11  (VARCHAR(128)), 

NPI091_Healthcare_Provider_Primary_Taxonomy_Switch_11  (VARCHAR(128)), 

NPI092_Healthcare_Provider_Taxonomy_Code_12  (VARCHAR(128)), 

NPI093_Provider_License_Number_12  (VARCHAR(128)), 

NPI094_Provider_License_Number_State_Code_12  (VARCHAR(128)), 

NPI095_Healthcare_Provider_Primary_Taxonomy_Switch_12  (VARCHAR(128)), 

NPI096_Healthcare_Provider_Taxonomy_Code_13  (VARCHAR(128)), 

NPI097_Provider_License_Number_13  (VARCHAR(128)), 

NPI098_Provider_License_Number_State_Code_13  (VARCHAR(128)), 

NPI099_Healthcare_Provider_Primary_Taxonomy_Switch_13  (VARCHAR(128)), 

NPI100_Healthcare_Provider_Taxonomy_Code_14  (VARCHAR(128)), 

NPI101_Provider_License_Number_14  (VARCHAR(128)), 

NPI102_Provider_License_Number_State_Code_14  (VARCHAR(128)), 

NPI103_Healthcare_Provider_Primary_Taxonomy_Switch_14  (VARCHAR(128)), 

NPI104_Healthcare_Provider_Taxonomy_Code_15  (VARCHAR(128)), 

NPI105_Provider_License_Number_15  (VARCHAR(128)), 

NPI106_Provider_License_Number_State_Code_15  (VARCHAR(128)), 

NPI107_Healthcare_Provider_Primary_Taxonomy_Switch_15  (VARCHAR(128)), 

NPI108_Other_Provider_Identifier_1  (VARCHAR(128)), 

NPI109_Other_Provider_Identifier_Type_Code_1  (VARCHAR(128)), 

NPI110_Other_Provider_Identifier_State_1  (VARCHAR(128)), 

NPI111_Other_Provider_Identifier_Issuer_1  (VARCHAR(128)), 

NPI112_Other_Provider_Identifier_2  (VARCHAR(128)), 

NPI113_Other_Provider_Identifier_Type_Code_2  (VARCHAR(128)), 

NPI114_Other_Provider_Identifier_State_2  (VARCHAR(128)), 

NPI115_Other_Provider_Identifier_Issuer_2  (VARCHAR(128)), 

NPI116_Other_Provider_Identifier_3  (VARCHAR(128)), 

NPI117_Other_Provider_Identifier_Type_Code_3  (VARCHAR(128)), 

NPI118_Other_Provider_Identifier_State_3  (VARCHAR(128)), 

NPI119_Other_Provider_Identifier_Issuer_3  (VARCHAR(128)), 

NPI120_Other_Provider_Identifier_4  (VARCHAR(128)), 

NPI121_Other_Provider_Identifier_Type_Code_4  (VARCHAR(128)), 

NPI122_Other_Provider_Identifier_State_4  (VARCHAR(128)), 

NPI123_Other_Provider_Identifier_Issuer_4  (VARCHAR(128)), 

NPI124_Other_Provider_Identifier_5  (VARCHAR(128)), 

NPI125_Other_Provider_Identifier_Type_Code_5  (VARCHAR(128)), 

NPI126_Other_Provider_Identifier_State_5  (VARCHAR(128)), 

NPI127_Other_Provider_Identifier_Issuer_5  (VARCHAR(128)), 

NPI128_Other_Provider_Identifier_6  (VARCHAR(128)), 

NPI129_Other_Provider_Identifier_Type_Code_6  (VARCHAR(128)), 

NPI130_Other_Provider_Identifier_State_6  (VARCHAR(128)), 

NPI131_Other_Provider_Identifier_Issuer_6  (VARCHAR(128)), 

NPI132_Other_Provider_Identifier_7  (VARCHAR(128)), 

NPI133_Other_Provider_Identifier_Type_Code_7  (VARCHAR(128)), 

NPI134_Other_Provider_Identifier_State_7  (VARCHAR(128)), 

NPI135_Other_Provider_Identifier_Issuer_7  (VARCHAR(128)), 

NPI136_Other_Provider_Identifier_8  (VARCHAR(128)), 

NPI137_Other_Provider_Identifier_Type_Code_8  (VARCHAR(128)), 

NPI138_Other_Provider_Identifier_State_8  (VARCHAR(128)), 

NPI139_Other_Provider_Identifier_Issuer_8  (VARCHAR(128)), 

NPI140_Other_Provider_Identifier_9  (VARCHAR(128)), 

NPI141_Other_Provider_Identifier_Type_Code_9  (VARCHAR(128)), 

NPI142_Other_Provider_Identifier_State_9  (VARCHAR(128)), 

NPI143_Other_Provider_Identifier_Issuer_9  (VARCHAR(128)), 

NPI144_Other_Provider_Identifier_10  (VARCHAR(128)), 

NPI145_Other_Provider_Identifier_Type_Code_10  (VARCHAR(128)), 

NPI146_Other_Provider_Identifier_State_10  (VARCHAR(128)), 

NPI147_Other_Provider_Identifier_Issuer_10  (VARCHAR(128)), 

NPI148_Other_Provider_Identifier_11  (VARCHAR(128)), 

NPI149_Other_Provider_Identifier_Type_Code_11  (VARCHAR(128)), 

NPI150_Other_Provider_Identifier_State_11  (VARCHAR(128)), 

NPI151_Other_Provider_Identifier_Issuer_11  (VARCHAR(128)), 

NPI152_Other_Provider_Identifier_12  (VARCHAR(128)), 

NPI153_Other_Provider_Identifier_Type_Code_12  (VARCHAR(128)), 

NPI154_Other_Provider_Identifier_State_12  (VARCHAR(128)), 

NPI155_Other_Provider_Identifier_Issuer_12  (VARCHAR(128)), 

NPI156_Other_Provider_Identifier_13  (VARCHAR(128)), 

NPI157_Other_Provider_Identifier_Type_Code_13  (VARCHAR(128)), 

NPI158_Other_Provider_Identifier_State_13  (VARCHAR(128)), 

NPI159_Other_Provider_Identifier_Issuer_13  (VARCHAR(128)), 

NPI160_Other_Provider_Identifier_14  (VARCHAR(128)), 

NPI161_Other_Provider_Identifier_Type_Code_14  (VARCHAR(128)), 

NPI162_Other_Provider_Identifier_State_14  (VARCHAR(128)), 

NPI163_Other_Provider_Identifier_Issuer_14  (VARCHAR(128)), 

NPI164_Other_Provider_Identifier_15  (VARCHAR(128)), 

NPI165_Other_Provider_Identifier_Type_Code_15  (VARCHAR(128)), 

NPI166_Other_Provider_Identifier_State_15  (VARCHAR(128)), 

NPI167_Other_Provider_Identifier_Issuer_15  (VARCHAR(128)), 

NPI168_Other_Provider_Identifier_16  (VARCHAR(128)), 

NPI169_Other_Provider_Identifier_Type_Code_16  (VARCHAR(128)), 

NPI170_Other_Provider_Identifier_State_16  (VARCHAR(128)), 

NPI171_Other_Provider_Identifier_Issuer_16  (VARCHAR(128)), 

NPI172_Other_Provider_Identifier_17  (VARCHAR(128)), 

NPI173_Other_Provider_Identifier_Type_Code_17  (VARCHAR(128)), 

NPI174_Other_Provider_Identifier_State_17  (VARCHAR(128)), 

NPI175_Other_Provider_Identifier_Issuer_17  (VARCHAR(128)), 

NPI176_Other_Provider_Identifier_18  (VARCHAR(128)), 

NPI177_Other_Provider_Identifier_Type_Code_18  (VARCHAR(128)), 

NPI178_Other_Provider_Identifier_State_18  (VARCHAR(128)), 

NPI179_Other_Provider_Identifier_Issuer_18  (VARCHAR(128)), 

NPI180_Other_Provider_Identifier_19  (VARCHAR(128)), 

NPI181_Other_Provider_Identifier_Type_Code_19  (VARCHAR(128)), 

NPI182_Other_Provider_Identifier_State_19  (VARCHAR(128)), 

NPI183_Other_Provider_Identifier_Issuer_19  (VARCHAR(128)), 

NPI184_Other_Provider_Identifier_20  (VARCHAR(128)), 

NPI185_Other_Provider_Identifier_Type_Code_20  (VARCHAR(128)), 

NPI186_Other_Provider_Identifier_State_20  (VARCHAR(128)), 

NPI187_Other_Provider_Identifier_Issuer_20  (VARCHAR(128)), 

NPI188_Other_Provider_Identifier_21  (VARCHAR(128)), 

NPI189_Other_Provider_Identifier_Type_Code_21  (VARCHAR(128)), 

NPI190_Other_Provider_Identifier_State_21  (VARCHAR(128)), 

NPI191_Other_Provider_Identifier_Issuer_21  (VARCHAR(128)), 

NPI192_Other_Provider_Identifier_22  (VARCHAR(128)), 

NPI193_Other_Provider_Identifier_Type_Code_22  (VARCHAR(128)), 

NPI194_Other_Provider_Identifier_State_22  (VARCHAR(128)), 

NPI195_Other_Provider_Identifier_Issuer_22  (VARCHAR(128)), 

NPI196_Other_Provider_Identifier_23  (VARCHAR(128)), 

NPI197_Other_Provider_Identifier_Type_Code_23  (VARCHAR(128)), 

NPI198_Other_Provider_Identifier_State_23  (VARCHAR(128)), 

NPI199_Other_Provider_Identifier_Issuer_23  (VARCHAR(128)), 

NPI200_Other_Provider_Identifier_24  (VARCHAR(128)), 

NPI201_Other_Provider_Identifier_Type_Code_24  (VARCHAR(128)), 

NPI202_Other_Provider_Identifier_State_24  (VARCHAR(128)), 

NPI203_Other_Provider_Identifier_Issuer_24  (VARCHAR(128)), 

NPI204_Other_Provider_Identifier_25  (VARCHAR(128)), 

NPI205_Other_Provider_Identifier_Type_Code_25  (VARCHAR(128)), 

NPI206_Other_Provider_Identifier_State_25  (VARCHAR(128)), 

NPI207_Other_Provider_Identifier_Issuer_25  (VARCHAR(128)), 

NPI208_Other_Provider_Identifier_26  (VARCHAR(128)), 

NPI209_Other_Provider_Identifier_Type_Code_26  (VARCHAR(128)), 

NPI210_Other_Provider_Identifier_State_26  (VARCHAR(128)), 

NPI211_Other_Provider_Identifier_Issuer_26  (VARCHAR(128)), 

NPI212_Other_Provider_Identifier_27  (VARCHAR(128)), 

NPI213_Other_Provider_Identifier_Type_Code_27  (VARCHAR(128)), 

NPI214_Other_Provider_Identifier_State_27  (VARCHAR(128)), 

NPI215_Other_Provider_Identifier_Issuer_27  (VARCHAR(128)), 

NPI216_Other_Provider_Identifier_28  (VARCHAR(128)), 

NPI217_Other_Provider_Identifier_Type_Code_28  (VARCHAR(128)), 

NPI218_Other_Provider_Identifier_State_28  (VARCHAR(128)), 

NPI219_Other_Provider_Identifier_Issuer_28  (VARCHAR(128)), 

NPI220_Other_Provider_Identifier_29  (VARCHAR(128)), 

NPI221_Other_Provider_Identifier_Type_Code_29  (VARCHAR(128)), 

NPI222_Other_Provider_Identifier_State_29  (VARCHAR(128)), 

NPI223_Other_Provider_Identifier_Issuer_29  (VARCHAR(128)), 

NPI224_Other_Provider_Identifier_30  (VARCHAR(128)), 

NPI225_Other_Provider_Identifier_Type_Code_30  (VARCHAR(128)), 

NPI226_Other_Provider_Identifier_State_30  (VARCHAR(128)), 

NPI227_Other_Provider_Identifier_Issuer_30  (VARCHAR(128)), 

NPI228_Other_Provider_Identifier_31  (VARCHAR(128)), 

NPI229_Other_Provider_Identifier_Type_Code_31  (VARCHAR(128)), 

NPI230_Other_Provider_Identifier_State_31  (VARCHAR(128)), 

NPI231_Other_Provider_Identifier_Issuer_31  (VARCHAR(128)), 

NPI232_Other_Provider_Identifier_32  (VARCHAR(128)), 

NPI233_Other_Provider_Identifier_Type_Code_32  (VARCHAR(128)), 

NPI234_Other_Provider_Identifier_State_32  (VARCHAR(128)), 

NPI235_Other_Provider_Identifier_Issuer_32  (VARCHAR(128)), 

NPI236_Other_Provider_Identifier_33  (VARCHAR(128)), 

NPI237_Other_Provider_Identifier_Type_Code_33  (VARCHAR(128)), 

NPI238_Other_Provider_Identifier_State_33  (VARCHAR(128)), 

NPI239_Other_Provider_Identifier_Issuer_33  (VARCHAR(128)), 

NPI240_Other_Provider_Identifier_34  (VARCHAR(128)), 

NPI241_Other_Provider_Identifier_Type_Code_34  (VARCHAR(128)), 

NPI242_Other_Provider_Identifier_State_34  (VARCHAR(128)), 

NPI243_Other_Provider_Identifier_Issuer_34  (VARCHAR(128)), 

NPI244_Other_Provider_Identifier_35  (VARCHAR(128)), 

NPI245_Other_Provider_Identifier_Type_Code_35  (VARCHAR(128)), 

NPI246_Other_Provider_Identifier_State_35  (VARCHAR(128)), 

NPI247_Other_Provider_Identifier_Issuer_35  (VARCHAR(128)), 

NPI248_Other_Provider_Identifier_36  (VARCHAR(128)), 

NPI249_Other_Provider_Identifier_Type_Code_36  (VARCHAR(128)), 

NPI250_Other_Provider_Identifier_State_36  (VARCHAR(128)), 

NPI251_Other_Provider_Identifier_Issuer_36  (VARCHAR(128)), 

NPI252_Other_Provider_Identifier_37  (VARCHAR(128)), 

NPI253_Other_Provider_Identifier_Type_Code_37  (VARCHAR(128)), 

NPI254_Other_Provider_Identifier_State_37  (VARCHAR(128)), 

NPI255_Other_Provider_Identifier_Issuer_37  (VARCHAR(128)), 

NPI256_Other_Provider_Identifier_38  (VARCHAR(128)), 

NPI257_Other_Provider_Identifier_Type_Code_38  (VARCHAR(128)), 

NPI258_Other_Provider_Identifier_State_38  (VARCHAR(128)), 

NPI259_Other_Provider_Identifier_Issuer_38  (VARCHAR(128)), 

NPI260_Other_Provider_Identifier_39  (VARCHAR(128)), 

NPI261_Other_Provider_Identifier_Type_Code_39  (VARCHAR(128)), 

NPI262_Other_Provider_Identifier_State_39  (VARCHAR(128)), 

NPI263_Other_Provider_Identifier_Issuer_39  (VARCHAR(128)), 

NPI264_Other_Provider_Identifier_40  (VARCHAR(128)), 

NPI265_Other_Provider_Identifier_Type_Code_40  (VARCHAR(128)), 

NPI266_Other_Provider_Identifier_State_40  (VARCHAR(128)), 

NPI267_Other_Provider_Identifier_Issuer_40  (VARCHAR(128)), 

NPI268_Other_Provider_Identifier_41  (VARCHAR(128)), 

NPI269_Other_Provider_Identifier_Type_Code_41  (VARCHAR(128)), 

NPI270_Other_Provider_Identifier_State_41  (VARCHAR(128)), 

NPI271_Other_Provider_Identifier_Issuer_41  (VARCHAR(128)), 

NPI272_Other_Provider_Identifier_42  (VARCHAR(128)), 

NPI273_Other_Provider_Identifier_Type_Code_42  (VARCHAR(128)), 

NPI274_Other_Provider_Identifier_State_42  (VARCHAR(128)), 

NPI275_Other_Provider_Identifier_Issuer_42  (VARCHAR(128)), 

NPI276_Other_Provider_Identifier_43  (VARCHAR(128)), 

NPI277_Other_Provider_Identifier_Type_Code_43  (VARCHAR(128)), 

NPI278_Other_Provider_Identifier_State_43  (VARCHAR(128)), 

NPI279_Other_Provider_Identifier_Issuer_43  (VARCHAR(128)), 

NPI280_Other_Provider_Identifier_44  (VARCHAR(128)), 

NPI281_Other_Provider_Identifier_Type_Code_44  (VARCHAR(128)), 

NPI282_Other_Provider_Identifier_State_44  (VARCHAR(128)), 

NPI283_Other_Provider_Identifier_Issuer_44  (VARCHAR(128)), 

NPI284_Other_Provider_Identifier_45  (VARCHAR(128)), 

NPI285_Other_Provider_Identifier_Type_Code_45  (VARCHAR(128)), 

NPI286_Other_Provider_Identifier_State_45  (VARCHAR(128)), 

NPI287_Other_Provider_Identifier_Issuer_45  (VARCHAR(128)), 

NPI288_Other_Provider_Identifier_46  (VARCHAR(128)), 

NPI289_Other_Provider_Identifier_Type_Code_46  (VARCHAR(128)), 

NPI290_Other_Provider_Identifier_State_46  (VARCHAR(128)), 

NPI291_Other_Provider_Identifier_Issuer_46  (VARCHAR(128)), 

NPI292_Other_Provider_Identifier_47  (VARCHAR(128)), 

NPI293_Other_Provider_Identifier_Type_Code_47  (VARCHAR(128)), 

NPI294_Other_Provider_Identifier_State_47  (VARCHAR(128)), 

NPI295_Other_Provider_Identifier_Issuer_47  (VARCHAR(128)), 

NPI296_Other_Provider_Identifier_48  (VARCHAR(128)), 

NPI297_Other_Provider_Identifier_Type_Code_48  (VARCHAR(128)), 

NPI298_Other_Provider_Identifier_State_48  (VARCHAR(128)), 

NPI299_Other_Provider_Identifier_Issuer_48  (VARCHAR(128)), 

NPI300_Other_Provider_Identifier_49  (VARCHAR(128)), 

NPI301_Other_Provider_Identifier_Type_Code_49  (VARCHAR(128)), 

NPI302_Other_Provider_Identifier_State_49  (VARCHAR(128)), 

NPI303_Other_Provider_Identifier_Issuer_49  (VARCHAR(128)), 

NPI304_Other_Provider_Identifier_50  (VARCHAR(128)), 

NPI305_Other_Provider_Identifier_Type_Code_50  (VARCHAR(128)), 

NPI306_Other_Provider_Identifier_State_50  (VARCHAR(128)), 

NPI307_Other_Provider_Identifier_Issuer_50  (VARCHAR(128)), 

NPI308_Is_Sole_Proprietor  (VARCHAR(128)), 

NPI309_Is_Organization_Subpart  (VARCHAR(128)), 

NPI310_Parent_Organization_LBN  (VARCHAR(128)), 

NPI311_Parent_Organization_TIN  (VARCHAR(128)), 

NPI312_Authorized_Official_Name_Prefix_Text  (VARCHAR(128)), 

NPI313_Authorized_Official_Name_Suffix_Text  (VARCHAR(128)), 

NPI314_Authorized_Official_Credential_Text  (VARCHAR(128)), 

NPI315_Healthcare_Provider_Taxonomy_Group_1  (VARCHAR(128)), 

NPI316_Healthcare_Provider_Taxonomy_Group_2  (VARCHAR(128)), 

NPI317_Healthcare_Provider_Taxonomy_Group_3  (VARCHAR(128)), 

NPI318_Healthcare_Provider_Taxonomy_Group_4  (VARCHAR(128)), 

NPI319_Healthcare_Provider_Taxonomy_Group_5  (VARCHAR(128)), 

NPI320_Healthcare_Provider_Taxonomy_Group_6  (VARCHAR(128)), 

NPI321_Healthcare_Provider_Taxonomy_Group_7  (VARCHAR(128)), 

NPI322_Healthcare_Provider_Taxonomy_Group_8  (VARCHAR(128)), 

NPI323_Healthcare_Provider_Taxonomy_Group_9  (VARCHAR(128)), 

NPI324_Healthcare_Provider_Taxonomy_Group_10  (VARCHAR(128)), 

NPI325_Healthcare_Provider_Taxonomy_Group_11  (VARCHAR(128)), 

NPI326_Healthcare_Provider_Taxonomy_Group_12  (VARCHAR(128)), 

NPI327_Healthcare_Provider_Taxonomy_Group_13  (VARCHAR(128)), 

NPI328_Healthcare_Provider_Taxonomy_Group_14  (VARCHAR(128)), 

NPI329_Healthcare_Provider_Taxonomy_Group_15  (VARCHAR(128));

FILE="c:\data\npidata.txt";

SHOW;

BEGIN LOADING dim_NPI_BAK  ERRORFILES NPI_DOWNLOAD_ERROR1,NPI_DOWNLOAD_ERROR2;

INSERT INTO HP_MU_OWN_TABLES.dim_NPI_BAK

(

NPI, ENTITY_TYPE_CODE, REPLACEMENT_NPI, EIN, PROV_ORGANIZATION_LEGAL_BUSINE,

PROV_LAST_NAME, PROV_FIRST_NAME, PROV_MIDDLE_NAME, PROV_NAME_PREFIX,

PROV_NAME_SUFFIX, PROV_CREDENTIAL_TEXT, PROV_OTHER_ORGANIZATION,

PROV_OTHER_ORGANIZATION_CODE, PROV_OTHER_LAST_NAME, PROV_OTHER_FIRST_NAME,

PROV_OTHER_MIDDLE_NAME, PROV_OTHER_NAME_PREFIX, PROV_OTHER_NAME_SUFFIX,

PROV_OTHER_CREDENTIAL, PROV_OTHER_LAST_NAME_CODE, PROV_FIRST_LINE_BUSINESS_MAILI,

PROV_SECOND_LINE_BUSINESS_MAIL, PROV_BUSINESS_MAILING_CITY, PROV_BUSINESS_MAILING_STATE,

PROV_BUSINESS_MAILING_POSTAL_C, PROV_BUSINESS_MAILING_COUNTRY,

PROV_BUSINESS_MAILING_TELEPHON, PROV_BUSINESS_MAILING_FAX, PROV_FIRST_LINE_BUSINESS_LOCAT,

PROV_SECOND_LINE_BUSINESS_LOCA, PROV_BUSINESS_PRACTICE_CITY,

PROV_BUSINESS_PRACTICE_STATE, PROV_BUSINESS_PRACTICE_POSTAL_,

PROV_BUSINESS_PRACTICE_COUNTRY, PROV_BUSINESS_PRACTICE_TELEPHO,

PROV_BUSINESS_PRACTICE_FAX, PROV_ENUMERATION_DATE, LAST_UPDATE_DATE,

NPI_DEACTIVATION_REASON_CODE, NPI_DEACTIVATION_DATE, NPI_REACTIVATION_DATE,

PROV_GENDER_CODE, AUTHORIZED_OFFICIAL_LAST_NAME, AUTHORIZED_OFFICIAL_FIRST_NAME,

AUTHORIZED_OFFICIAL_MIDDLE_NAM, AUTHORIZED_OFFICIAL_TITLE_OR_P,

AUTHORIZED_OFFICIAL_TELEPHONE, HLTHCARE_PROV_TAXO_CODE, PROV_LIC_NBR,

PROV_LIC_NBR_STATE_CODE, HLTHCARE_PROV_PRIM_TAXO_SW, HLTHCARE_PROV_TAXO_CODE_2,

PROV_LIC_NBR_2, PROV_LIC_NBR_STATE_CODE_2, HLTHCARE_PROV_PRIM_TAXO_SW_2,

HLTHCARE_PROV_TAXO_CODE_3, PROV_LIC_NBR_3, PROV_LIC_NBR_STATE_CODE_3,

HLTHCARE_PROV_PRIM_TAXO_SW_3, HLTHCARE_PROV_TAXO_CODE_4, PROV_LIC_NBR_4,

PROV_LIC_NBR_STATE_CODE_4, HLTHCARE_PROV_PRIM_TAXO_SW_4, HLTHCARE_PROV_TAXO_CODE_5,

PROV_LIC_NBR_5, PROV_LIC_NBR_STATE_CODE_5, HLTHCARE_PROV_PRIM_TAXO_SW_5,

OTHER_PROV_IDENTIFIER, OTHER_PROV_IDENTIFIER_TYPE, OTHER_PROV_IDENTIFIER_STATE,

OTHER_PROV_IDENTIFIER_ISSUER, IS_SOLE_PROPRIETOR, IS_ORGANIZATION_SUBPART,

PARENT_ORGANIZATION_LBN, PARENT_ORGANIZATION_TIN, HEALTHCARE_PROV_TAXONOMY_GROUP

)

VALUES

(

:NPI001_NPI,

:NPI002_Entity_Type_Code,

:NPI003_Replacement_NPI,

:NPI004_Employer_Identification_Number_EIN,

:NPI005_Provider_Organization_Name_Legal_Business_Name,

:NPI006_Provider_Last_Name_Legal_Name,

:NPI007_Provider_First_Name,

:NPI008_Provider_Middle_Name,

:NPI009_Provider_Name_Prefix_Text,

:NPI010_Provider_Name_Suffix_Text,

:NPI011_Provider_Credential_Text,

:NPI012_Provider_Other_Organization_Name,

:NPI013_Provider_Other_Organization_Name_Type_Code,

:NPI014_Provider_Other_Last_Name,

:NPI015_Provider_Other_First_Name,

:NPI016_Provider_Other_Middle_Name,

:NPI017_Provider_Other_Name_Prefix_Text,

:NPI018_Provider_Other_Name_Suffix_Text,

:NPI019_Provider_Other_Credential_Text,

:NPI020_Provider_Other_Last_Name_Type_Code,

:NPI021_Provider_First_Line_Business_Mailing_Address,

:NPI022_Provider_Second_Line_Business_Mailing_Address,

:NPI023_Provider_Business_Mailing_Address_City_Name,

:NPI024_Provider_Business_Mailing_Address_State_Name,

:NPI025_Provider_Business_Mailing_Address_Postal_Code,

:NPI026_Provider_Business_Mailing_Address_Country_Code,

:NPI027_Provider_Business_Mailing_Address_Telephone_Number,

:NPI028_Provider_Business_Mailing_Address_Fax_Number,

:NPI029_Provider_First_Line_Business_Practice_Location_Address,

:NPI030_Provider_Second_Line_Business_Practice_Location_Address,

:NPI031_Provider_Business_Practice_Location_Address_City_Name,

:NPI032_Provider_Business_Practice_Location_Address_State_Name,

:NPI033_Provider_Business_Practice_Location_Address_Postal_Code,

:NPI034_Provider_Business_Practice_Location_Address_Country_Code,

:NPI035_Provider_Business_Practice_Location_Address_Telephone_Number,

:NPI036_Provider_Business_Practice_Location_Address_Fax_Number,

:NPI037_Provider_Enumeration_Date,

:NPI038_Last_Update_Date,

:NPI039_NPI_Deactivation_Reason_Code,

:NPI040_NPI_Deactivation_Date,

:NPI041_NPI_Reactivation_Date,

:NPI042_Provider_Gender_Code,

:NPI043_Authorized_Official_Last_Name,

:NPI044_Authorized_Official_First_Name,

:NPI045_Authorized_Official_Middle_Name,

:NPI046_Authorized_Official_Title_or_Position,

:NPI047_Authorized_Official_Telephone_Number,

:NPI048_Healthcare_Provider_Taxonomy_Code_1,

:NPI049_Provider_License_Number_1,

:NPI050_Provider_License_Number_State_Code_1,

:NPI051_Healthcare_Provider_Primary_Taxonomy_Switch_1,

:NPI052_Healthcare_Provider_Taxonomy_Code_2,

:NPI053_Provider_License_Number_2,

:NPI054_Provider_License_Number_State_Code_2,

:NPI055_Healthcare_Provider_Primary_Taxonomy_Switch_2,

:NPI056_Healthcare_Provider_Taxonomy_Code_3,

:NPI057_Provider_License_Number_3,

:NPI058_Provider_License_Number_State_Code_3,

:NPI059_Healthcare_Provider_Primary_Taxonomy_Switch_3,

:NPI060_Healthcare_Provider_Taxonomy_Code_4,

:NPI061_Provider_License_Number_4,

:NPI062_Provider_License_Number_State_Code_4,

:NPI063_Healthcare_Provider_Primary_Taxonomy_Switch_4,

:NPI064_Healthcare_Provider_Taxonomy_Code_5,

:NPI065_Provider_License_Number_5,

:NPI066_Provider_License_Number_State_Code_5,

:NPI067_Healthcare_Provider_Primary_Taxonomy_Switch_5,

:NPI108_Other_Provider_Identifier_1,

:NPI109_Other_Provider_Identifier_Type_Code_1,

:NPI110_Other_Provider_Identifier_State_1,

:NPI111_Other_Provider_Identifier_Issuer_1,

:NPI308_Is_Sole_Proprietor,

:NPI309_Is_Organization_Subpart,

:NPI310_Parent_Organization_LBN,

:NPI311_Parent_Organization_TIN,

:NPI315_Healthcare_Provider_Taxonomy_Group_1

);

END LOADING;

LOGOFF;

3 REPLIES
Teradata Employee

Re: Fastload error: I/O Error on File Open 34

Use a comma before FILE, not a semicolon.

Re: Fastload error: I/O Error on File Open 34

 DEFINE
   NPI001_NPI  (VARCHAR(128)),
   NPI002_Entity_Type_Code  (VARCHAR(128)),
   NPI003_Replacement_NPI  (VARCHAR(128)),
   NPI004_Employer_Identification_Number_EIN  (VARCHAR(128)),
   NPI005_Provider_Organization_Name_Legal_Business_Name  (VARCHAR(128)),
   NPI006_Provider_Last_Name_Legal_Name  (VARCHAR(128)),
   NPI007_Provider_First_Name  (VARCHAR(128)),
   NPI008_Provider_Middle_Name  (VARCHAR(128)),
   NPI009_Provider_Name_Prefix_Text  (VARCHAR(128)),
   NPI010_Provider_Name_Suffix_Text  (VARCHAR(128)),
   NPI011_Provider_Credential_Text  (VARCHAR(128)),
   NPI012_Provider_Other_Organization_Name  (VARCHAR(128)),
   NPI013_Provider_Other_Organization_Name_Type_Code  (VARCHAR(128)),
   NPI014_Provider_Other_Last_Name  (VARCHAR(128)),
   NPI015_Provider_Other_First_Name  (VARCHAR(128)),
   NPI016_Provider_Other_Middle_Name  (VARCHAR(128)),
   NPI017_Provider_Other_Name_Prefix_Text  (VARCHAR(128)),
   NPI018_Provider_Other_Name_Suffix_Text  (VARCHAR(128)),
   NPI019_Provider_Other_Credential_Text  (VARCHAR(128)),
   NPI020_Provider_Other_Last_Name_Type_Code  (VARCHAR(128)),
   NPI021_Provider_First_Line_Business_Mailing_Address  (VARCHAR(128)),
   NPI022_Provider_Second_Line_Business_Mailing_Address  (VARCHAR(128)),
   NPI023_Provider_Business_Mailing_Address_City_Name  (VARCHAR(128)),
   NPI024_Provider_Business_Mailing_Address_State_Name  (VARCHAR(128)),
   NPI025_Provider_Business_Mailing_Address_Postal_Code  (VARCHAR(128)),
   NPI026_Provider_Business_Mailing_Address_Country_Code  (VARCHAR(128)),
   NPI027_Provider_Business_Mailing_Address_Telephone_Number  (VARCHAR(128)),
   NPI028_Provider_Business_Mailing_Address_Fax_Number  (VARCHAR(128)),
   NPI029_Provider_First_Line_Business_Practice_Location_Address  (VARCHAR(128)),
   NPI030_Provider_Second_Line_Business_Practice_Location_Address  (VARCHAR(128)),
   NPI031_Provider_Business_Practice_Location_Address_City_Name  (VARCHAR(128)),
   NPI032_Provider_Business_Practice_Location_Address_State_Name  (VARCHAR(128)),
   NPI033_Provider_Business_Practice_Location_Address_Postal_Code  (VARCHAR(128)),
   NPI034_Provider_Business_Practice_Location_Address_Country_Code  (VARCHAR(128)),
   NPI035_Provider_Business_Practice_Location_Address_Telephone_Number  (VARCHAR(128)),
   NPI036_Provider_Business_Practice_Location_Address_Fax_Number  (VARCHAR(128)),
   NPI037_Provider_Enumeration_Date  (VARCHAR(128)),
   NPI038_Last_Update_Date  (VARCHAR(128)),
   NPI039_NPI_Deactivation_Reason_Code  (VARCHAR(128)),
   NPI040_NPI_Deactivation_Date  (VARCHAR(128)),
   NPI041_NPI_Reactivation_Date  (VARCHAR(128)),
   NPI042_Provider_Gender_Code  (VARCHAR(128)),
   NPI043_Authorized_Official_Last_Name  (VARCHAR(128)),
   NPI044_Authorized_Official_First_Name  (VARCHAR(128)),
   NPI045_Authorized_Official_Middle_Name  (VARCHAR(128)),
   NPI046_Authorized_Official_Title_or_Position  (VARCHAR(128)),
   NPI047_Authorized_Official_Telephone_Number  (VARCHAR(128)),
   NPI048_Healthcare_Provider_Taxonomy_Code_1  (VARCHAR(128)),
   NPI049_Provider_License_Number_1  (VARCHAR(128)),
   NPI050_Provider_License_Number_State_Code_1  (VARCHAR(128)),
   NPI051_Healthcare_Provider_Primary_Taxonomy_Switch_1  (VARCHAR(128)),
   NPI052_Healthcare_Provider_Taxonomy_Code_2  (VARCHAR(128)),
   NPI053_Provider_License_Number_2  (VARCHAR(128)),
   NPI054_Provider_License_Number_State_Code_2  (VARCHAR(128)),
   NPI055_Healthcare_Provider_Primary_Taxonomy_Switch_2  (VARCHAR(128)),
   NPI056_Healthcare_Provider_Taxonomy_Code_3  (VARCHAR(128)),
   NPI057_Provider_License_Number_3  (VARCHAR(128)),
   NPI058_Provider_License_Number_State_Code_3  (VARCHAR(128)),
   NPI059_Healthcare_Provider_Primary_Taxonomy_Switch_3  (VARCHAR(128)),
   NPI060_Healthcare_Provider_Taxonomy_Code_4  (VARCHAR(128)),
   NPI061_Provider_License_Number_4  (VARCHAR(128)),
   NPI062_Provider_License_Number_State_Code_4  (VARCHAR(128)),
   NPI063_Healthcare_Provider_Primary_Taxonomy_Switch_4  (VARCHAR(128)),
   NPI064_Healthcare_Provider_Taxonomy_Code_5  (VARCHAR(128)),
   NPI065_Provider_License_Number_5  (VARCHAR(128)),
   NPI066_Provider_License_Number_State_Code_5  (VARCHAR(128)),
   NPI067_Healthcare_Provider_Primary_Taxonomy_Switch_5  (VARCHAR(128)),
   NPI068_Healthcare_Provider_Taxonomy_Code_6  (VARCHAR(128)),
   NPI069_Provider_License_Number_6  (VARCHAR(128)),
   NPI070_Provider_License_Number_State_Code_6  (VARCHAR(128)),
   NPI071_Healthcare_Provider_Primary_Taxonomy_Switch_6  (VARCHAR(128)),
   NPI072_Healthcare_Provider_Taxonomy_Code_7  (VARCHAR(128)),
   NPI073_Provider_License_Number_7  (VARCHAR(128)),
   NPI074_Provider_License_Number_State_Code_7  (VARCHAR(128)),
   NPI075_Healthcare_Provider_Primary_Taxonomy_Switch_7  (VARCHAR(128)),
   NPI076_Healthcare_Provider_Taxonomy_Code_8  (VARCHAR(128)),
   NPI077_Provider_License_Number_8  (VARCHAR(128)),
   NPI078_Provider_License_Number_State_Code_8  (VARCHAR(128)),
   NPI079_Healthcare_Provider_Primary_Taxonomy_Switch_8  (VARCHAR(128)),
   NPI080_Healthcare_Provider_Taxonomy_Code_9  (VARCHAR(128)),
   NPI081_Provider_License_Number_9  (VARCHAR(128)),
   NPI082_Provider_License_Number_State_Code_9  (VARCHAR(128)),
   NPI083_Healthcare_Provider_Primary_Taxonomy_Switch_9  (VARCHAR(128)),
   NPI084_Healthcare_Provider_Taxonomy_Code_10  (VARCHAR(128)),
   NPI085_Provider_License_Number_10  (VARCHAR(128)),
   NPI086_Provider_License_Number_State_Code_10  (VARCHAR(128)),
   NPI087_Healthcare_Provider_Primary_Taxonomy_Switch_10  (VARCHAR(128)),
   NPI088_Healthcare_Provider_Taxonomy_Code_11  (VARCHAR(128)),
   NPI089_Provider_License_Number_11  (VARCHAR(128)),
   NPI090_Provider_License_Number_State_Code_11  (VARCHAR(128)),
   NPI091_Healthcare_Provider_Primary_Taxonomy_Switch_11  (VARCHAR(128)),
   NPI092_Healthcare_Provider_Taxonomy_Code_12  (VARCHAR(128)),
   NPI093_Provider_License_Number_12  (VARCHAR(128)),
   NPI094_Provider_License_Number_State_Code_12  (VARCHAR(128)),
   NPI095_Healthcare_Provider_Primary_Taxonomy_Switch_12  (VARCHAR(128)),
   NPI096_Healthcare_Provider_Taxonomy_Code_13  (VARCHAR(128)),
   NPI097_Provider_License_Number_13  (VARCHAR(128)),
   NPI098_Provider_License_Number_State_Code_13  (VARCHAR(128)),
   NPI099_Healthcare_Provider_Primary_Taxonomy_Switch_13  (VARCHAR(128)),
   NPI100_Healthcare_Provider_Taxonomy_Code_14  (VARCHAR(128)),
   NPI101_Provider_License_Number_14  (VARCHAR(128)),
   NPI102_Provider_License_Number_State_Code_14  (VARCHAR(128)),
   NPI103_Healthcare_Provider_Primary_Taxonomy_Switch_14  (VARCHAR(128)),
   NPI104_Healthcare_Provider_Taxonomy_Code_15  (VARCHAR(128)),
   NPI105_Provider_License_Number_15  (VARCHAR(128)),
   NPI106_Provider_License_Number_State_Code_15  (VARCHAR(128)),
   NPI107_Healthcare_Provider_Primary_Taxonomy_Switch_15  (VARCHAR(128)),
   NPI108_Other_Provider_Identifier_1  (VARCHAR(128)),
   NPI109_Other_Provider_Identifier_Type_Code_1  (VARCHAR(128)),
   NPI110_Other_Provider_Identifier_State_1  (VARCHAR(128)),
   NPI111_Other_Provider_Identifier_Issuer_1  (VARCHAR(128)),
   NPI112_Other_Provider_Identifier_2  (VARCHAR(128)),
   NPI113_Other_Provider_Identifier_Type_Code_2  (VARCHAR(128)),
   NPI114_Other_Provider_Identifier_State_2  (VARCHAR(128)),
   NPI115_Other_Provider_Identifier_Issuer_2  (VARCHAR(128)),
   NPI116_Other_Provider_Identifier_3  (VARCHAR(128)),
   NPI117_Other_Provider_Identifier_Type_Code_3  (VARCHAR(128)),
   NPI118_Other_Provider_Identifier_State_3  (VARCHAR(128)),
   NPI119_Other_Provider_Identifier_Issuer_3  (VARCHAR(128)),
   NPI120_Other_Provider_Identifier_4  (VARCHAR(128)),
   NPI121_Other_Provider_Identifier_Type_Code_4  (VARCHAR(128)),
   NPI122_Other_Provider_Identifier_State_4  (VARCHAR(128)),
   NPI123_Other_Provider_Identifier_Issuer_4  (VARCHAR(128)),
   NPI124_Other_Provider_Identifier_5  (VARCHAR(128)),
   NPI125_Other_Provider_Identifier_Type_Code_5  (VARCHAR(128)),
   NPI126_Other_Provider_Identifier_State_5  (VARCHAR(128)),
   NPI127_Other_Provider_Identifier_Issuer_5  (VARCHAR(128)),
   NPI128_Other_Provider_Identifier_6  (VARCHAR(128)),
   NPI129_Other_Provider_Identifier_Type_Code_6  (VARCHAR(128)),
   NPI130_Other_Provider_Identifier_State_6  (VARCHAR(128)),
   NPI131_Other_Provider_Identifier_Issuer_6  (VARCHAR(128)),
   NPI132_Other_Provider_Identifier_7  (VARCHAR(128)),
   NPI133_Other_Provider_Identifier_Type_Code_7  (VARCHAR(128)),
   NPI134_Other_Provider_Identifier_State_7  (VARCHAR(128)),
   NPI135_Other_Provider_Identifier_Issuer_7  (VARCHAR(128)),
   NPI136_Other_Provider_Identifier_8  (VARCHAR(128)),
   NPI137_Other_Provider_Identifier_Type_Code_8  (VARCHAR(128)),
   NPI138_Other_Provider_Identifier_State_8  (VARCHAR(128)),
   NPI139_Other_Provider_Identifier_Issuer_8  (VARCHAR(128)),
   NPI140_Other_Provider_Identifier_9  (VARCHAR(128)),
   NPI141_Other_Provider_Identifier_Type_Code_9  (VARCHAR(128)),
   NPI142_Other_Provider_Identifier_State_9  (VARCHAR(128)),
   NPI143_Other_Provider_Identifier_Issuer_9  (VARCHAR(128)),
   NPI144_Other_Provider_Identifier_10  (VARCHAR(128)),
   NPI145_Other_Provider_Identifier_Type_Code_10  (VARCHAR(128)),
   NPI146_Other_Provider_Identifier_State_10  (VARCHAR(128)),
   NPI147_Other_Provider_Identifier_Issuer_10  (VARCHAR(128)),
   NPI148_Other_Provider_Identifier_11  (VARCHAR(128)),
   NPI149_Other_Provider_Identifier_Type_Code_11  (VARCHAR(128)),
   NPI150_Other_Provider_Identifier_State_11  (VARCHAR(128)),
   NPI151_Other_Provider_Identifier_Issuer_11  (VARCHAR(128)),
   NPI152_Other_Provider_Identifier_12  (VARCHAR(128)),
   NPI153_Other_Provider_Identifier_Type_Code_12  (VARCHAR(128)),
   NPI154_Other_Provider_Identifier_State_12  (VARCHAR(128)),
   NPI155_Other_Provider_Identifier_Issuer_12  (VARCHAR(128)),
   NPI156_Other_Provider_Identifier_13  (VARCHAR(128)),
   NPI157_Other_Provider_Identifier_Type_Code_13  (VARCHAR(128)),
   NPI158_Other_Provider_Identifier_State_13  (VARCHAR(128)),
   NPI159_Other_Provider_Identifier_Issuer_13  (VARCHAR(128)),
   NPI160_Other_Provider_Identifier_14  (VARCHAR(128)),
   NPI161_Other_Provider_Identifier_Type_Code_14  (VARCHAR(128)),
   NPI162_Other_Provider_Identifier_State_14  (VARCHAR(128)),
   NPI163_Other_Provider_Identifier_Issuer_14  (VARCHAR(128)),
   NPI164_Other_Provider_Identifier_15  (VARCHAR(128)),
   NPI165_Other_Provider_Identifier_Type_Code_15  (VARCHAR(128)),
   NPI166_Other_Provider_Identifier_State_15  (VARCHAR(128)),
   NPI167_Other_Provider_Identifier_Issuer_15  (VARCHAR(128)),
   NPI168_Other_Provider_Identifier_16  (VARCHAR(128)),
   NPI169_Other_Provider_Identifier_Type_Code_16  (VARCHAR(128)),
   NPI170_Other_Provider_Identifier_State_16  (VARCHAR(128)),
   NPI171_Other_Provider_Identifier_Issuer_16  (VARCHAR(128)),
   NPI172_Other_Provider_Identifier_17  (VARCHAR(128)),
   NPI173_Other_Provider_Identifier_Type_Code_17  (VARCHAR(128)),
   NPI174_Other_Provider_Identifier_State_17  (VARCHAR(128)),
   NPI175_Other_Provider_Identifier_Issuer_17  (VARCHAR(128)),
   NPI176_Other_Provider_Identifier_18  (VARCHAR(128)),
   NPI177_Other_Provider_Identifier_Type_Code_18  (VARCHAR(128)),
   NPI178_Other_Provider_Identifier_State_18  (VARCHAR(128)),
   NPI179_Other_Provider_Identifier_Issuer_18  (VARCHAR(128)),
   NPI180_Other_Provider_Identifier_19  (VARCHAR(128)),
   NPI181_Other_Provider_Identifier_Type_Code_19  (VARCHAR(128)),
   NPI182_Other_Provider_Identifier_State_19  (VARCHAR(128)),
   NPI183_Other_Provider_Identifier_Issuer_19  (VARCHAR(128)),
   NPI184_Other_Provider_Identifier_20  (VARCHAR(128)),
   NPI185_Other_Provider_Identifier_Type_Code_20  (VARCHAR(128)),
   NPI186_Other_Provider_Identifier_State_20  (VARCHAR(128)),
   NPI187_Other_Provider_Identifier_Issuer_20  (VARCHAR(128)),
   NPI188_Other_Provider_Identifier_21  (VARCHAR(128)),
   NPI189_Other_Provider_Identifier_Type_Code_21  (VARCHAR(128)),
   NPI190_Other_Provider_Identifier_State_21  (VARCHAR(128)),
   NPI191_Other_Provider_Identifier_Issuer_21  (VARCHAR(128)),
   NPI192_Other_Provider_Identifier_22  (VARCHAR(128)),
   NPI193_Other_Provider_Identifier_Type_Code_22  (VARCHAR(128)),
   NPI194_Other_Provider_Identifier_State_22  (VARCHAR(128)),
   NPI195_Other_Provider_Identifier_Issuer_22  (VARCHAR(128)),
   NPI196_Other_Provider_Identifier_23  (VARCHAR(128)),
   NPI197_Other_Provider_Identifier_Type_Code_23  (VARCHAR(128)),
   NPI198_Other_Provider_Identifier_State_23  (VARCHAR(128)),
   NPI199_Other_Provider_Identifier_Issuer_23  (VARCHAR(128)),
   NPI200_Other_Provider_Identifier_24  (VARCHAR(128)),
   NPI201_Other_Provider_Identifier_Type_Code_24  (VARCHAR(128)),
   NPI202_Other_Provider_Identifier_State_24  (VARCHAR(128)),
   NPI203_Other_Provider_Identifier_Issuer_24  (VARCHAR(128)),
   NPI204_Other_Provider_Identifier_25  (VARCHAR(128)),
   NPI205_Other_Provider_Identifier_Type_Code_25  (VARCHAR(128)),
   NPI206_Other_Provider_Identifier_State_25  (VARCHAR(128)),
   NPI207_Other_Provider_Identifier_Issuer_25  (VARCHAR(128)),
   NPI208_Other_Provider_Identifier_26  (VARCHAR(128)),
   NPI209_Other_Provider_Identifier_Type_Code_26  (VARCHAR(128)),
   NPI210_Other_Provider_Identifier_State_26  (VARCHAR(128)),
   NPI211_Other_Provider_Identifier_Issuer_26  (VARCHAR(128)),
   NPI212_Other_Provider_Identifier_27  (VARCHAR(128)),
   NPI213_Other_Provider_Identifier_Type_Code_27  (VARCHAR(128)),
   NPI214_Other_Provider_Identifier_State_27  (VARCHAR(128)),
   NPI215_Other_Provider_Identifier_Issuer_27  (VARCHAR(128)),
   NPI216_Other_Provider_Identifier_28  (VARCHAR(128)),
   NPI217_Other_Provider_Identifier_Type_Code_28  (VARCHAR(128)),
   NPI218_Other_Provider_Identifier_State_28  (VARCHAR(128)),
   NPI219_Other_Provider_Identifier_Issuer_28  (VARCHAR(128)),
   NPI220_Other_Provider_Identifier_29  (VARCHAR(128)),
   NPI221_Other_Provider_Identifier_Type_Code_29  (VARCHAR(128)),
   NPI222_Other_Provider_Identifier_State_29  (VARCHAR(128)),
   NPI223_Other_Provider_Identifier_Issuer_29  (VARCHAR(128)),
   NPI224_Other_Provider_Identifier_30  (VARCHAR(128)),
   NPI225_Other_Provider_Identifier_Type_Code_30  (VARCHAR(128)),
   NPI226_Other_Provider_Identifier_State_30  (VARCHAR(128)),
   NPI227_Other_Provider_Identifier_Issuer_30  (VARCHAR(128)),
   NPI228_Other_Provider_Identifier_31  (VARCHAR(128)),
   NPI229_Other_Provider_Identifier_Type_Code_31  (VARCHAR(128)),
   NPI230_Other_Provider_Identifier_State_31  (VARCHAR(128)),
   NPI231_Other_Provider_Identifier_Issuer_31  (VARCHAR(128)),
   NPI232_Other_Provider_Identifier_32  (VARCHAR(128)),
   NPI233_Other_Provider_Identifier_Type_Code_32  (VARCHAR(128)),
   NPI234_Other_Provider_Identifier_State_32  (VARCHAR(128)),
   NPI235_Other_Provider_Identifier_Issuer_32  (VARCHAR(128)),
   NPI236_Other_Provider_Identifier_33  (VARCHAR(128)),
   NPI237_Other_Provider_Identifier_Type_Code_33  (VARCHAR(128)),
   NPI238_Other_Provider_Identifier_State_33  (VARCHAR(128)),
   NPI239_Other_Provider_Identifier_Issuer_33  (VARCHAR(128)),
   NPI240_Other_Provider_Identifier_34  (VARCHAR(128)),
   NPI241_Other_Provider_Identifier_Type_Code_34  (VARCHAR(128)),
   NPI242_Other_Provider_Identifier_State_34  (VARCHAR(128)),
   NPI243_Other_Provider_Identifier_Issuer_34  (VARCHAR(128)),
   NPI244_Other_Provider_Identifier_35  (VARCHAR(128)),
   NPI245_Other_Provider_Identifier_Type_Code_35  (VARCHAR(128)),
   NPI246_Other_Provider_Identifier_State_35  (VARCHAR(128)),
   NPI247_Other_Provider_Identifier_Issuer_35  (VARCHAR(128)),
   NPI248_Other_Provider_Identifier_36  (VARCHAR(128)),
   NPI249_Other_Provider_Identifier_Type_Code_36  (VARCHAR(128)),
   NPI250_Other_Provider_Identifier_State_36  (VARCHAR(128)),
   NPI251_Other_Provider_Identifier_Issuer_36  (VARCHAR(128)),
   NPI252_Other_Provider_Identifier_37  (VARCHAR(128)),
   NPI253_Other_Provider_Identifier_Type_Code_37  (VARCHAR(128)),
   NPI254_Other_Provider_Identifier_State_37  (VARCHAR(128)),
   NPI255_Other_Provider_Identifier_Issuer_37  (VARCHAR(128)),
   NPI256_Other_Provider_Identifier_38  (VARCHAR(128)),
   NPI257_Other_Provider_Identifier_Type_Code_38  (VARCHAR(128)),
   NPI258_Other_Provider_Identifier_State_38  (VARCHAR(128)),
   NPI259_Other_Provider_Identifier_Issuer_38  (VARCHAR(128)),
   NPI260_Other_Provider_Identifier_39  (VARCHAR(128)),
   NPI261_Other_Provider_Identifier_Type_Code_39  (VARCHAR(128)),
   NPI262_Other_Provider_Identifier_State_39  (VARCHAR(128)),
   NPI263_Other_Provider_Identifier_Issuer_39  (VARCHAR(128)),
   NPI264_Other_Provider_Identifier_40  (VARCHAR(128)),
   NPI265_Other_Provider_Identifier_Type_Code_40  (VARCHAR(128)),
   NPI266_Other_Provider_Identifier_State_40  (VARCHAR(128)),
   NPI267_Other_Provider_Identifier_Issuer_40  (VARCHAR(128)),
   NPI268_Other_Provider_Identifier_41  (VARCHAR(128)),
   NPI269_Other_Provider_Identifier_Type_Code_41  (VARCHAR(128)),
   NPI270_Other_Provider_Identifier_State_41  (VARCHAR(128)),
   NPI271_Other_Provider_Identifier_Issuer_41  (VARCHAR(128)),
   NPI272_Other_Provider_Identifier_42  (VARCHAR(128)),
   NPI273_Other_Provider_Identifier_Type_Code_42  (VARCHAR(128)),
   NPI274_Other_Provider_Identifier_State_42  (VARCHAR(128)),
   NPI275_Other_Provider_Identifier_Issuer_42  (VARCHAR(128)),
   NPI276_Other_Provider_Identifier_43  (VARCHAR(128)),
   NPI277_Other_Provider_Identifier_Type_Code_43  (VARCHAR(128)),
   NPI278_Other_Provider_Identifier_State_43  (VARCHAR(128)),
   NPI279_Other_Provider_Identifier_Issuer_43  (VARCHAR(128)),
   NPI280_Other_Provider_Identifier_44  (VARCHAR(128)),
   NPI281_Other_Provider_Identifier_Type_Code_44  (VARCHAR(128)),
   NPI282_Other_Provider_Identifier_State_44  (VARCHAR(128)),
   NPI283_Other_Provider_Identifier_Issuer_44  (VARCHAR(128)),
   NPI284_Other_Provider_Identifier_45  (VARCHAR(128)),
   NPI285_Other_Provider_Identifier_Type_Code_45  (VARCHAR(128)),
   NPI286_Other_Provider_Identifier_State_45  (VARCHAR(128)),
   NPI287_Other_Provider_Identifier_Issuer_45  (VARCHAR(128)),
   NPI288_Other_Provider_Identifier_46  (VARCHAR(128)),
   NPI289_Other_Provider_Identifier_Type_Code_46  (VARCHAR(128)),
   NPI290_Other_Provider_Identifier_State_46  (VARCHAR(128)),
   NPI291_Other_Provider_Identifier_Issuer_46  (VARCHAR(128)),
   NPI292_Other_Provider_Identifier_47  (VARCHAR(128)),
   NPI293_Other_Provider_Identifier_Type_Code_47  (VARCHAR(128)),
   NPI294_Other_Provider_Identifier_State_47  (VARCHAR(128)),
   NPI295_Other_Provider_Identifier_Issuer_47  (VARCHAR(128)),
   NPI296_Other_Provider_Identifier_48  (VARCHAR(128)),
   NPI297_Other_Provider_Identifier_Type_Code_48  (VARCHAR(128)),
   NPI298_Other_Provider_Identifier_State_48  (VARCHAR(128)),
   NPI299_Other_Provider_Identifier_Issuer_48  (VARCHAR(128)),
   NPI300_Other_Provider_Identifier_49  (VARCHAR(128)),
   NPI301_Other_Provider_Identifier_Type_Code_49  (VARCHAR(128)),
   NPI302_Other_Provider_Identifier_State_49  (VARCHAR(128)),
   NPI303_Other_Provider_Identifier_Issuer_49  (VARCHAR(128)),
   NPI304_Other_Provider_Identifier_50  (VARCHAR(128)),
   NPI305_Other_Provider_Identifier_Type_Code_50  (VARCHAR(128)),
   NPI306_Other_Provider_Identifier_State_50  (VARCHAR(128)),
   NPI307_Other_Provider_Identifier_Issuer_50  (VARCHAR(128)),
   NPI308_Is_Sole_Proprietor  (VARCHAR(128)),
   NPI309_Is_Organization_Subpart  (VARCHAR(128)),
   NPI310_Parent_Organization_LBN  (VARCHAR(128)),
   NPI311_Parent_Organization_TIN  (VARCHAR(128)),
   NPI312_Authorized_Official_Name_Prefix_Text  (VARCHAR(128)),
   NPI313_Authorized_Official_Name_Suffix_Text  (VARCHAR(128)),
   NPI314_Authorized_Official_Credential_Text  (VARCHAR(128)),
   NPI315_Healthcare_Provider_Taxonomy_Group_1  (VARCHAR(128)),
   NPI316_Healthcare_Provider_Taxonomy_Group_2  (VARCHAR(128)),
   NPI317_Healthcare_Provider_Taxonomy_Group_3  (VARCHAR(128)),
   NPI318_Healthcare_Provider_Taxonomy_Group_4  (VARCHAR(128)),
   NPI319_Healthcare_Provider_Taxonomy_Group_5  (VARCHAR(128)),
   NPI320_Healthcare_Provider_Taxonomy_Group_6  (VARCHAR(128)),
   NPI321_Healthcare_Provider_Taxonomy_Group_7  (VARCHAR(128)),
   NPI322_Healthcare_Provider_Taxonomy_Group_8  (VARCHAR(128)),
   NPI323_Healthcare_Provider_Taxonomy_Group_9  (VARCHAR(128)),
   NPI324_Healthcare_Provider_Taxonomy_Group_10  (VARCHAR(128)),
   NPI325_Healthcare_Provider_Taxonomy_Group_11  (VARCHAR(128)),
   NPI326_Healthcare_Provider_Taxonomy_Group_12  (VARCHAR(128)),
   NPI327_Healthcare_Provider_Taxonomy_Group_13  (VARCHAR(128)),
   NPI328_Healthcare_Provider_Taxonomy_Group_14  (VARCHAR(128)),
   NPI329_Healthcare_Provider_Taxonomy_Group_15  (VARCHAR(128)),

 FILE="c:\data\npidata.txt";

thank you Fred, that worked!  I copied out the corrected DEFINE statement.

Teradata Employee

Re: Fastload error: I/O Error on File Open 34

Hi,

Glad to know that it worked after correcting the syntax error. It would be nice for FastLoad not to issue the misleading message which leads to a Teradata DataConnector related error. Teradata FastLoad team will be fixing this misleading message issue.

Thanks!