| Author |
Message |
 Topic: ESQL Trace |
prabhakarp
Replies: 1
Views: 3777
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jul 31, 2003 12:21 pm Subject: ESQL Trace |
I want to trace all or some SQL's in the compute node with substitute values. Can you please help me how to do if anybody knows.
ex: select password from Database.users as T where T.login='TEST ... |
| Topic: access database using IN Clause |
prabhakarp
Replies: 8
Views: 4597
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jul 31, 2003 10:00 am Subject: access database using IN Clause |
| CSD Level 03 |
| Topic: access database using IN Clause |
prabhakarp
Replies: 8
Views: 4597
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jul 31, 2003 9:02 am Subject: access database using IN Clause |
Kiran,
It is gicing syntax error.
BIP2402E: (330, 224) : Syntax error : '{'.
The token caused a syntax error. |
| Topic: How to handle inner Query's in select statement in ESQL |
prabhakarp
Replies: 2
Views: 2359
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jul 31, 2003 7:54 am Subject: How to handle inner Query's in select statement in ESQL |
Empeterson,
Thanks for your help. I used Environment tree, i am able to deploy but i am getting the some problem with the in Clause. 
DECLARE ARIBASUPP CHAR;
SET Environment.Varia ... |
| Topic: How to handle inner Query's in select statement in ESQL |
prabhakarp
Replies: 2
Views: 2359
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jul 31, 2003 7:33 am Subject: How to handle inner Query's in select statement in ESQL |
SET CEUREFITEM=
THE(select ITEM sp.sellerid from Database.SPREFCOUNT_VIEW as sp where sp.buyerid=UREFITEM and sp.buyerpartnum = BUYERPARTNUM and sp.userid in
(select AM.ARIBA_ID FROM Database.um.A ... |
| Topic: access database using IN Clause |
prabhakarp
Replies: 8
Views: 4597
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jul 31, 2003 5:27 am Subject: accessing Database using IN Clause |
We are using MQ 5.1 version.
DECLARE ARIBASUPP CHAR;
SET ARIBASUPP ='5296,5297';
SET CEUREFITEM= THE(select ITEM sp.sellerid from Database.SPREFCOUNT_VIEW as sp where sp.buyerid=100 and sp.b ... |
| Topic: access database using IN Clause |
prabhakarp
Replies: 8
Views: 4597
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jul 30, 2003 4:29 pm Subject: access database using IN Clause |
I am new to MQ. I am getting the exception, when i am trying to use IN Clause( Is it CASTing problem????) Can any body help me how to solve this problem.
DECLARE ARIBASUPP CHAR;
SET Environmen ... |
