Re: Determining Server/Client Version at RunTime

Jake Colman <colman@ppllc.com> wrote: > > When I type this into dbaccess I get > > "Unknown first argument of dbinfo(version)" Well, I thought it is in 7.x, but it is in 7.3. Sorry for that. Anyway it's a good idea to mention your server version and OS in the question. > > Also, where in the docs did you find this? dbinfo( 'version', ... ) documented in 7.3 SQL: Syntax p. 4-66 sysmaster:syssqscb is not documented (besides sysmaster.sql :-) Documented way, I suppose, should be some stored procedure with system call and your shell script will analyze output of onstat and create temporary table that you can check. AFAIK onstat -g sql returns 'F.E. Vers' column in 7.2x so you can get that info. I don't remember is it in 7.1x Best regards Vardan Aroustamian > > Thanx! > > ...Jake > > > >>>>> "Vardan" == Vardan Aroustamian <Vardan.Aroustamian@chase.com> writes: > > Vardan> Jake Colman <colman@ppllc.com> wrote: > >> > >> Is there a way for me to determine at runtime the client version I am > Vardan> running > >> and the version of server to which I am connecting? > > Vardan> Yes (assuming your server is 7.x) > > Vardan> select dbinfo( 'version', 'full' ) server, > Vardan> scb_feversion client > Vardan> from sysmaster:syssqscb > Vardan> where scb_sessionid = dbinfo( 'sessionid' ); > > >> > >> Thanx! > >> > >> -- > >> Jake Colman > >> > >> Principia Partners LLC Phone: (201) 946-0300 > >> Harborside Financial Center Fax: (201) 946-0320 > >> 902 Plaza II Beeper: (800) 505-2795 > >> Jersey City, NJ 07311 E-mail: colman@ppllc.com > >> E-mail: jcolman@jnc.com > >> web: http://www.ppllc.com > >> > > Vardan> Vardan > > Vardan> -- > Vardan> vaar@geocities.com > > -- > Jake Colman > > Principia Partners LLC Phone: (201) 946-0300 > Harborside Financial Center Fax: (201) 946-0320 > 902 Plaza II Beeper: (800) 505-2795 > Jersey City, NJ 07311 E-mail: colman@ppllc.com > E-mail: jcolman@jnc.com > web: http://www.ppllc.com > -- vaar@geocities.com