DSXchange

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.

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.

My apologies, Ray. Forgot to update the version. I think we are on 11.3.1.2. Not quite it?

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.

Thanks, guys. We'll be eagerly waiting for the GUI update. Meanwhile, would you have any material on the command line method?

Ah, here it is...

IBM Tech Talk: Virtual Table Feature in Information Analyzer
https://www.youtube.com/watch?v=wBlg2tEB1bA

Many thanks!