Stored Procedure in DB2 CONCAT syntax

Posted on 2007-08-05
Medium Priority
Last Modified: 2013-11-05

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

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

is this correct?
Question by:jedistar

Accepted Solution

mkatmonkey earned 1000 total points
ID: 19636181
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'


Author Comment

ID: 19636195

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question