New Line after last record -- Copy to Flat File

Associate
Joined
21 May 2006
Posts
326
Hello

I have a sql that I am trying to run in ingres to copy the contents of a table into a flat file - this works fine however I want a carriage return following the last record.

The copy sql is as follows --

copy session.[tablename]
(rentref=c0,
rentaccnumber=c0,
recordtype=c0,
hbref=c0,
start_date=c0,
end_date=c0,
credghd_ict_rent=c0,
title=c0,
forename=c0,
surname=c0,
address1=c0,
address2=c0,
address3=c0,
address4=c0,
postcode=c0nl)
into '\\filepath\filename'

Could you point me in the right direction?

Thanks

J
 
Back
Top Bottom