Adding character s to the column in db2

rahul678 · #1 (**permalink**) 11-11-09, 08:09

Hi,

I am new to db2.

I have the below query in oracle:

select column||"-"||1234||"-"||"LAST" from table where col2="something";

Here the result of the above query will be like "value-1234-LAST"

The same stuff I want in db2.

How to add some numerics or characters to the column which we are selecting from the table?

Please help me..

Thanks in advance

ARWinner · #2 (**permalink**) 11-11-09, 08:14

If the data type of "column" is char, varchar, etc, then the code you have should work. If it is not a character string data type (e.g. integer, date), then you will need to convert it to a string before you can concatenate to it.

Andy

rahul_s80 · #3 (**permalink**) 11-11-09, 08:20

9.7 provides you with implicit casting
IBM DB2 9.7 for Linux, UNIX and Windows Information Center

rahul678 · #4 (**permalink**) 11-11-09, 08:22

in db2 its not working the query which I gave? Can you please give an example in db2?

tonkuma · #5 (**permalink**) 11-11-09, 08:28

May be .....
column||'-'||'1234'||'-'||'LAST'

tonkuma · #6 (**permalink**) 11-11-09, 08:30

Or simply
column||'-1234-LAST'

rahul678 · #7 (**permalink**) 11-11-09, 08:38

No tonkuma, it will not work in db2.
In db2 we can give like
select concat(concat(column1,1234),'LAST) from table
But I need '-' in between those values..

How to get the - in between the columns?

Please help me..

ARWinner · #8 (**permalink**) 11-11-09, 08:45

What Tonkuma posted will work in DB2. Maybe you should post your actual query and the error you are getting. Also include what DB2 version and OS you are using.

Andy