The following may be useful to substitute comparison operators into CASE WHEN statements.
If you have the following line in the job variable file:
comp = “>”
in the script:
CASE WHEN (COL001 @comp COL002) THE COL002 END AS COL001
will substitute the greater-than sign into the script post resolution, allowing for rapid and global changing of CASE WHEN behavior.