IBM Mainframe Forum

Mainframe Technical Support Forums

Skip to content


Shall we use variables in LIKE



IBM's flagship relational database management system
Post a reply

Shall we use variables in LIKE

Postby Shakthivel V » Sun Jul 18, 2010 3:38 pm

Hi.. Shall we use variables in LIKE

Example :


move 'mainframe' to variable-name

Select.................... like 'Variable-name%'


Is the above code will work??
Shakthivel V
 
Posts: 22
Joined: Thu Mar 04, 2010 12:12 am
Has thanked: 0 time
Been thanked: 0 time
Top

Re: Like

Postby dick scherrer » Sun Jul 18, 2010 10:31 pm

Hello,

Look here:
http://publibz.boulder.ibm.com/cgi-bin/ ... j10/2.22.7
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times
Top
Post a reply

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post
Forum Rules|FAQ|Subscriptions|Bookmarks