importing a file with record delimited by HEX 0A

suneyes · Post by **suneyes** » Mon Oct 13, 2008 12:19 am

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.

bcarlson · Post by **bcarlson** » Mon Oct 13, 2008 11:59 am

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

ray.wurlod · Post by **ray.wurlod** » Mon Oct 13, 2008 3:50 pm

Observe that 0A (hex) is 10 (decimal). This is a regular UNIX newline (or linefeed if you prefer that terminology).

suneyes · Post by **suneyes** » Wed Oct 15, 2008 12:59 am

Thanks Mr.bcarlson.
this helped me in resolving my issue..
HEX 0A is unix new line charecter!
I wouldn't have known it..Thanks ray.

bcarlson · Post by **bcarlson** » Wed Oct 15, 2008 6:25 am

If the problem is resolved, make sure the mark the topic resolved, too!

Thanks!

Brad.