| Author |
Message |
 Topic: Anonymous mixed content xml mapping |
Fayaz
Replies: 19
Views: 5848
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Wed Aug 24, 2011 9:39 am Subject: Anonymous mixed content xml mapping |
Ok tried it as below:
Target Source
ContentMaster
Entry
$db:select $db:select:db.dbo.Table_col1 = 1
for $db:select
col1 $db:select:db.dbo.Table_col1
... |
| Topic: Anonymous mixed content xml mapping |
Fayaz
Replies: 19
Views: 5848
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Aug 24, 2011 9:09 am Subject: Anonymous mixed content xml mapping |
| Check below for the map I have currently, what I can't figure out is what IF statement would I need here to eliminate the repeating elements for col2 & col3....I have tried occurences, exists etc. ... |
| Topic: Anonymous mixed content xml mapping |
Fayaz
Replies: 19
Views: 5848
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Aug 24, 2011 7:55 am Subject: Anonymous mixed content xml mapping |
I thought I did it above but here it is:
My resultsets are as below:
Col1 Col2 Col3 Col4 Col5
1 English Title - en 7 Blue - en
1 French Title -fr 7 Blue- fr
1 German Title -de 7 Bl ... |
| Topic: Anonymous mixed content xml mapping |
Fayaz
Replies: 19
Views: 5848
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Aug 24, 2011 7:07 am Subject: Anonymous mixed content xml mapping |
| How do I control the mapping, can't seem to find anything which would help me to get the required resultset.. |
| Topic: Anonymous mixed content xml mapping |
Fayaz
Replies: 19
Views: 5848
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Aug 18, 2011 6:41 am Subject: Anonymous mixed content xml mapping |
| hey guys...any updates on this? |
| Topic: Anonymous mixed content xml mapping |
Fayaz
Replies: 19
Views: 5848
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Aug 17, 2011 11:11 am Subject: Anonymous mixed content xml mapping |
| Thanks SM...I have edited my posts....hope it's easier to read now... |
| Topic: Anonymous mixed content xml mapping |
Fayaz
Replies: 19
Views: 5848
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Aug 17, 2011 10:01 am Subject: Anonymous mixed content xml mapping |
| Lance, what do you mean? |
| Topic: Anonymous mixed content xml mapping |
Fayaz
Replies: 19
Views: 5848
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Aug 17, 2011 9:36 am Subject: Anonymous mixed content xml mapping |
It is this:
<ContentMaster>
<Entry>
<Col1>1</Col1>
<Col3 Col2="English">Title - en</Col3>
... |
| Topic: Anonymous mixed content xml mapping |
Fayaz
Replies: 19
Views: 5848
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Aug 17, 2011 9:27 am Subject: Anonymous mixed content xml mapping |
| I can't use the occurence feature because that would choose only one value...what other message map functions can I use here to eliminate this? |
| Topic: Anonymous mixed content xml mapping |
Fayaz
Replies: 19
Views: 5848
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Aug 17, 2011 9:17 am Subject: Anonymous mixed content xml mapping |
| By using the message mapping node.. |
| Topic: Anonymous mixed content xml mapping |
Fayaz
Replies: 19
Views: 5848
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Aug 17, 2011 8:46 am Subject: Anonymous mixed content xml mapping |
Hi,
I have a DB select output which I am trying to map to a complex xml structure. Problem is I do have a couple of anonymous mixed content fields and it seems to be repeating in the XML structure ... |
| Topic: SQL Stored Procedures in DBInput or DataInsert nodes |
Fayaz
Replies: 19
Views: 8506
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jul 21, 2011 12:56 pm Subject: SQL Stored Procedures in DBInput or DataInsert nodes |
| I agree and that is surprising but it's not letting me select that checkbox option for stored procedures... |
| Topic: SQL Stored Procedures in DBInput or DataInsert nodes |
Fayaz
Replies: 19
Views: 8506
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jul 21, 2011 12:50 pm Subject: SQL Stored Procedures in DBInput or DataInsert nodes |
| In ESQL yes they are and I have built applications which query it but in mapping nodes sql server stored proc does not seem to be supported (tables are)......let me know if otherwise without going to ... |
| Topic: SQL Stored Procedures in DBInput or DataInsert nodes |
Fayaz
Replies: 19
Views: 8506
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jul 21, 2011 12:38 pm Subject: SQL Stored Procedures in DBInput or DataInsert nodes |
That is what the documentation says:
Relational database stored procedures
•
Map RDB stored procedure (written in any of the supported languages on the database)
•
Provide input for IN parame ... |
| Topic: SQL Stored Procedures in DBInput or DataInsert nodes |
Fayaz
Replies: 19
Views: 8506
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jul 21, 2011 12:32 pm Subject: SQL Stored Procedures in DBInput or DataInsert nodes |
| it says it only supports procedures from DB2 & Oracle...so I guess nothing for SQL procedures as yet? anyplace else this can be looked into? |
