using context varible in the toracleoutput edit schema

[Anonymous]

Hi ,

I'am trying to update a column in a table but this column is defined by a context variable.
The problem is that when executin my job the context variable is not recognized.it concider "context.nomColumn" as a column in a table.
Any help plz?

[vboppudi]

Please provide more details on this. What is your requirement and what you are trying to do in job. If possible job screen shot.

Regards,

[manodwhb]

@himateja,since you cannot call context variable in schema.when you do Ctrl+Space in the specific place if you get then you can specify the context variables else you could not. As per your requirement you need to go with different approach.so please explain the requirement.

[Anonymous]

Hi,

i need to develop job for bulk update operations for multiple tables so I a thought of using context variables so we can say what table for Talend to pick up and what columns to pick up and which column to update in the table.  But in tamp we cannot use context values to column names and in Toracle op also in scheme we cannot use context variables in dB column name space?

how can we achieve this

[manodwhb]

@himateja,are you going to have same column in all tables and update the same coulmn?

[manodwhb]

@himateja,based on your requirement you can use tOracleRow. please check the below link.

https://help.talend.com/reader/wDRBNUuxk629sNcI0dNYaA/CCdn1_oSeiCZt4Q2dZ1RSg

https://help.talend.com/reader/wDRBNUuxk629sNcI0dNYaA/WN0YcNvB1H0c15B8azu74w?section=Raa48944

[manodwhb · Accepted solution]

@himateja,based on your requirement you can use tOracleRow. please check the below links.

https://help.talend.com/reader/wDRBNUuxk629sNcI0dNYaA/CCdn1_oSeiCZt4Q2dZ1RSg

https://help.talend.com/reader/wDRBNUuxk629sNcI0dNYaA/WN0YcNvB1H0c15B8azu74w?section=Raa48944

[Anonymous]

hi,

but if we use toraclerow it will impact performance since it will update every row.we cant commit like 10000 to 100000 colums right?

[manodwhb]

@himateja,tOraclerow will work in how DB Query will work,since you can call the commit statement after Insert/Update query.

[manodwhb]

@himateja,did it help you?