This question already has an answer here:
JCL for Concatenate more than one dataset though sort Two days back I have written one JCL to concatenate 8 datasets into one dataset using JCL. I am going to post the JCL here so that I can have a reference for my own. Here the input files should be of same DCB parameter and all the input files are flat files. Important: In Excel 2016, Excel Mobile, and Excel Online, this function has been replaced with the CONCAT function.Although the CONCATENATE function is still available for backward compatibility, you should consider using CONCAT from now on. This is because CONCATENATE may not be available in future versions of Excel.
- DB2 comma separated output 7 answers
How do I concatenate multiple rows into a single row using SQL? My database is DB2
I want something like
Zo HasZo Hasmarked as duplicate by Andriy M, Daniel Hilgarth, Mahmoud Gamal, Taryn♦, bobsFeb 14 '13 at 0:02
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
2 Answers
try this
EDIT:in db2 you need to create function and then call it
and then call it here
echo_Meecho_Me