| Author |
Message |
 Topic: Unconvertable character Error while Parsing JSON |
new2MB
Replies: 4
Views: 14768
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Thu Nov 02, 2023 2:21 am Subject: Unconvertable character Error while Parsing JSON |
I am facing similar issue. were you able to find the solution for this problem?
please share your feedback. |
| Topic: Select from database by comparing a column against list |
new2MB
Replies: 5
Views: 2425
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Aug 18, 2015 11:49 pm Subject: Select from database by comparing a column against list |
I want to know how can i pass a list in passthru.
How can i append a list to the character query.
When i right like this
SET chrQuery = 'Select * from dbo.MyTable where id in (' || Environmen ... |
| Topic: Select from database by comparing a column against list |
new2MB
Replies: 5
Views: 2425
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Aug 13, 2015 8:49 am Subject: Select from database by comparing a column against list |
for following query
select * from table 1 where id in(select t.id from Environment.Value[] as t)
on debug i can see CurrentSelect which select each row from table ad then compares to the inner ... |
| Topic: Select from database by comparing a column against list |
new2MB
Replies: 5
Views: 2425
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Aug 13, 2015 2:21 am Subject: Select from database by comparing a column against list |
Please help me to understand how can i right a select statement in esql if i want to select based on a list.
my select query is like this
Select * from table where column in (Environment.Variables ... |
| Topic: Unsupported type Error when selecting xml field from table |
new2MB
Replies: 3
Views: 3125
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jun 10, 2014 2:30 am Subject: Unsupported type Error when selecting xml field from table |
Query the XML column without any cast and see how the data looks like.
the query does not execute, it throws an excetion when executing the query
Text:CHARACTER:Unsupported SQL type
The below l ... |
| Topic: Facing issue when processing huge set of records |
new2MB
Replies: 9
Views: 3337
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jun 10, 2014 1:28 am Subject: Facing issue when processing huge set of records |
You do all this in one single Main() function? Or do you call a procedure for each record for doing the db retrieval and mapping?
not doing the Main call a procedure for db retrieval and mapping
... |
| Topic: Facing issue when processing huge set of records |
new2MB
Replies: 9
Views: 3337
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jun 10, 2014 1:25 am Subject: Facing issue when processing huge set of records |
What version of WMB (full version including fixpack)? Are you using SHARED variables to maintain any state?
version 8.0.0.2 |
| Topic: Facing issue when processing huge set of records |
new2MB
Replies: 9
Views: 3337
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jun 09, 2014 11:50 pm Subject: Facing issue when processing huge set of records |
Its a simple mapping in esql from the resultset retrieved from data base to set the values on outputroot to prepare the structure as required to wrtie into the file.
when i have adde some logging i ... |
| Topic: Unsupported type Error when selecting xml field from table |
new2MB
Replies: 3
Views: 3125
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jun 09, 2014 10:30 pm Subject: Unsupported type Error when selecting xml field from table |
please suggest how to select from a table with a column defined as xml.
when using a normal select getting Unsupported type error.
but works with passthru CAST (CAST(xmlData AS varchar(max)) AS te ... |
| Topic: Facing issue when processing huge set of records |
new2MB
Replies: 9
Views: 3337
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jun 09, 2014 10:25 pm Subject: Facing issue when processing huge set of records |
Sorry for not giving the details.
Explaination in detail:
we need to process a batch which consist of say 2 lac records
these records are spread over 3 tables
we need to pick 1 batch from tabl ... |
| Topic: Facing issue when processing huge set of records |
new2MB
Replies: 9
Views: 3337
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jun 09, 2014 10:10 am Subject: Facing issue when processing huge set of records |
We have a requirement where we need to process lacs of records.
we have implemented the logic as follows
1st flow : pick the records in bundle of 500, do some internal processing to map the records ... |
