wild cards in select statement

[amjain]

Hi,

I am trying to figure out, if select statement uses wild cards.
I want to find out all the tables having word *drm* in them.


Something like :

select * from syscat.tables where TABNAME='DRM*'

Thanks
Amit

 

[Harshvardhan]

Hi Amit,

You can use wild cards in the below manner.

select * from syscat.tables where TABNAME like '%%DRM%%'


Here is what u required.
===========
TABLE_NAME
DRMCSTGPOOLS
DRMEDIA
DRMMACHINE
DRMMACHINECHARS
DRMMACHINENODE
DRMMACHINERECINST
DRMMACHINERECMEDIA
DRMPSTGPOOLS
DRMRECOVERYMEDIA
DRMSRPF
DRMSTANZA
DRMSTATUS
DRMTRPF

 

[amjain]

Thanks Harsh