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.
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.