[comp.databases] Informix DBMENU variable

rgsmeb@abcom.ATT.COM (Michel Behna) (07/28/88)

HELP!!!

Does anyone out there know how to set DBMENU correctly in Informix SQL
so that I can do:
	isql -u
instead of
	isql database -u main

Or am I totally mistaken about the use of DBMENU???

Thank you for your help.

-- 
Michel Behna	 rgsmeb@abcom.att.com	 |  ihnp4!{ncsc1,codas}!abcom!rgsmeb
" It is all right for man to make love, and it is all right for man to make
war, but he shouldn't try to do both at the same time."

davek@infmx.UUCP (David Kosenko) (07/29/88)

In article <6124@abcom.ATT.COM>, rgsmeb@abcom.ATT.COM (Michel Behna) writes:
> HELP!!!
> 
> Does anyone out there know how to set DBMENU correctly in Informix SQL
> so that I can do:
> 	isql -u
> instead of
> 	isql database -u main
> 
> Or am I totally mistaken about the use of DBMENU???
> 
> Thank you for your help.
> 
> -- 
> Michel Behna	 rgsmeb@abcom.att.com	 |  ihnp4!{ncsc1,codas}!abcom!rgsmeb
> " It is all right for man to make love, and it is all right for man to make
> war, but he shouldn't try to do both at the same time."


	No, you have the idea behind DBMENU correct.  What you need to 
do is set DBMENU to the first menu you want to run. Now, if that value
happens to be 'main', you are in luck, since that is the *default* value
(i.e., if you don't specify a menu name, 'main' is what User_menu will
look for.  Anyway, from there simply type:

	isql databasename -ur

at shell level and presto! you will be running your usermenu.  Now,
what could be easier (;-).
(actually, I think you pretty much had it right - you just left out
 the 'r' after the '-u' -- that stands for 'User_menu Run')

Must dash -
Dave
-- 
Disclaimer:  The opinions expresses herein are by no means those
 of Informix Software.
			"But a man's reach should exceed his grasp
 				or what's a heaven for ?"