SYNON built in function *CONCAT

5 pts.
Tags:
AS/400
AS/400 Synon
Concatenate
Synon 2E
I need to combine several fields into one text field and thinking about using *CONCAT for that. However it seems that *CONCAT can only merge two fields at a time. If so it would mean a lot of code if I have ten fields to merge.

Am I understanding this correctly?

Thanks for any help!

Lars Holmberg

 

 

 



Software/Hardware used:
IBM/AS400, SYNON COOL:2E

Answer Wiki

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

This is similiar to another question I just answered.
use this link to get to it.

http://itknowledgeexchange.techtarget.com/itanswers/concatenate-many-char-varaibles/

Discuss This Question: 2  Replies

 
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
  • TomLiotta
    As far as I know, Synon *CONCAT concatenates two values. You might need nested functions to continue bringing more values into a single string. (But I haven't actually used Synon in the past decade.) You might also create your own 'user' function based on CharlieBrowne's earlier suggestion in another question. Tom
    125,585 pointsBadges:
    report
  • Yorkshireman
    True - like the RPG Concatentae, 2e concats 2 items a t a time into a third. But the advantages of tracebaility, guaranteed accuracy, and transparency of code outweigh the trivial need to stack up 10 lines of a concat - simple control of spacing too look - LCL.text500 = CONCAT(LCL.text1,LCL.text2,CND.*One) LCL.text500 = CONCAT(LCL.text500,LCL.text3,CND.*One) LCL.text500 = CONCAT(LCL.text500,LCL.text4,CND.*One) LCL.text500 = CONCAT(LCL.text500,LCL.text5,CND.*One) LCL.text500 = CONCAT(LCL.text500,LCL.text6,CND.*One)
    5,580 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