VERY URGENT:USE OF CONCAT WHILE WRITING A DQL

dctm_dev

Hi Mates,

Can anyone please tell me how can I use CONCAT while writing a DQL. Actually my requirement is that I want to display two string attribute values as a concated one. As an example suppose there is a query like:

select object_name,owner_name from dm_document where r_object_id='090030398000015b';

Now I want the value of object_name and owner_name in a single string like:

select concat(object_name,owner_name) as value from dm_document where r_object_id='090030398000015b';

But it is showing an error like: [DM_QUERY_E_SYNTAX]error:  "A Parser Error (syntax error) has occurred in the vicinity of:  select CONCAT("

Thanks in advance
dctm_dev

RajalakshmiGautam

Hi,

You cant concat values in dql.

You can write a dfc code to select the values and concat it.

Hope it helps.

Rajalakshmi