Re:Get Server Version, Programmatcially

Posted in 1997

sujata_soman_at_omm-la2-infotech-001@internet.omm.com — 19 Nov 1997 13:13:04 -0500 — source: Informix-list mailing list archive (1991-1998)

Dave, Here's your query. " Select owner from systables where tabname matches "*VERSION*" The reason I put the matches clause in there is that in 7.23UC1, I noticed that the VERSION table had a leading blank. I do not remember noticing that before. Hope this helps Sujata ____________________Reply Separator____________________ Subject: Get Server Version, Programmatcially Author: "Chez David" <dmitchell@SagentTech.com> Date: 11/18/97 10:04 PM Hey, Does anyone have any info on how to programmatically get the RDBMS's version number? Like, 7.2.0.something? Or, if there is not a function, is there another way? TIA Dave