how to find special characters in database tables in db2

Have to use TRANSLATE funtion to find the special characters data in db2.


ex :

SELECT COL1,COL2
FROM TABLENAME WHERE LENGTH(TRIM(TRANSLATE(COL3,'`!@#$%^&*()_-+=|\}]{[":;?/<,>.',' '))) IS NULL


SELECT COL1,COL2,COL3,TRIM(TRANSLATE(COL3,'`!@#$%^&*()_-+=|\}]{[":;?/<,>.',' '))
FROM TABLENAME

How to know built in functions in Python

How to know the built in functions in Python ?

To know built in functions in Python type dir(__builtins__) press enter you will get all built in functions.

if you want to know how the functions works use Help to know the functionality
like
help(pow) it will display the functionality of particular function