Suffix a record using SQL

385 pts.
Tags:
AS/400 flat file
SQL/400
Hi guys, any ideas how to suffix a record (as400 flat file) using SQL? thanks

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Vatchy
    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.
    1,410 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following