DSXchange

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?

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.

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.

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

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

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 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$

1^IRAJESH^I0$

2^INARESH^I0$

3^IRON^I0$

4^ISRINI^I0$

5^IVIVEK^I0$

when i set list on the file.

There ya go.

chulett wrote:There ya go.

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

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

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

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

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

dnsjain wrote: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