ESCAPE clause in SQL DB2

ESCAPE in DB2 Mainframes:

In SQL the percent sign(%) and the under score(_) has special meaning.

%’ – represents any set of characters

_ – under score represents any single character.

Ex: select * from emp
where email like 'reddy_%';

This will display all the email ids starting with reddy like reddy123,reddy_34 etc. But here the requirement is to display the email ids starting with ‘reddy_’.

As in db2 underscore represents a single character it displays all the mail ids starting with reddy.

In such scenarios ESACPE clause is used to get the original meaning of _ or %.

By using the ESACPE the SQL looks like below:

select * from emp

where email like ‘reddy+_%’; ESCAPE ‘+’;

Now the above SQL displays only the mail ids starting with ‘reddy_’ like reddy_123, reddy_345 etc.

Get the full details  @

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/DSNSQ0F4/3.15.6.3