PREVIOUS

2.2. What is the DataStage equivalent to like option in ORACLE

The following statement in Oracle:

select * from ARTICLES where article_name like '%WHT080%';

Can be written in DataStage (for example as the constraint expression):

incol.empname matches '...WHT080...'

NEXT