string function - concat

bobjohnson360 · #1 (**permalink**) 01-10-06, 20:52

I have used concat many times in Oracle and just switched
over to DB2 personal.

Does this version support concat and if so how would I
concat a character field from 1000 to a1000.
ex:
update inventory set part = concat( 'a', part);

inventory - table.
part - field with 1000 value.

any ideas/ thanks
BJ

juliane26 · #2 (**permalink**) 01-11-06, 04:10

why not using the standard operator:

update inventory set part = 'a' || part;

works both on Oracle and DB2 and is SQL standard

Peter.Vanroose · #3 (**permalink**) 01-11-06, 04:19

DB2 also supports the CONCAT scalar function; "||" is actually a shortcut to that function.
You have to make sure, though, that both arguments of concat (or of "||") are of datatype "text"; if "part" is numeric, use

Code:

update inventory set part = concat( 'a', digits(part));

bobjohnson360 · #4 (**permalink**) 01-13-06, 16:35

All works well but when I try to insert a letter on the right hand side of the field' part' value it seems the blank spaces
create a problem.I increased the spaces from 10 to 15
but it still gave the same error message.

Do I have to rtrim blank spaces just before I conact when
inserting on right side , if so how?
error message:
SQL0433N Value "1000 a" is too long. SQLSTATE=22001

Thanks again
Bob