Re: [IBMiOSS] beginning python

I think you mean:
 
PATH=/QOpenSys/pkgs/bin:$PATH
 
[1]https://bitbucket.org/ibmi/opensource/src/master/docs/yum/#markdown-header-must-know-usage-notes-read-this-after-you-install
 

----- Original message -----
From: Kevin Bucknum <Kevin@xxxxxxxxxxxxxxxxxxx>
Sent by: "OpenSource" <opensource-bounces@xxxxxxxxxxxxxxxxxx>
To: IBMi Open Source Roundtable <opensource@xxxxxxxxxxxxxxxxxx>
Cc:
Subject: Re: [IBMiOSS] [EXTERNAL] Re: beginning python
Date: Fri, Dec 13, 2019 10:20 AM
 
You missed a colon in this.

Next I tried this
PATH=/QOpenSys/pkgs/bin/python3.6/$PATH

Should be
PATH=/QOpenSys/pkgs/bin/python3.6:$PATH

-----Original Message-----
From: OpenSource [[2]mailto:opensource-bounces@xxxxxxxxxxxxxxxxxx] On
Behalf Of Smith, Mike
Sent: Friday, December 13, 2019 10:10 AM
To: IBMi Open Source Roundtable <opensource@xxxxxxxxxxxxxxxxxx>
Subject: Re: [IBMiOSS] [EXTERNAL] Re: beginning python

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
[3]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][4]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][5]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][6]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
[7]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][8]https://amazon.midrange.com ;

References

   Visible links
   1.
[9]https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fbitbucket.org%2fibmi%2fopensource%2fissues&c=E,1,xMAJtel9dGa4lLXO3JNQayV04E0p_Jp1Chl3HBXcvrp0TDuBD3tEUxJToHBUYI2fQ3iCKDRRNJB_CAdKVokI3pDy1UEVI5QLpFzXGtl3lgBNdrA,&typo=1 ;
   2.
[10]https://linkprotect.cudasvc.com/url?a=https%3a%2f%2flists.midrange.com%2fmailman%2flistinfo%2fopensource&c=E,1,LWdph7MtCkdaX4uuwwuSQZ2fsCQKIezONYj7jlcpRJ71ApefNvqMpau0QmxlWkTUgi36yAgKKvZ3ZSE5FvZcubk8VcSTtDTCAJcZKuBfIiSDSfCU_3UP&typo=1 ;
   3.
[11]https://linkprotect.cudasvc.com/url?a=https%3a%2f%2farchive.midrange.com%2fopensource&c=E,1,CHmY0Q0zHRYmHG38bXgbGNDHMbW_5088EhgB9M3GakM8lE9nwmQkjo3bfUdGoc1u4Ff-jTmZykQmtKe91QYtvb1XMGqDupdZExwjq_EqGA,,&typo=1 ;
   4.
[12]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:
[13]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
[14]https://linkprotect.cudasvc.com/url?a=https%3a%2f%2farchive.midrange.com%2fopensource.&c=E,1,09F6ZF-tjXC2SwnLrcxYy2SorBfe8PKPqw6Nxwjq7oRrGRjkvzQxPGlxtnhwyul0qc7S1HndvMbcxHbMGYxQO7bGvHzte-sX52O3xdkXb5vNBf3dUD9J&typo=1 ;

Help support
[15]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:
[16]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.
--
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: [17]https://lists.midrange.com/mailman/listinfo/opensource ;
or email: OpenSource-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
[18]https://archive.midrange.com/opensource ;.

Help support midrange.com by shopping at amazon.com with our affiliate
link: [19]https://amazon.midrange.com ;

[[20]https://www.medtronsoftware.com/img/MedtronMinilogo.bmp ;]  Kevin
 Bucknum
                   Senior Programmer Analyst
                   MEDDATA / MEDTRON
                   120 Innwood Drive
                   Covington LA 70433
                   Local: 985-893-2550
                   Toll Free: 877-893-2550
                 [21]https://www.medtronsoftware.com ;

CONFIDENTIALITY NOTICE

This document and any accompanying this email transmission contain
confidential information, belonging to the sender that is legally
privileged.  This information is intended only for the use of the
individual or entity named above.  The authorized recipient of this
information is prohibited from disclosing this information to any other
party and is required to destroy the information after its stated need
has been fulfilled.  If you are not the intended recipient, or the
employee of agent responsible to deliver it to the intended recipient,
you are hereby notified that any disclosure, copying, distribution or
action taken in reliance on the contents of these documents is STRICTLY
PROHIBITED.  If you have received this email in error, please notify the
sender immediately to arrange for return or destruction of these
documents.
--
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: [22]https://lists.midrange.com/mailman/listinfo/opensource ;
or email: OpenSource-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at [23]https://archive.midrange.com/opensource ;.

Help support midrange.com by shopping at amazon.com with our affiliate
link: [24]https://amazon.midrange.com ;
 

 

References

Visible links
1. https://bitbucket.org/ibmi/opensource/src/master/docs/yum/#markdown-header-must-know-usage-notes-read-this-after-you-install
2. mailto:opensource-bounces@xxxxxxxxxxxxxxxxxx
3. https://ibmioss.ryver.com/application/signup/members/9tJsXDG7_iSSi1Q
4. https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fbitbucket.org%2fibmi%2fopensource%2fissues&c=E,1,mB0w-M9xirrK54yR7LJh37IV7fYd8Y6GkPwqJKd9jXSIUsfkF9CBhW3QuvjpGmFk_FFrzWh2o72JbFFWircYhnPMtQT_lqa-mTp4bRG2aRKJLwpAhj1p4A,,&typo=1
5. 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
6. https://linkprotect.cudasvc.com/url?a=https%3a%2f%2farchive.midrange.com%2fopensource%C2%A0.&c=E,1,ZXGUzOksxQmPGNOT_S01cLEa7LUeQ-AASYA4qLq7z4MOiVZl4P6fQxPz6WvNo8zK_lGatrgmuDfpxkFJiU4aE9dAYoOMfb0cEZNA64Ehi9Y,&typo=1
7. https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fmidrange.com&c=E,1,2BK7EU-8PJoKYPtk575vEkJ4WHt6Uylibd0aVyhCU7ejkz7Y05B4FEMNX3BOt-asarNVA_rGfSe7qwwaj1th386tzc4GoqGFr4nYEcnmTWUVwqjODbJ_bg,,&typo=1
8. https://amazon.midrange.com/
9. https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fbitbucket.org%2fibmi%2fopensource%2fissues&c=E,1,xMAJtel9dGa4lLXO3JNQayV04E0p_Jp1Chl3HBXcvrp0TDuBD3tEUxJToHBUYI2fQ3iCKDRRNJB_CAdKVokI3pDy1UEVI5QLpFzXGtl3lgBNdrA,&typo=1
10. https://linkprotect.cudasvc.com/url?a=https%3a%2f%2flists.midrange.com%2fmailman%2flistinfo%2fopensource&c=E,1,LWdph7MtCkdaX4uuwwuSQZ2fsCQKIezONYj7jlcpRJ71ApefNvqMpau0QmxlWkTUgi36yAgKKvZ3ZSE5FvZcubk8VcSTtDTCAJcZKuBfIiSDSfCU_3UP&typo=1
11. https://linkprotect.cudasvc.com/url?a=https%3a%2f%2farchive.midrange.com%2fopensource&c=E,1,CHmY0Q0zHRYmHG38bXgbGNDHMbW_5088EhgB9M3GakM8lE9nwmQkjo3bfUdGoc1u4Ff-jTmZykQmtKe91QYtvb1XMGqDupdZExwjq_EqGA,,&typo=1
12. https://linkprotect.cudasvc.com/url?a=https%3a%2f%2famazon.midrange.com%2f&c=E,1,3tPst-okaSP0u2iWyHNaqf5mqTZk4jws6RwyhnW3I4-Rxd9lH6gnv6Ua0o-BFMkFqJ0rxIpszCpUPGgFJvwAShYZf_LGbCJ7RtPtWM_k7IyJHw,,&typo=1
13. 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
14. https://linkprotect.cudasvc.com/url?a=https%3a%2f%2farchive.midrange.com%2fopensource.&c=E,1,09F6ZF-tjXC2SwnLrcxYy2SorBfe8PKPqw6Nxwjq7oRrGRjkvzQxPGlxtnhwyul0qc7S1HndvMbcxHbMGYxQO7bGvHzte-sX52O3xdkXb5vNBf3dUD9J&typo=1
15. https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fmidrange.com&c=E,1,NS-N3MBvHwFWZvlrqC7tXpqH6TNnRxnF4VAsUFPCd4IEppb4EVLns-EmAzZa7NsIR8Xd4VAT8vMVJIsCqIEbGSHPUQnI5HT1CpnG3F2Axa2KYeI_-B_ijEc,&typo=1
16. https://linkprotect.cudasvc.com/url?a=https%3a%2f%2famazon.midrange.com&c=E,1,PS-89TaIuJLK_Wxxrq5Sng_A8ZWwZULuQ7Jbn4bAnfY-seCVLZg5zkQ8SD5QdfjhEYKG6x7nhOXYc_tzdQxh0uSxz2FNm_5GThdYCgGP0VG5vQ,,&typo=1
17. https://lists.midrange.com/mailman/listinfo/opensource
18. https://archive.midrange.com/opensource
19. https://amazon.midrange.com/
20. https://www.medtronsoftware.com/img/MedtronMinilogo.bmp
21. https://www.medtronsoftware.com/
22. https://lists.midrange.com/mailman/listinfo/opensource
23. https://archive.midrange.com/opensource
24. https://amazon.midrange.com/