Can hvr_op be used in expression where a calculation is performed?

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #18253
    Pallavik
    Keymaster

    Problem Summary:  Can hvr_op be used in expression where a calculation is performed?

    Description:

    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.

Viewing 1 post (of 1 total)
  • You must be logged in to reply to this topic.

© 2020 HVR

Test drive Contact us