My DB model looks like this (In adabas it is a single file with an MU field in it):
In CONNX, it looks like this:
table1 - master table
table1-MU1 - this is the child table to table1
The relationship between table1 and table1-MU1 is 1:many
I like to have a select statement that returns to me a single row of table1 and in each row, I like to have the values of the MU column return to me in comma-delimited value.
For example, table1 has a row with col1 = “Smith” and isn = 1
In table1-MU1, isn_table1 of 1, I have these rows:
I would like the select to return this row back to me like this: Smith first,second,third instead of
I do not know how to craete a temp varaiable in a select to concatenate or coalesce the values.
The number of rows for each isn in table1 varies so I cannot hardcode col10(1), col10(2), etc.