hi,
I am using Schema file for the first time. Please help in analyzing the mistake.
i have my source file as
1,xyz,1009.89,1
2,yxz,3456.00,3
and my schema file is like
record
{final_delim=end,delim=',', quote=none}
(
eno:int32;
ename:string[20];
salary:decimal[15,2];
rank:int32)
WARNINGS IN MY JOB:
Sequential_File_8,0:Input buffer overrun at field "ename"
Sequential_File_8,0:Import warning at record 0.Sequential_File_8,0:Import unsuccessful at record 0.Sequential_File_8,0: Field "ename" delimiter not seen, at offset: 22 and warnings continue rejecting all my records.
None of the record is processed further... please suggest changes that are made in schema file.
schema file-- issue
Moderators: chulett, rschirm, roy
Change string[20] (which is Char) to string[max=20] (which is VarChar).
The Parallel Job Developer Guide has a good appendix on record schemas. Also, you can easily see which data types in Designer correspond to which data types in a schema by using the Table Definition editor in Designer and viewing the Parallel layouts in the Layout Tab.
Regards,
The Parallel Job Developer Guide has a good appendix on record schemas. Also, you can easily see which data types in Designer correspond to which data types in a schema by using the Table Definition editor in Designer and viewing the Parallel layouts in the Layout Tab.
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.