I am trying to create a virtual table that would only select the MAX of a column. I cannot find a way to use a function, e.g., MAX, on the columns that are selected in creating a virtual table.
For example:
EP_ID
300
400
150
277
I only want the row where EP_ID is 400.
Thanks in advance.
How to SELECT the MAX of a column in a virtual table?
How to SELECT the MAX of a column in a virtual table?
Last edited by truenorth on Fri Nov 11, 2016 9:07 pm, edited 1 time in total.
Todd Ramirez
Sr Consultant, Data Quality
San Antonio TX
Sr Consultant, Data Quality
San Antonio TX
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Not possible in version 8, in which the virtual table is driven only via a WHERE clause. Once you get version 11.5 you will have the full capabilities of SQL for virtual tables in Information Analyzer.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
IBM just had a webinar on this topic--SQL-based virtual tables--a few weeks ago; it is a new feature in version 11.5. It appeared to be command-line driven, with the idea of making the feature available in the IA GUI in a future release. We are also on version 11.3.1.2, so... not quite there yet.
Choose a job you love, and you will never have to work a day in your life. - Confucius
Ah, here it is...
IBM Tech Talk: Virtual Table Feature in Information Analyzer
https://www.youtube.com/watch?v=wBlg2tEB1bA
IBM Tech Talk: Virtual Table Feature in Information Analyzer
https://www.youtube.com/watch?v=wBlg2tEB1bA
Choose a job you love, and you will never have to work a day in your life. - Confucius