Schema File & Dates

[vimgo]

Hi guys,
I have a job which read from several sequential files and load to tables.
Sequential File --> DataBase

for this, I have schema file (for each sequential file), well, the problem is when I have dates and it coming null, I try several solutions, example...

record
{final_delim='|',delim='|', quote=none}
(
...
F_COB_FVSEEUC1:nullable date {default=null};
...
}

The file which one I need to load is:(example)
...
123502|78|42A|2010/05/07|2010/05/04|13|11|RR64/10|2010/05/04|10|||||
...

The error message is:

Sf_UsuarioMercury,0: Input buffer overrun at field "F_COB_FVSEEUC1", at offset: 64

if I check the lin it is 2010/05/04|10

Any suggest?

Thank you very much, I appreciate your comments!

[jwiles]

Hi
The file which one I need to load is:(example)
...
123502|78|42A|2010/05/07|2010/05/04|13|11|RR64/10|2010/05/04|10|||||
...

The error message is:

Sf_UsuarioMercury,0: Input buffer overrun at field "F_COB_FVSEEUC1", at offset: 64

if I check the lin it is 2010/05/04|10

Using the line you gave as an example, I see |||| at offset 64.

Suggestions:

- Ensure that your metadata (schema) for the record is correct. You only show us the one line for the date but there are obviously more columns.
- Try a schema with all input columns defined as VarChar. Can you successfully read the file with that?
- Have you modified the default date format for the project? DS's default is normally "YYYY-MM-DD". The dates in your example are apparently "YYYY/MM/DD". You can specify the default format at the project level (DS Administrator) or you can specify it in the schema either at the record or column level.

There are plenty of threads concerning input buffer overrun in the forum. Have you looked at any of those for possible solutions?

Regards,

[vimgo]

Hi jwiles, thanks for your answer,
well, I change the type date to string[10] {default=null}; and it is working fine!