MySQL Library Path Environment variable required in QP2TERM

While looking up a question from the blog we noticed that the QP2TERM access to the MySQL server did not work, it came up with an object missing ‘libmysqlclient.so.’. We thought we had set up the LIBPATH environment variable but on checking we found that it had somehow been changed. So just to make sure you can use the mysql request in QP2TERM, ensure you have the ENVVAR LIBPATH set to ‘/usr/local/mysql/lib’. To get to the variables used in PASE you can use the WRKENVVAR command from any i5 command line, plus checking to see what environment variables have been set you cal run ‘set’ in the QP2TERM environment to see what has been set already.

Chris…

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.