DSXchange

Posted: **Fri Oct 02, 2015 4:43 pm**

hi,

i am getting the below error while reading the pipe delimiter sequential file.

##W IIS-DSEE-TFIG-00187 18:24:56(000) <sf_1,0> Field "MTDAdjustedAmount" has import error and no default value; data: {. 0 0 0 0 0 0d}, at offset: 93
##W IIS-DSEE-TOIX-00154 18:24:56(001) <sf_1,0> Import warning at record 0.
##W IIS-DSEE-TOIX-00018 18:24:56(002) <sf_1,0> Import unsuccessful at record 0.
##W IIS-DSEE-TFIG-00187 18:24:56(003) <sf_1,0> Field "MTDAdjustedAmount" has import error and no default value; data: {- 2 9 5 7 9 9 . 0 0 0 0 0 0d}, at offset: 110
##W IIS-DSEE-TOIX-00154 18:24:56(004) <sf_1,0> Import warning at record 1.
##W IIS-DSEE-TOIX-00018 18:24:56(005) <sf_1,0> Import unsuccessful at record 1.
##W IIS-DSEE-TFIG-00187 18:24:56(006) <sf_1,0> Field "MTDAdjustedAmount" has import error and no default value; data: {. 0 0 0 0 0 0d}, at offset: 88
##W IIS-DSEE-TOIX-00154 18:24:56(007) <sf_1,0> Import warning at record 2.
##W IIS-DSEE-TOIX-00018 18:24:56(008) <sf_1,0> Import unsuccessful at record 2.
##W IIS-DSEE-TFIG-00187 18:24:56(009) <sf_1,0> Field "MTDAdjustedAmount" has import error and no default value; data: {. 0 0 0 0 0 0d}, at offset: 89
##W IIS-DSEE-TOIX-00154 18:24:56(010) <sf_1,0> Import warning at record 3.
##W IIS-DSEE-TOIX-00018 18:24:56(011) <sf_1,0> Import unsuccessful at record 3.
##W IIS-DSEE-TFIG-00187 18:24:56(012) <sf_1,0> Field "MTDAdjustedAmount" has import error and no default value; data: {. 0 0 0 0 0 0d}, at offset: 90
##W IIS-DSEE-TOIX-00154 18:24:56(013) <sf_1,0> Import warning at record 4.
##W IIS-DSEE-TOIX-00018 18:24:56(014) <sf_1,0> Import unsuccessful at record 4.

i have given the final delimier =end
quote =none
delimiter=|

The datatype of last column MTDAdjustedAmount is decimal(20,5)

The data in file is given below

Ed|Calendar|CalendarYear|Outpt|CId|Outputc|YTD|MTD|YTDAdj|MTDAdjustedAmount
1|13|2012|Output Adjustment - Income Statement|182|NewVehicleRL|1010.00000|.00000|1010.00000|.00000
1|12|2014|Output Adjustment - Balance Sheet|50011|TotalAccruedLiabilities|7757075.00000|.00000|14377393.00000|-295799.00000
1|1|2014|Key Financial Ratios|50096|WorkingCapital|38753077.00000|.00000|34942835.00000|.00000
2|1|2015|Reconciliation Income Statement|34|LegalAuditing|13238.00000|.00000|13238.00000|.00000
2|6|2011|Detailed Balance Sheet|167|ContractsinTransit|1448596.00000|.00000|1448596.00000|.00000
2|5|2013|Reconciliation Income Statement|1351|NewAftermarketother|6821156.00000|.00000|1025579.00000|.00000
1826|9|2013|Detailed Income Statement|42|TravelEntertainment|12840.00000|.00000|12840.00000|.00000
1826|1|2015|Output Adjustment - Income Statement|823|UsedVehicleWholesale|2625522.00000|.00000|2625522.00000|.00000
1826|1|2015|Reconciliation Balance Sheet|50010|TotalAccountsSTNotesPayable|357823.00000|.00000|357823.00000|.00000

Can you please help me how to resolve this error.

Posted: **Fri Oct 02, 2015 4:53 pm**

Change from a Record Delimiter property of "UNIX Style" to a Record Delimiter String property of "DOS Style".

The 0d on the end of each record is the carriage return of the DOS style line terminator.