| Author |
Message |
 Topic: DB statement issue |
chandu
Replies: 18
Views: 18008
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Sun Nov 07, 2010 6:37 pm Subject: DB statement issue |
| I am trying to use the value obtained from NEXTVAL function.I am using that value to be inserted in a column.The use of THE or ITEM with passthru did not work correctly.So i used the above described m ... |
| Topic: DB statement issue |
chandu
Replies: 18
Views: 18008
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sun Nov 07, 2010 1:06 pm Subject: DB statement issue |
Thanks all for your replies.It is working fine now.
Here is the solution.
DECLARE X ROW;
DECLARE Y INTEGER;(it is declared as NUMBER in Oracle)
SET X = Passthru('cast(select SEQ.nextval as VARCH ... |
| Topic: SSL CONCEPTS |
chandu
Replies: 5
Views: 10776
|
Forum: IBM MQ Security Posted: Mon Oct 18, 2010 12:53 pm Subject: SSL CONCEPTS |
| Thank you for your replies.I am able to use of the links provided. |
| Topic: DB statement issue |
chandu
Replies: 18
Views: 18008
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Oct 15, 2010 6:26 am Subject: DB statement issue |
SET Environment.x[] = PASSTHRU('Select test_seq.nextval from dual);
Insert into Database.schema.table(col1,col2) values(Environment.x[1],y);
The datatypes of col1 and col2 is NUMBER.
Result: It ... |
| Topic: DB statement issue |
chandu
Replies: 18
Views: 18008
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Oct 14, 2010 4:58 pm Subject: DB statement issue |
I declared X as Row type.
Let me put clear what i have done.
DECLARE X Row;
SET Environment.X = Passthru('select test_seq.nextval from dual');
insert into database.schema.table(column1,column2) v ... |
| Topic: Auto Sequencing from ESQL |
chandu
Replies: 21
Views: 29723
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Oct 14, 2010 9:38 am Subject: Auto Sequencing from ESQL |
| I am sorry.I will open a new thread. |
| Topic: Auto Sequencing from ESQL |
chandu
Replies: 21
Views: 29723
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Oct 14, 2010 8:25 am Subject: Auto Sequencing from ESQL |
I have a similar issue.I am using test_seq.
set environment.x = passthru('select test_seq.nextval from dual');
insert into database.schema.table(col1,col2) values (environment.x,y);
After execut ... |
| Topic: DB statement issue |
chandu
Replies: 18
Views: 18008
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Oct 14, 2010 8:08 am Subject: DB statement issue |
Sorry for tha first post which is not correctly posted.
set x = passthru('select * from test_seq.nextval from dual)
insert into database.schema.table(column1,column2) values (x,y);
When executed ... |
| Topic: DB statement issue |
chandu
Replies: 18
Views: 18008
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Oct 14, 2010 7:56 am Subject: DB statement issue |
i executed the same SELECT(' test_seq.nextval from dual') in oracle which is returning value.I am using a passthru in broker with the same above query.
I know it is returning NULL.My question is why ... |
| Topic: DB statement issue |
chandu
Replies: 18
Views: 18008
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Oct 14, 2010 6:11 am Subject: DB statement issue |
Hi,
I have the same issue. (split from [url=http://www.mqseries.net/phpBB2/viewtopic.php?t=721]this )
When using
set x = Passthru('select test_seq from dual');
insert into database.schema.table(c ... |
| Topic: DISTRIBUTED QUEUING CONCEPTS |
chandu
Replies: 11
Views: 12455
|
Forum: Clustering Posted: Sat Aug 15, 2009 11:18 pm Subject: DISTRIBUTED QUEUING CONCEPTS |
Ok,i will try making out all possibilities and let u know the result.
But one thing,
if a REMOTEQ and DLQ is not defined on QMGR_B and if the messaging type is persistent,then where does the message ... |
| Topic: DISTRIBUTED QUEUING CONCEPTS |
chandu
Replies: 11
Views: 12455
|
Forum: Clustering Posted: Wed Aug 05, 2009 9:58 am Subject: DISTRIBUTED QUEUING CONCEPTS |
I put the message on remote queue(RQ) defined on QMGR_A.But there is no local queue defined on QMGR_B.I did all the above in the MQ explorer.It did not generate any error message.
Question:
Where d ... |
| Topic: CLUSTER CONCEPTS |
chandu
Replies: 5
Views: 7219
|
Forum: Clustering Posted: Wed Aug 05, 2009 9:31 am Subject: CLUSTER CONCEPTS |
PLATFORM: WINDOWS XP,MQ version:6.0
On the MQ explorer,i could not see them under INVENTORY CLUSTER.
I opened the QM PROPERTIES by right clicking, i see that CLUSER tab is empty but REPOSITORY tab s ... |
| Topic: SSL CONCEPTS |
chandu
Replies: 5
Views: 10776
|
Forum: IBM MQ Security Posted: Wed Aug 05, 2009 9:24 am Subject: SSL CONCEPTS |
Hi,
Can anyone provide me the best step by step guide to set up the SSL conncetions between QMs.Thanks in Advance |
| Topic: DISTRIBUTED QUEUING CONCEPTS |
chandu
Replies: 11
Views: 12455
|
Forum: Clustering Posted: Wed Aug 05, 2009 9:21 am Subject: DISTRIBUTED QUEUING CONCEPTS |
In distributed queueing,
where does the messages go if local queue which retrives the messages is not accepting any messages or if No local queue is present.
i tried experimenting but i dont see it ... |
