You are not logged in.
Announcement
Unanswered posts
|
- Index
- » Usage, Operation
- » tOracleOutput -> append an existing value in database
Post a reply
Topic review (newest first)
- 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.
- 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 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: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 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 !