User-menu option in Informix/SQL (fwd)

In article > From: 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? The syntax for this from the command line is: isql [-s] [database-name] -u[options] [user-menu-name] where -s: silent option suppressing all non-essential screen messages database-name: database name without the .dbs extension -u: calls the User-menu option of ISQL's Main Menu options: the first letter of the User-menu option like r for run user-menu-name: name of a user-menu you want to run An example to access the database mydata and run the user-menu mymenu: isql -s mydata -ur mymenu > > 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. > Assuming you are using a UNIX based system, set the DBPATH in each users .login or .profile to include the directory /u/ruchi/billing to access the database and then to other paths for the user-menu list like the following: .login: setenv DBPATH /u/ruchi/billing:.:/dir/user_menu_list:/other/directoriesor .profile: DBPATH=/u/ruchi/billing:.:/dir/user_menu_list:/other/directories > > Ruchi Patel > University of South Florida > Regards, Cris Schramm Texas Instruments, Inc. #include <disclaimer.h> 12501 Research Blvd., P.O. 149149, M/S 2078 Austin, Texas 78714-9149 TI MSG %RAMM@hub.dsg.ti.com TI Telephone (512) 250-4424 Fax Phone (512) 250-6051 Internet Cris.Schramm@hub.dsg.ti.com