ISQL and Menus

Posted in 1999

Topics: Stored Procedures & SPL, Platform-Specific Issues

Larry Kemmerling — Thu, 29 Apr 1999 09:18:37 -0700 (PDT) — source: Informix-list mailing list archive (1991-1998)

I haven't been able to find the answer to this in the documentation I have; perhaps someone has come across this. Using isql (not isqlrf), should all of the menus in the sysmenus table be listed when "User-menu" is selected? I'm able to view the menus I have by selecting "Modify", so I know they're in there. I'm also able to get a menu displayed by invoking isql in the following manner: isql <database name> -u <menu name> However, whenever I select "Run", I receive an error msg: 818: Specified user menu not found. No menus are displayed (before I make the selection), so I can't see how to specify a menu. I've opened a case with Informix (which has reached the 2nd level), but the engineer I'm working with hasn't come up with a definitive answer yet. I'm running isql v7.20.UD1 against ODS 7.30.UC3. The DB host is a Sparc20 running Solaris 2.6. TIA. Larry Kemmerling Product Systems Engineer AT&T Wireless Services Aviation Communications Division

↪ replying to Larry Kemmerling

Jonathan Leffler — Thu, 29 Apr 1999 22:20:17 -0700 — source: Informix-list mailing list archive (1991-1998)

Larry Kemmerling wrote: > I haven't been able to find the answer to this in the > documentation I have; perhaps someone has come across > this. > > Using isql (not isqlrf), should all of the menus in the > sysmenus table be listed when "User-menu" is selected? No. Same applies to isqlrf. > I'm able to view the menus I have by selecting "Modify", > so I know they're in there. I'm also able to get a menu > displayed by invoking isql in the following manner: > > isql <database name> -u <menu name> > > However, whenever I select "Run", I receive an error msg: > > 818: Specified user menu not found.> > No menus are displayed (before I make the selection), so > I can't see how to specify a menu. Read up on DBMENU, the environment variable. The presumed value if it is not set is 'main'. > I've opened a case with Informix (which has reached the 2nd > level), but the engineer I'm working with hasn't come up > with a definitive answer yet. > > I'm running isql v7.20.UD1 against ODS 7.30.UC3. The DB host > is a Sparc20 running Solaris 2.6. > > TIA. > > Larry Kemmerling > Product Systems Engineer > AT&T Wireless Services > Aviation Communications Division -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>