When using CPYTOIMPF, I can get a very nice CSV file except for one problem. I can't figure out how to remove the trailing blanks on text fields? For example, "Description" instead of "Description ". Any suggestions would be greatly appreciated. I'm on V4R5.
As far as I know and tested, the trailing blanks are trimmed. If one of the end-of-line character options is selected (ENDLINFMT(*FIXED) is not specified) the database file records are transformed to variable-length stream file text lines as they are copied. Each database file record is trimmed of any trailing blanks. Then, the data is converted to the destination data format (if specified) and the end-of-line character is appended to the end of the text line.
MORE INFORMATION ON THIS TOPIC
Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.
The Best Web Links: Tips, tutorials and more.
Check out this Search400.com Featured Topic: Networking and the iSeries
PC/Windows connectivity expert Shahar Mor is available to answer your toughest networking questions. Ask Shahar a question or read his previously answered questions here.