Hi All,
I am using a schema file and RCP enabled to read the data from a sequential file.
My Schema file struncture looks as follows: record
{final_delim=end, delim='\t', quote=none}
(
ID:nullable int32 {default='NULL'};
NAME:nullable string[]{null_field='',prefix=2};
END:nullable int32 {default='NULL'};
)
i/p file: ID NAME END
1 XXX 0
2 YYY 0
3 ZZZ 0
4 AAA 0
5 BBB 0
When i run the job all the records are getting rejected with the following warning:
Sequential_File_24,0: Short input record
.
I searched the forums,but could not figure it out.Could you please advise?
neena wrote:I saw a note in PDF saying, If you have defined columns on the Columns tab, make sure these match the schema file. Could you please recheck this.
I have'nt defined any columns on the columns tab,just enabled RCP in the seq. file.
chulett wrote:You need to be more than 'pretty sure', you need to be certain. What does the file look like if you open it in 'vi', type a colon and then "set list"?
Chulett,
I am certain that they are TAB's.The file looks like: ID^INAME^IEND$
ray.wurlod wrote:I wonder whether END might be a reserved word? Can you try it with a different field name?
Ray,
I tried with a different filed name,but still the same warning.
Schema file: record
{final_delim=end, delim='\t', quote=none}
(
ID:nullable int32 {default=NULL};
NAME:nullable string[]{null_field='',prefix=2};
EMPLOYEE:nullable int32 {default=NULL};
)