Problem Summary
Can hvr_op be used in expression where a calculation is performed?
Description
No. The variable hvr_op can only be used in basic substitution but cannot be used in an integrate expression where calculation is performed.
For example action ColumnProperties like below cannot be used in channel.
/Name=<column name> /BaseName=<column name> /Extra /IntegrateExpression={_}\{hvr_op\}+1{_}/Datatype=integer /Length=2
This will throw error below error in integrate job for update operation
F_JD2146: String '2+1' can not be converted into a number for column \[change\] of table \[testpallavi1\]. Use action TableProperties /CoerceErrorPolicy=SILENT /CoerceErrorType=OTHERS to silently set value to 0.
This will throw error like below for insert operation
F_JD2146: String '1+1' can not be converted into a number for column \[change\] of table \[testpallavi2\]. Use action TableProperties /CoerceErrorPolicy=SILENT /CoerceErrorType=OTHERS to silently set value to 0.