16.20 - Example 2 – Double-Quoted Values in Job Variables - Parallel Transporter

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-27
dita:mapPath
uah1527114222342.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval

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.