topic concatenate in Application Development and Automation Discussions

concatenate

Former Member — Mon, 12 Feb 2007 05:29:56 GMT

Hi all,

How can i concatenate two fields at the time of fething from database .(ie in the select statement ).

for example : select a

from xxxx into table t_xx.

thanks & regards,

sandeep

Re: concatenate

Former Member — Mon, 12 Feb 2007 05:34:32 GMT

1) fetch data from dbtab into internal tab.

2)make a column for concatenate result field into internal field

3)try.....

loop at itab.
concatenate itab-field1 itab-field2 into itab-field3.
modify itab.
endloop.

Re: concatenate

Former Member — Mon, 12 Feb 2007 05:37:20 GMT

Hi,

You cannot have a concatenated result while fetching from database.

You have to do the concatenation manually after fetching all your records.

Regards

Subramanian

Re: concatenate

Former Member — Mon, 12 Feb 2007 05:38:08 GMT

you may do like this

select a b c into (v_a, v_b, v_c) from dbtab where a in s_a.

concatenate v_a v_b into V_result.

write : /v_result.<or fill the internal table.

endselect.

regards

shiba dutta

Re: concatenate

Former Member — Mon, 12 Feb 2007 06:08:01 GMT

SELECT a b c d e
             FROM xxxx
             into table t_xx.

LOOP AT t_xx.
CONCATENATE t_xx-a t_xx-b t_xx-c INTO t_xx-d.
MODIFY t_xx.
CLEAR t_xx.
ENDLOOP.

U can do like the logic above, u cant do in the select.