| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| SELECT stmt with wild cards???? |
« View previous topic :: View next topic » |
| Author |
Message
|
| mbprimer |
 Posted: Wed Apr 11, 2007 9:59 pm Post subject: SELECT stmt with wild cards???? |
 |
|
Novice
Joined: 25 Mar 2007
Posts: 21
|
Hi all,
I have a table(InfoTable)with 3 records .
field1 field2 field3
ABA11 XXX YYYY
ABB11 YYY ZZZZ
ABC11 ZZZZ ZZZ
i want to store all these 3 records in EV by using
SET E.V.Data[] = (SELECT T.field1,T.field2,T.field3 FROM datasource.InfoTable AS T WHERE T.field1 = 'AB%');
I am wondering how to use wild-cards in select stmts.?
thanks.[/list] |
|
| Back to top |
|
 |
| elvis_gn |
| Posted: Wed Apr 11, 2007 10:17 pm Post subject: Re: SELECT stmt with wild cards???? |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi mbprimer,
| mbprimer wrote: |
SET E.V.Data[] = (SELECT T.field1,T.field2,T.field3 FROM datasource.InfoTable AS T WHERE T.field1 = 'AB%');
I am wondering how to use wild-cards in select stmts.? |
So did it work, what error did you get ?
Try this
| Code: |
| SET E.V.Data[] = (SELECT T.* FROM Database.InfoTable AS T WHERE T.field1 LIKE 'AB%'); |
Regards. |
|
| Back to top |
|
|
| mbprimer |
| Posted: Fri Apr 13, 2007 10:32 am Post subject: SELECT stmt |
|
|
Novice
Joined: 25 Mar 2007
Posts: 21
|
Thanks Elvis,
it's working. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
