Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Export DB2 Data To Fixed Length Text File
John, We create fixed length files using the DB2 export in conjunction with the substr() function and the contact operator. I believe the syntax for the concat is a double bar ||. Your select would look like: db2 "EXPORT TO test1.txt OF DEL MODIFIED BY CHARDEL'' SELECT cast(adds_id as... -
Can I use sed to insert the newline (\n) character .....
I have a file ... Each line looks something like the following: 13212121 NEWLINE 121211 11112121 12121 What I want to do is replace the text 'NEWLINE' with the actual newline \n character. So my output will now look like: 13212121 121211 11112121 12121 I thought sed would be the best tool to...- dsearfass
- Thread
- Replies: 1
- Forum: General UNIX discussion
