Warning:Short input record

[peddidsx]

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]

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.

[peddidsx]

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.

[ArndW]

are you certain that your separators are actually "TAB"s and not "SPACE"s?

[peddidsx]

Yes Andrw.I am pretty much sure that they are TAB'S.

[chulett]

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"?

[peddidsx]

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$

1^IRAJESH^I0$

2^INARESH^I0$

3^IRON^I0$

4^ISRINI^I0$

5^IVIVEK^I0$

when i set list on the file.

[chulett]

There ya go.

[peddidsx]

There ya go.

Chulett,
I did not get you.Could you please elaborate?

[chulett]

All I meant was - there ya go, now you know they are tabs. Scratch that off your list of "things that may be wrong".

[ray.wurlod]

I wonder whether END might be a reserved word? Can you try it with a different field name?

[peddidsx]

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};
)

[dnsjain]

Try removing "prefix=2" from the schema file and run again. I was getting the same error and did that and it is working.

Dinesh

[peddidsx]

Try removing "prefix=2" from the schema file and run again. I was getting the same error and did that and it is working.

Dinesh

Thanks Dinesh.It was working fine when i removed prefix=2