Code: Select all
Specification: newcolumn=oldcolumnAs you note, the problem is reading from Oracle. Are you using direct read or SQL as the extraction method?
There may also be a problem in the Modify stage, but solve the Oracle issue first.
Code: Select all
Specification: newcolumn=oldcolumnCode: Select all
SELECT NAME FMT '48L' FROM DS_JOBS WHERE CATEGORY LIKE '<<Category Name>>%' AND NAME NOT LIKE '\\%';