Re: Problem with SP

Robert Velter writes: -> ->Trying to execute the following statement i found in the ->'Guide to SQL, Reference book' on page 8-7 using 'dbaccess' ->produces: ->... -> ->Dbaccess stops with error number 581 and the cursor is ->blinking at lastname. This looks like the same problem you have with trying to turn set explain on when your Informix products have been installed in the wrong order. Now, if I remember Jonathon Leffler's acronym properly, the proper order is NET: Networking Engines Tools (Warning: I usually remember this order incorrectly, so someone please correct me this isn't correct - I don't actually install this stuff myself. Or maybe the acronym is TEN...) Anyway, check on the order, and reinstall your Informix products in the proper order. Good luck! Regards, - Cathy -------------------------------------------------------------------------------- Cathy Kipp e-mail: ckipp@vth1.vth.colostate.edu Phone: (303) 491-1294 Colorado State University Veterinary Teaching Hospital Fax: (303) 491-1205