Schema file issue
Posted: Thu Mar 17, 2011 2:58 am
I am not able to read negative value using schema file from sequencial file.
I can read below value and process
00000000000098750
But not able to read below value and getting error message
0000000000000-112
CImpBySchFile,0: Field "i_amt" has import error and no default value; data: {20 0 0 0 0 0 0 0 0 0 0 0 0 0 - 1 1 2}, at offs
et: 581
At present , I am using this statement in my schema file:
i_amt:nullable decimal[17,2] {separate,leading,width=18};
I need your help to solve this issue.
I can read below value and process
00000000000098750
But not able to read below value and getting error message
0000000000000-112
CImpBySchFile,0: Field "i_amt" has import error and no default value; data: {20 0 0 0 0 0 0 0 0 0 0 0 0 0 - 1 1 2}, at offs
et: 581
At present , I am using this statement in my schema file:
i_amt:nullable decimal[17,2] {separate,leading,width=18};
I need your help to solve this issue.