Datstage solutions, knowledge base, FAQ and best practices



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


Back to the list of all Datastage FAQ topics