Talend community forum / tOracleOutput -> append an existing value in database

guymage · 2012-06-26 06:04:19

Hi,

In update mode in a tOracleOutput , is there any option to append a value with an existing value in database ?

the coresponding SQL request would be:

Code:

 update myTable set aColumn = acolumn || 'hello' WHERE id = 123

Thanks !

Last edited by guymage (2012-06-26 06:07:35)

pedro · 2012-06-26 07:05:39

Hi

Code:

update myTable set aColumn = acolumn || 'hello' WHERE id = 123

What do you mean "append a value"?
I see you use "||" here. But I am confused...

Regards,
Pedro

guymage · 2012-06-26 07:27:17

I think aggregate is a better word

If in my database, the column acolumn get the value "I say "

after

Code:

update myTable set aColumn = acolumn || 'hello' WHERE id = 123

it will get "I say hello".

Nevermind, I think I will use a tOracleRow for that

pedro · 2012-06-26 07:31:41

Hi

Why don't do this update in tOracelOutput?
InputComponent-->tMap-->tOracleOutput

In tMap, modify the expression of the column 'acolumn' like row1.acolumn+"hello" and set the filter condition of out1 like row1.id == 123.

Regards,
Pedro

guymage · 2012-06-26 22:32:22

If you do the aggregate in a tmap, it means that you need to do a select before to get the value in database.

Announcement

Unanswered posts

#1 2012-06-26 06:04:19

tOracleOutput -> append an existing value in database

Code:

#2 2012-06-26 07:05:39

Re: tOracleOutput -> append an existing value in database

Code:

#3 2012-06-26 07:27:17

Re: tOracleOutput -> append an existing value in database

Code:

#4 2012-06-26 07:31:41

Re: tOracleOutput -> append an existing value in database

#5 2012-06-26 22:32:22

Re: tOracleOutput -> append an existing value in database

Board footer