Skip to end of metadata
Go to start of metadata

 

Overview


To upload a DOS format data file from Unix/Linux server to the iloader, you need to convert the file using an editing program or dos2unix.

If the iloader is executed without conversion, the following error may occur.

In DOS format files, Row Termination Code is composed of CR (Carriage Return) + LF (Line Feed).

When the iloader parses the data file, it recognizes %n(LF) as a row terminator. So when uploading a data file in DOS format, a parsing error might occur.

 

When opening a DOS format file with vi in Linux/Unix, ^M is attached to the line or looks like the following:

"SYS_T.dat" [DOS] 225L, 33822C

 

How to remove


On Windows


  • In Windows, it can be converted using an editing program.

  • Ex) In UltraEdit, select File -> Convert ->'DOS->UNIX' and save

 

On Linux/Unix


Convert to unix type file using dos2unix.

  • The dos2unix command converts DOS/MAC files to UNIX format.

    Example
    File type comparison before and after dos2unix execution

Remove ^M using sed

  • Use sed to remove ^M as an iloader data file.

  • ^M must be entered as Ctrl+v+m.

    Example

Starting from ALTIBASE HDB 5.5.1 ...


From ALTIBASE HDB 5.5.1, it is possible to upload without file conversion/modification by using %r%n, which means CR+LF as a record separator.

Example

 

 


  • No labels