Jack
Sorry I just saw your reply. A lot of replies to me from this list, never make it to my email.
I do often use Putty, but don't do bash. I'm not sure what it really is or what it does for me(topic for another day I suppose)
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
Don't call qp2term. Learn to login via SSH, set your shell to
/QOpenSys/pkgs/bin/bash and export TERM=xterm
with my user level profile I only see python 3.4.6
On my QSECOFR level I see python 3.6.9
echo $PATH and get back to us on both.
/* if I sign in with user mike and type python3, I get python 3.4.6
Path shows
/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin
/* if I sign in with user supermike and type python3, I get python 3.6.9
Path shows
/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin
PIP3 freeze under both users show
DEPRECATION: Python 3.4 support has been deprecated. pip 19.1 will be the last one supporting it. Please upgrade your Python as Python 3.4 won't be maintained after March 2019 (cf PEP 429).
appier==1.9.7
bottle==0.12.17
six==1.10.0
XlsxWriter==1.2.6
Next I tried this
PATH=/QOpenSys/pkgs/bin/python3.6/$PATH
Echo $PATH shows
/QOpenSys/pkgs/bin/python3.6//QOpenSys/pkgs/bin:/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/u/python3.6//QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin
My guess based on Craigs reply(which I realize he was doing virtual environments) was that I could change the path, then try to install xlxswriter and have it associated with python3.6. It did not
It tells me requirement already satisfied.
If I would be better suited moving this to ryver, let me know.
Thanks
Now a couple of basic questions.
From python can I create spool files? Don't know if I want to just
wondering!
You can do system stuff calling from Python to the surrounding env, and in
that env there is /QOpenSys/usr/bin/system
When one does fancy OS400 stuff from Python one often just calls into OS400
to run a CL.
And vice-versa.
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.
You use yum vs pip when pip won't install something that has to build
itself nicely and won't do so under PASE without tweaks. (Some of) those
are the packages IBM has yum'ed.
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?
pyodbc or yum install python3-ibm_db
Can someone point me to some slightly more advanced example of connecting
to db2 and creating a report.
We discuss this stuff all day on IBMiOSS on Ryver.
To autoenroll, visit
https://ibmioss.ryver.com/application/signup/members/9tJsXDG7_iSSi1Q
-----Original Message-----
From: OpenSource <opensource-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Kevin Adler
Sent: Monday, December 9, 2019 4:10 PM
To: opensource@xxxxxxxxxxxxxxxxxx
Subject: [EXTERNAL] Re: [IBMiOSS] beginning python
That's wrong, the openssl package does *not* ship any libraries so this is
useless. Besides, the python3 package should be pulling in the correct
dependencies automatically.
If you ever see a load error due to an unresolved symbol or similar error
coming from IBM RPMs, that's either a bug with setting LIBPATH and picking
up the wrong library (don't do this) or it's a packaging bug that should
be reported to [1]
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fbitbucket.org%2fibmi%2fopensource%2fissues&c=E,1,mB0w-M9xirrK54yR7LJh37IV7fYd8Y6GkPwqJKd9jXSIUsfkF9CBhW3QuvjpGmFk_FFrzWh2o72JbFFWircYhnPMtQT_lqa-mTp4bRG2aRKJLwpAhj1p4A,,&typo=1
----- Original message -----
From: Jack Woehr <jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx>
Sent by: "OpenSource" <opensource-bounces@xxxxxxxxxxxxxxxxxx>
To: IBMi Open Source Roundtable <opensource@xxxxxxxxxxxxxxxxxx>
Cc:
Subject: [EXTERNAL] Re: [IBMiOSS] beginning python
Date: Mon, Dec 9, 2019 2:54 PM
need to update OpenSSL to that version or newer.
yum install openssl
--
Jack Woehr
Absolute Performance, Inc.
12303 Airport Way, Suite 100
Broomfield, CO 80021
NON-DISCLOSURE NOTICE: This communication including any and all
attachments is for the intended recipient(s) only and may contain
confidential and privileged information. If you are not the intended
recipient of this communication, any disclosure, copying further
distribution or use of this communication is prohibited. If you
received
this communication in error, please contact the sender and
delete/destroy
all copies of this communication immediately.
--
This is the IBMi Open Source Roundtable (OpenSource) mailing list
To post a message email: OpenSource@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: [2]
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2flists.midrange.com%2fmailman%2flistinfo%2fopensource%c2%a0&c=E,1,mNM32Jq2CleRAkK3WCte55CRk-BJPS3PdBFLKry2iJ8twjl9xO7th5xn37GEObGpWWAnUS_NuS6eaZ5f5Z131BAV7N7Fe6XVHLvexgnjg0ym0-A,&typo=1
or email: OpenSource-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at [3]
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2farchive.midrange.com%2fopensource%c2%a0.&c=E,1,ZXGUzOksxQmPGNOT_S01cLEa7LUeQ-AASYA4qLq7z4MOiVZl4P6fQxPz6WvNo8zK_lGatrgmuDfpxkFJiU4aE9dAYoOMfb0cEZNA64Ehi9Y,&typo=1
Help support
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fmidrange.com&c=E,1,2BK7EU-8PJoKYPtk575vEkJ4WHt6Uylibd0aVyhCU7ejkz7Y05B4FEMNX3BOt-asarNVA_rGfSe7qwwaj1th386tzc4GoqGFr4nYEcnmTWUVwqjODbJ_bg,,&typo=1 by shopping at amazon.com with our affiliate
link: [4]
https://amazon.midrange.com
References
Visible links
1.
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fbitbucket.org%2fibmi%2fopensource%2fissues&c=E,1,xMAJtel9dGa4lLXO3JNQayV04E0p_Jp1Chl3HBXcvrp0TDuBD3tEUxJToHBUYI2fQ3iCKDRRNJB_CAdKVokI3pDy1UEVI5QLpFzXGtl3lgBNdrA,&typo=1
2.
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2flists.midrange.com%2fmailman%2flistinfo%2fopensource&c=E,1,LWdph7MtCkdaX4uuwwuSQZ2fsCQKIezONYj7jlcpRJ71ApefNvqMpau0QmxlWkTUgi36yAgKKvZ3ZSE5FvZcubk8VcSTtDTCAJcZKuBfIiSDSfCU_3UP&typo=1
3.
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2farchive.midrange.com%2fopensource&c=E,1,CHmY0Q0zHRYmHG38bXgbGNDHMbW_5088EhgB9M3GakM8lE9nwmQkjo3bfUdGoc1u4Ff-jTmZykQmtKe91QYtvb1XMGqDupdZExwjq_EqGA,,&typo=1
4.
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2famazon.midrange.com%2f&c=E,1,3tPst-okaSP0u2iWyHNaqf5mqTZk4jws6RwyhnW3I4-Rxd9lH6gnv6Ua0o-BFMkFqJ0rxIpszCpUPGgFJvwAShYZf_LGbCJ7RtPtWM_k7IyJHw,,&typo=1
--
This is the IBMi Open Source Roundtable (OpenSource) mailing list To post a message email: OpenSource@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2flists.midrange.com%2fmailman%2flistinfo%2fopensource&c=E,1,TFhlrk-AqDaYVHhenMMwPBMrK-IoCqDKHHxEboHTKa03TZi0Z8Fpaj71N4QFH3JQ9YbRaAjBoalaaFkX55Kia6fT-3fEh_gvBrsB-QilrosNohuUadGPqldB6A,,&typo=1
or email: OpenSource-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2farchive.midrange.com%2fopensource.&c=E,1,09F6ZF-tjXC2SwnLrcxYy2SorBfe8PKPqw6Nxwjq7oRrGRjkvzQxPGlxtnhwyul0qc7S1HndvMbcxHbMGYxQO7bGvHzte-sX52O3xdkXb5vNBf3dUD9J&typo=1
Help support
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fmidrange.com&c=E,1,NS-N3MBvHwFWZvlrqC7tXpqH6TNnRxnF4VAsUFPCd4IEppb4EVLns-EmAzZa7NsIR8Xd4VAT8vMVJIsCqIEbGSHPUQnI5HT1CpnG3F2Axa2KYeI_-B_ijEc,&typo=1 by shopping at amazon.com with our affiliate
link:
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2famazon.midrange.com&c=E,1,PS-89TaIuJLK_Wxxrq5Sng_A8ZWwZULuQ7Jbn4bAnfY-seCVLZg5zkQ8SD5QdfjhEYKG6x7nhOXYc_tzdQxh0uSxz2FNm_5GThdYCgGP0VG5vQ,,&typo=1
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
