[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Overriding default end-of-line character for UNIX or WinNT



SQR Version: 3.0.18 (moving to 4.3.4)
DB: Oracle 8i
OS: UNIX Solaris 8 and Windows NT
App: PeopleTools 6.1

Situation:  I create an extract file from PeopleSoft (using SQR "Open $File as 
1 For-Writing" and "Write 1 from") running on an Oracle DB.  The SQR program 
can be run from a UNIX server or on a Windows client (and the resulting files 
are deposited in a UNIX or Windows directory, respectively).  When run on the 
UNIX server, the resulting extract file has a one-byte end-of-file marker which 
is HEX '0A' (line feed) and when run on Windows, each line is terminated with 
two bytes, HEX '0A' and '0D' (line feed/carriage return).   I believe this is 
all normal.

I would like my extract file to always have the same line termination 
character, no matter if I run it from UNIX or Windows.  Is there a way 
over-ride either OS file I/O default from SQR to force either '0A' or '0A 0D' 
from either UNIX or Windows?

Thanks,
Rob Talbert
Washington, DC