permaculture playing cards*
The moose likes JDBC and the fly likes Insert and retrieve new line character in DB2 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Insert and retrieve new line character in DB2" Watch "Insert and retrieve new line character in DB2" New topic
Author

Insert and retrieve new line character in DB2

Mahesh Srinivas
Greenhorn

Joined: Nov 22, 2008
Posts: 6
Hi,
I have a requirement in my project where I need to generate flat files to be sent to the bank for validation and for each record type in the flat file, I want to have a line separator inserted in the file. Now, the line seperator is configurable as a system option as per customers needs which is stored in the database (we are using DB2). Even though, I inserted '\n' (New line character) in the system option as a line separator, while retrieving from database through JDBC and appending to the flat file, it is not recognizing it as a new line character and simply appends '\n\ in the flat file.

Please suggest any solution for this.
 
Don't get me started about those stupid light bulbs.
 
subject: Insert and retrieve new line character in DB2
 
Similar Threads
\n or line.separator?
APPENDING A NEW LINE INTO A STRING FILE
Newline using FileWriter class
Newline using FileWriter class
need to ^M at end of file