LOAD DATA

APPEND
INTO TABLE FnmLoan
FIELDS TERMINATED BY "|"
(
SecMnem,
LoanSeqNum,
PoolPrefix,
CUSIP,
PoolIssDt  date 'YYYYMMDD',
FctrDt  date 'YYYYMMDD',
CorrectionFlag,
Seller,
Servicer,
OrigNoteRate,
NoteRate,
NetNoteRate,
OrigLoanAmt,
PoolIssRPB,
CurrRPB,
OrigTerm,
FirstPaymtDt  date 'YYYYMMDD',
LoanAge,
RemTerm,
MatDt  date 'YYYYMMDD',
OrigLTV,
CS,
LoanPurpose,
NumUnits,
OccStatus,
State,
CouponType,
PpayPremTerm,
PpayProtMtgFlag,
InterestOnlyPerFlag,
FirstPIPaymtDt  date 'YYYYMMDD',
MonthsToAmort,
TPOFlag,
OrigCombLTV,
NumBorrowers,
DTI,
FirstTimeHomeBuyerFlag,
PropType,
PctMtgIns,
PoolIssNoteRate,
PoolIssNetNoteRate,
UCS,
ELTV,
MtgInsCancelFlag,
GovtAgy,
AssumabilityFlag,
LoanPartnPct,
PropValMethod,
UpdSrc,
UpdDt timestamp 'YYYYMMDD HH24:MI:SS',
ADR,
NumADR,
TotDefAmt,
BAP,
DaysDelinq,
SellerCity,
SellerState,
ServicerCity,
ServicerState,
SpecialEligProg
)