| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Mapper with *distinct* in SQL query ? |
« View previous topic :: View next topic » |
| Author |
Message
|
| shashivarungupta |
 Posted: Wed Dec 17, 2014 2:28 pm Post subject: Mapper with *distinct* in SQL query ? |
 |
|
Grand Master
Joined: 24 Feb 2009
Posts: 1343
Location: Floating in space on a round rock.
|
Hi,
I wonder, when mapping is used to fetch the data from database table(s) along with where clause, it doesn't have a feature to use 'distinct' keyword there in the SQL query section ?
Need to understand if WMB (v8.0.0.4) Mapping can provide any feature to get the distinct value(s) from database table(s).
Matter of fact, I've checked the fixpacks for 8.0.0.4 and this link where it doesn't give the hint of something is being fixed (in the past) related to SQL 'distinct' keyword, that denotes WMB Mapper can use it ? Or there is different understanding ?
Appreciate your suggestions.
_________________
*Life will beat you down, you need to decide to fight back or leave it. |
|
| Back to top |
|
 |
| martinb |
| Posted: Fri Dec 19, 2014 9:02 am Post subject: |
|
|
Master
Joined: 09 Nov 2006
Posts: 210
Location: UK
|
The Graphical Data Mapper Database Transforms currently allow you to define the columns, table and WHERE clause.
The SQL DISTINCT statement is not part of the Where clause.
If you need full control over the SQL statements your options are
- wrap it in a Stored procedure, but note only IIB v9 supports calling these from a Graphical Map, and support is currently only with DB2
- use a compute node
If you feel this should be available in a Graphical Map you could post a RFE |
|
| Back to top |
|
|
| shashivarungupta |
| Posted: Sun Dec 21, 2014 1:26 pm Post subject: |
|
|
Grand Master
Joined: 24 Feb 2009
Posts: 1343
Location: Floating in space on a round rock.
|
| martinb wrote: |
The Graphical Data Mapper Database Transforms currently allow you to define the columns, table and WHERE clause.
The SQL DISTINCT statement is not part of the Where clause.
If you need full control over the SQL statements your options are
- wrap it in a Stored procedure, but note only IIB v9 supports calling these from a Graphical Map, and support is currently only with DB2
- use a compute node
If you feel this should be available in a Graphical Map you could post a RFE |
Thanks for that, I've posted the comment there. 
_________________
*Life will beat you down, you need to decide to fight back or leave it. |
|
| 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
|
|
|
|
