SQL Function Support

Unanswered Question
Jun 19th, 2007
User Badges:

Does this function is support in the IPCC Script in the DB Get Step ?

SELECT MAX(expression )

FROM tables

WHERE predicates;

Using IPCC version 4.0(4)_Build140

Thanks


  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
lpezj Tue, 06/19/2007 - 05:41
User Badges:
  • Gold, 750 points or more

Hi,


I think that the best thing is that you try the query. You will need to deploy IPCC Express Premium version.


The Cisco documentation says this:


You cannot create Join queries that retrieve columns with the same name from

different tables. (For example, you cannot create ?select a.x, b.x from a,b? and

?select a.x as y from a?.) Similarly, you cannot make aliases of column names.

The SQL statements SELECT count(*) and SELECT min(*) are not supported.


So if select min(*) is not supported is lekely that select max(*) is no supported too. So the best thing, try it.


Hope this helps,


Juan Luis

smaruvada Wed, 06/20/2007 - 20:58
User Badges:

Depending on whether you have standard/premium/enhanced version, you can use the above query. If you can do DB dips, you should be able to run the above query w/o issues.


Sunil

Actions

This Discussion