SQL Function Support

e.silva_2 · ‎06-19-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

lpezj · ‎06-19-2007

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 · ‎06-20-2007

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