I'm starting to play around with python a little. I've run into small problems and have a couple basic questions.
I have python 2.7 and and just upgraded python3 from 3.4.6 to 3.6.9 .
I also have two different user profiles. QSECOFR level and a user level.
When I do a call qp2term with my user level profile I only see python 3.4.6
On my QSECOFR level I see python 3.6.9
However when I try to run a script from my QSECOFR level I keep getting
Error in sitecustomize; set PYTHONVERBOSE for traceback:
ImportError: rtld: 0712-001 Symbol SSL_CTX_set_post_handshake_auth was referenced
from module /QOpenSys/pkgs/lib/python3.6/lib-dynload/_ssl.so(), but a runtime definition
of the symbol was not found.
rtld: 0712-002 fatal error: exiting.
Python 3.6.9 (default, Oct 31 2019, 11:30:53)
I renamed the sitecustomize.py file, but as soon as I rename and refresh it is back to its original name.
That's my immediate concerns.
Now a couple of basic questions.
From python can I create spool files? Don't know if I want to just wondering!
Trying out a sample I found to create a spreadsheet, I found I needed to import xlsxwriter. I did not see that listed under the ACS Package manager, but was able to do a PIP Install. Just trying to understand when and why I should use ACS vs PIP.
Can I connect to sql server from python running on the I. I tried to import pyodbc, but it is failing. Should I be using this?
Can someone point me to some slightly more advanced example of connecting to db2 and creating a report.
Thanks
MIke
NOTICE: This message, including any attachment, is intended as a confidential and privileged communication. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender and delete this message.
midrange.com
