test connect

Hi All, Is there any other alternative select statement just to check the database connection?. I'm doing "select count(*) from systables". IDS 9.4 Solaris 5.7 thank you,

Strict answer would be "yes"... You have tens of system catalog tables, each with a few columns... The combinations are "endless". But the important thing is... "What's the problem with that one?" Regards On Sat, Mar 23, 2013 at 12:47 PM, JACK PAPA <informix2009@gmail.com> wrote: > Hi All, > > Is there any other alternative select statement just to check the database > connection?. I'm doing "select count(*) from systables". > > IDS 9.4 > Solaris 5.7 > > thank you, > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --f46d043c7ca676b9ea04d897e2b5

In my utils_ak package is a utility, dbping.ec, that will test connections and connection time. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Sat, Mar 23, 2013 at 8:47 AM, JACK PAPA <informix2009@gmail.com> wrote: > Hi All, > > Is there any other alternative select statement just to check the database > connection?. I'm doing "select count(*) from systables". > > IDS 9.4 > Solaris 5.7 > > thank you, > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7b3438000560fe04d8a1c986