SQL Function Support

Unanswered Question
Jun 19th, 2007

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

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
lpezj Tue, 06/19/2007 - 05:41

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

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