We utilize several versions of WebFOCUS (from FOCUS Six up through 5.2.3). I'd like to sense the version of WebFOCUS so I can issue the correct SQLORA connection command. ? RELEASE does not do it. Any suggestions other than issuing all versions' connection commands and checking return codes?

Thanks!

hmmm ? VERSION, ? REL, and ? RELEASE are the only ones I know by executing them from the Command Console in Dev Studio. Maybe there's some type of "version" file on the server?

Interogate the &FOCREL variable

Seems like I can use ? VERSION or ? RELEASE if I can assume all releases show 'EDAnnn' as the first 6 chars of the return string. 4.3.6 shows only EDA43.... while 5.2.3 shows EDA523. Can anyone confirm that this is the convention for all releases?

&FOCREL seems to return values like:

R720523B or R720534B

Notice the 523 or 534 in the 5th, 6th and 7th positions.

There's also via the web console - suppose you can check out the HTML and maybe reconstruct how to get the version via the HTML call.

Don't assume anything. Here is the output from 7.1

********** OUTPUT FROM ? REL **********
EDA711 Release * Current Software:
EDA711 Release RELEASE = R720711B
EDA711 Release GEN_NUM = 121
EDA711 Release SOURCE_DATE = 10/05/2005 17:35:34
EDA711 Release BUILD_DATE = 10/05/2005 18:35:15
EDA711 Release INSTALLATION_DATE =
********** OUTPUT FROM ? VERSION **********
EDA711 Release * Current Software:
EDA711 Release RELEASE = R720711B
EDA711 Release GEN_NUM = 121
EDA711 Release SOURCE_DATE = 10/05/2005 17:35:34
EDA711 Release BUILD_DATE = 10/05/2005 18:35:15
EDA711 Release INSTALLATION_DATE =
********** OUTPUT FROM ? RELEASE **********
EDA711 Release * Current Software:
EDA711 Release RELEASE = R720711B
EDA711 Release GEN_NUM = 121
EDA711 Release SOURCE_DATE = 10/05/2005 17:35:34
EDA711 Release BUILD_DATE = 10/05/2005 18:35:15
EDA711 Release INSTALLATION_DATE =
********** OUTPUT FROM ? GEN **********
EDA711 Release * Current Software:
EDA711 Release RELEASE = R720711B
EDA711 Release GEN_NUM = 121
EDA711 Release SOURCE_DATE = 10/05/2005 17:35:34
EDA711 Release BUILD_DATE = 10/05/2005 18:35:15
EDA711 Release INSTALLATION_DATE =
EDA711 Release release = R720711B
EDA711 Release gen_num = 121
EDA711 Release source_date = 10/05/2005 17:35:34
EDA711 Release gen_build_date = 10/05/2005 18:35:15
EDA711 Release gen_buildsys = Windows 2000 5.0 Build 2195 Service Pack 3
EDA711 Release buildsys = Windows NT-5.0 x86 32bit
EDA711 Release supportsys = Windows
EDA711 Release media_type = 3595DB308B51C9C2
EDA711 Release license = REMOVED
EDA711 Release edahome = C:\ibi711\ibi\srv71\home
EDA711 Release workspace_manager_name = "WebFOCUS 71 Server"
EDA711 Release edaprfu = C:\ibi711\ibi\profiles
EDA711 Release approot = C:\ibi711\ibi\apps
EDA711 Release server_type = ffs
EDA711 Release scaroot = C:\ibi711\ibi\scale
EDA711 Release cfg_date = 10/26/2005 15:03:37
EDA711 Release SERVICE = DEFAULT
EDA711 Release BEGIN
EDA711 Release maximum = 10
EDA711 Release number_ready = 2
EDA711 Release END
EDA711 Release SERVICE = WC_DEFAULT
EDA711 Release BEGIN
EDA711 Release maximum = 2
EDA711 Release number_ready = 1
EDA711 Release maximum_q = 10
EDA711 Release END
EDA711 Release SERVICE = DFM_DEFAULT
EDA711 Release BEGIN
EDA711 Release maximum = 10
EDA711 Release number_ready = 0
EDA711 Release END
EDA711 Release sop_access = y

Thanks, all. Looks like I can use the first 6 characters of the return from ? REL.