Hi all,
I have a job copying the same file to another file using two sequential file stages.I have a problem while importing this file which is a fixed width file 0f 150 charecters length and and has a HEX 0A at the end of each record.
I am taking the record length as char(151).
with properties
final delimites=end
delimiter=none and Quote=none.
all the records are not getting imported giving a warning message that "Field "RECORD" with 'delim=end' did not consume entire input"
"Input buffer overrun at field "RECORD"
"Import warning at record 0"
I tried taking the record properties as VARCHAR(151) the import was successful.
will there be any problem if i change the char field to varchar field.
please provide some inputs to my problem.
ps:i need to use the same job design as it a alreay productionised job.
I think you need to set the record delimited to 'UNIX newline'. If you choose to import with the record length of 151, then give the final 'field' a filler-type name and drop it using the 'drop on input' option.
Brad
It is not that I am addicted to coffee, it's just that I need it to survive.