Concat in Framework Manager

[nix10987]

Hi Guys,

I would like to ask for your help regading this issue. The issue happened when we tried to create new Query Subject or new Data Item containing concatenation of two columns in framework manager. Though it accepts the syntax CONCAT (str1, str2) and (str1||str2) it returns blank cells but when the columns are queried separately, it returns the expected values. The data type of those columns is VARCHAR and as we experienced, it didn't accept the function 'CAST' or 'CONVERT' to convert it into CHAR data type. We are only provided of the views and not the tables. And our database is DB2.

Should you need more details to analyze the problem further, please reply to my post.

Example scenario:
Column1-Column2
  01        532345
  02        673442
  03        123453

When i use the most basic approach, this is the result:

select concat(Table1.Column1, Table1.Column2) as Column3
from Table1

Result:

Column3
<blank>
<blank>
<blank>


Thanks in advance Guys! More power to you all!

[PRIT AMRIT]

Hope you have already tried something like below too?

Table1.Column1+'-'+Table1.Column2

[nix10987]

hi prit!

what output would it create?
i am expecting it to be like:

Column3
01532345
02673442
03123453

[blom0344]

Table1.Column1||Table1.Column2
though I would expect the concat function to work without a problem on varchar's

[PRIT AMRIT]

hi prit!

what output would it create?
i am expecting it to be like:

It would give you: Column1-Column2
You can also define as Table1.Column1+Table1.Column2, would give you Column1Column2