We are trying to send a Baan report as and ASCII file to a folder to be picked up by a SQL process. The SQL process is failing becuse the report file only has LF (line feed 0x0A) at the end of each line. The SQL programmer says it requires a CR/LF. No matter how I try to add the CR (0x0D) using cr$() or chr$(13) to the end of the report lines it does not end up on the output. Can this be done somehow?

Any help would be appreciated. Thanks.

U r transferring unix file in binary mode to windows machine . If u do it in ascii mode , it will be taken care off.

The file is being generated directly from Baan report on an AS/400 server to a windows machine. We are using a Baan Device that is setup as a 'Rewrite File', a 4GL Program of 'ttstpconv' and an Argument of 'ASCII'. Hope that helps.

Sometimes using the unix2dos or dos2unix takes care of this on a file. Then make sure the transfer is going as ascii as hitesh suggest.

This setup normally works in unix servers . Have no experience in AS/400 . But u can check/test the file transfer manually between server/client . Further try the same with server2client function in ottdllbw .

If still clueless just check whether spool file is on a network drive (mapped in server) .