Stored Procedure in DB2 CONCAT syntax

Hi,

How do i do string join in CONCAT statement i.e

CONCAT(query, STRNAME + 'test 123');

is this correct?
jedistarAsked:
Who is Participating?
 
mkatmonkeyCommented:
Are you concatenating a field in your query or are you trying to concatenate the entire result set? To use it to concatenate two strings, you could use the "||" operator. IE for the last two fields you in your statement, you could do:

STRNAME || 'test 123'

0
 
jedistarAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.