Home > IT Answers > AS/400 > Suffix a record using SQL
Rockleadme
385 pts.
 Suffix a record using SQL
AS/400 flat file, SQL/400
Hi guys, any ideas how to suffix a record (as400 flat file) using SQL? thanks

Software/Hardware used:
ASKED: September 9, 2008  4:18 AM
UPDATED: September 10, 2008  4:05 PM
RELATED QUESTIONS
Answer Wiki:
I'm not sure what you want but I'll give it a shot To suffix(???) all records Update Filea set fieldA = concat(trim(fieldA) ,'XXXX') Where XXXX is what you want on the end. Hope that helps
Last Wiki Answer Submitted:  September 9, 2008  1:58 pm  by  philpl1jb   44,630 pts.
All Answer Wiki Contributors:  philpl1jb   44,630 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

That answer is right as far as it goes. However, that will not extend the record beyond the defined file record length. If you are wanting to make the actual record length longer then you will have to do what he said but write it to a different file.

Vatchy
 1,410 pts.