Re: User-menu option in Informix/SQL

Quoting RUCHI@CFRVM.CFR.USF.EDU... > > I would like to by-pass the screens so user would get the screen once the > USER-MENU and RUN options are selected. How would I use the ISQL command > to by-pass all the screens? > Try this... isql dbname -ur > Also, I would like to know how would I use the DBPATH command? We are new > with both AIX and INFORMIX. I have database located in /u/ruchi/billing. > We have a product INFORMIX-SE. I gave users access to these database files > using the GRANT command. But I would like user to enter one command to go > directly to user-menu lists. I am not too sure how would I accomplish this. > An example would help alot. > Create a small shell script that looks like this... Here --------- Snip Here --------- Snip Here --------- Snip Here --------- Snip # dbgo # Simple shell script which sets up the DBPATH and execs ISQL DBPATH=.:/u/ruchi/billing exec isql dbname -ur Here --------- Snip Here --------- Snip Here --------- Snip Here --------- Snip Then all your users have to do is type "dbgo". DAS -- David A. Snyder @ Snide Inc. - Folcroft, PA Current Release is db4glgen-3.2 UUCP: ..!uunet!das13!dave INTERNET: Dave.Snyder@snide.com