| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| queries on WMI 6.1 |
« View previous topic :: View next topic » |
| Author |
Message
|
| vijayakumar |
 Posted: Wed Aug 18, 2010 5:00 am Post subject: queries on WMI 6.1 |
 |
|
Centurion
Joined: 01 Aug 2010
Posts: 101
|
IN WMB 5 , we can directly insert the values in db using
For eg :
if environment.variables.name = 'ram' then
INSERT INTO Database.TABLE1(MSGDATA, MSGENCODING, MSGCCSID)
VALUES (msgBitStream, inEncoding, inCCSID);
Is it possible to do as such directly in WMB 6.1 or we should use Passthrough as below ?
if environment.variables.name = 'ram' then
PASSTHROUGH(INSERT INTO Database.TABLE1(MSGDATA, MSGENCODING, MSGCCSID)
VALUES (msgBitStream, inEncoding, inCCSID)); |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Wed Aug 18, 2010 5:11 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
The syntax on both of those expressions is incorrect.
The INSERT statement did not drastically change between version 5 and version 6 and later that I recall.
What happens when you try this? |
|
| Back to top |
|
|
| vijayakumar |
| Posted: Wed Aug 18, 2010 5:27 am Post subject: |
|
|
Centurion
Joined: 01 Aug 2010
Posts: 101
|
Since i have v 5 , i tried it in that its working fine . I dont know abt in v 6.1 .
can anyone help me thos who r working in v 6 ? |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Aug 18, 2010 5:45 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| vijayakumar wrote: |
| Since i have v 5 , i tried it in that its working fine . I dont know abt in v 6.1 . |
As I said in your other post, the v6.1 InfoCentre has the details you need on version changes.
Also if you're planning (as you indicated there) to migrate from one version to the new one, the sensible course of action is to set up a migration test environment and try these things.
People have also tried something called "regression testing" to see if their set up will work on a new version or configuration. You could consider that as well.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| 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
|
|
|
|
