using substring and cast functions tpt apply stmt

Tools & Utilities
Highlighted

using substring and cast functions tpt apply stmt

Hi,

 

can we use substring and cast functions in apply stamt of tpt script. i am facing the below error.

it is pointing to the line i used substring in statement

 

TPT_INFRA: TPT04024: Error: Line 97 of Job Script File '/opt/ebi/qa/shellscripts/dbt_tpt_update_wrapper_sth_new.tpt':
Single pipe character ('|') encountered where double pipe expected.

1 REPLY
Teradata Employee

Re: using substring and cast functions tpt apply stmt

You might get more help if you show the line in error, in addition to the message.

 

Generally this error occurs when you use a single | in a context where the concatentation operator || would be valid.