kumar_s wrote:Pls let me know more about your circustance,
If the situtuation is as....
input is sequential file with delimited data,
its obvious that, whatever the case be, varchar holds good for all the case.
it can be integer or even special character(excepts the feild delimter or record delimter).
Pls also post the warning or error you get while reading as varchar.
regards
kumar
Hi kumar,
I'm actually reading the data as VarChar, but my requirement is to read certain fields as "Date" data type. i have no problem reading the data if i read as Varchar, but when i try to read certain fields related
to data data type, i 'm gettin the following error:
"##W TOIX 000000 08:24:07(000) <Sequential_File_49,0> Field "PMT_NEXT_DUE_DATE" has import error and no default value; data: {0 5 / 0 1 / 2 0 0 5}, at offset: 172
##W TOIX 000154 08:24:07(001) <Sequential_File_49,0> Import warning at record 0:
##W TOIX 000018 08:24:07(002) <Sequential_File_49,0> Import unsuccessful at record 0:
##W TOIX 000000 08:24:07(003) <Sequential_File_49,0> Field "PMT_NEXT_DUE_DATE" has import error and no default value; data: {0 4 / 0 1 / 2 0 0 5}, at offset: 172
##W TOIX 000154 08:24:07(004) <Sequential_File_49,0> Import warning at record 1:
##W TOIX 000018 08:24:07(005) <Sequential_File_49,0> Import unsuccessful at record 1:
##W TOIX 000000 08:24:07(006) <Sequential_File_49,0> Field "PMT_NEXT_DUE_DATE" has import error and no default value; data: {0 5 / 0 1 / 2 0 0 5}, at offset: 172
##W TOIX 000154 08:24:07(007) <Sequential_File_49,0> Import warning at record 2:
##W TOIX 000018 08:24:07(008) <Sequential_File_49,0> Import unsuccessful at record 2:
##W TOIX 000000 08:24:07(009) <Sequential_File_49,0> Field "PMT_NEXT_DUE_DATE" has import error and no default value; data: {0 5 / 0 1 / 2 0 0 5}, at offset: 172
##W TOIX 000154 08:24:07(010) <Sequential_File_49,0> Import warning at record 3:
##W TOIX 000018 08:24:07(011) <Sequential_File_49,0> Import unsuccessful at record 3:
##W TOIX 000000 08:24:07(012) <Sequential_File_49,0> Field "PMT_NEXT_DUE_DATE" has import error and no default value; data: {0 5 / 0 1 / 2 0 0 5}, at offset: 172
##W TOIX 000154 08:24:07(013) <Sequential_File_49,0> Import warning at record 4:
##W TOIX 000018 08:24:07(014) <Sequential_File_49,0> Import unsuccessful at record 4:
##I TOIX 000157 08:24:07(015) <Sequential_File_49,0> (no further reports will be generated from this partition until successful import)
##I TOIX 000163 08:24:07(016) <Sequential_File_49,0> Import complete. 0 records imported successfully, 37 rejected."
For this reason i'm reading the field as VarChar.
So, thats my problem.
Kindly help me on this, thanks
kiran