[sqr-users] Line Terminators on flat files

[Peter_Wheeler@gov.nt.ca]

Hello,
I am trying to read in a flat file through SQR that has 4 fields, with
the last field being a long datatype. This field is anywhere from 100 to
4000 characters in lentgh. It consists of written paragraphs, including
most ascii characters, as well as numerous carraige returns. My field
separator is a 'pipe' - |. 
I cannot get SQR to properly read these 'long' lines of data as it
believes the CR is the line terminator. Is there a way for us to set the
line terminator to whatever character we want in the SQR?
Thanks

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users