Re: Stored Procedure Question

Sanjay Kumar asked: > Is it possible for change your password by invoking a Stored Procedure ? > I tried it by calling > SYSTEM passwd > but I get an error # 668 and ISAM Error 1. > Is there any way to get around this problem ? I use 7.12 on Dec Alpha 3.2. Yes it is possible, but not easy. The password program is looking for input from a tty device. You cannot send it imput from another program. However there is a very fine public domain program called "expect" that sets up tty input. One of the examples that comes with it is a script to change passwords. I have used this in stored procedures to creat and change passwords. You should be able to find "expect" on the net. O'Reilly also has a book "Exploring Expect" that talks about it. Regards - Lester ############################################################################# # Lester Knutsen lester@access.digex.net # # Advanced DataTools Corporation Voice: 703-256-0267 # # Grant group privileges for Informix databases with DB Privileges # # Visit our Web page: http://www.access.digex.net/~lester # # Washington Area Informix User Group: http://www.access.digex.net/~waiug # #############################################################################