× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. OPENSOURCE
  3. December 2019

Re: [IBMiOSS] [EXTERNAL] Re: beginning python

Your path is still borked. If you haven't sign off and back on. How are you getting in again? SSH, STRQSH, or CALL QP2TERM. If my phone doesn't start going crazy, I'll try and work up a simple example program for you.

Some light reading for you.
https://bitbucket.org/ibmi/opensource/src/master/
https://bitbucket.org/ibmi/opensource/src/master/docs/troubleshooting/SETTING_PATH.md


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

So I did.
I changed the path now I get
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).
Collecting xlxswriter
ERROR: Could not find a version that satisfies the requirement xlxswriter (from versions: none)
ERROR: No matching distribution found for xlxswriter

Echo $PATH shows
/QOpenSys/pkgs/bin/python3.6:/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

-----Original Message-----
From: OpenSource <opensource-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Kevin Bucknum
Sent: Friday, December 13, 2019 11:20 AM
To: IBMi Open Source Roundtable <opensource@xxxxxxxxxxxxxxxxxx>
Subject: Re: [IBMiOSS] [EXTERNAL] Re: beginning python

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 [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
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fibmioss.ryver.com%2fapplication%2fsignup%2fmembers%2f9tJsXDG7_iSSi1Q&c=E,1,AZW6bIQhvNkL4_kGhG3HKkpKRcZr3U6-Z_V78i8--PniMyIHjJGWHEOS-kJ-gglVepw00DzkT5fzeoK6jU1hH0xAFlgYClHPQQupr1FNVus,&typo=1

-----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://linkprotect.cudasvc.com/url?a=https%3a%2f%2famazon.midrange.com&c=E,1,6w_sLUAG2HjCA9D20dtfbvikUTMaKef0Umpid0uTkxH3Vcv_ifm5jxDsCD8EwPYHEdwn5ajIvxHTYplV2ANHz4Jz6JvAGP0iZFO5FJNj-qCSDQ,,&typo=1




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.
--
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,rnKChKK5KxUc2a4uhYLk9o16ex8FwE_S4c_840TeeIGxnKD-NPlmqtkFngk7S3aOUKw-P8GzHlHli4V-PIzY5goWrSS-cGfzZpC3AoGMpmp6bs9snBbXBsE,&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,d0vEoMWFXfWmue4ZkaciMqHrvDRUzgkVMp_AKT7ncaeF-QOa7G0gqLI2WNY6JZ9i9DHdsBR9LynH22Bwu-SRn9I44dWuHnfUYIlMgJvb96eU&typo=1

Help support https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fmidrange.com&c=E,1,qwVOa_7-_044f2f1kECWWKSt_IbBp3KSF6KEY_zqA3nygeSHAyb2X0AL8rA3E2J9i_3PI9HjJFAwVqqCvr1WLKR1t2dLmqfMXZOr5_mo1Y4lgl1noCcA2e697sJt&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,6Rw5aacpPmDTO99Wxi1ZM6n-7O4smmBUgB11_d-JMmApIhdpvbTYOwZ74ZdHUKgQ0WFg7ra_1j6Rye6jWKMYkEYlsZsFF1JdrHrWeMIF&typo=1


[https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fwww.medtronsoftware.com%2fimg%2fMedtronMinilogo.bmp&c=E,1,08PXC1sIsY0KTQtvl8jxdcJ5LDoF1RVhH-fOFViidW5b_uHNwwAdr99WxAzrh3wHOR8YzZwjOBFSe7aDm5BfHIx74mxgCTJxYnIJUIELBYM7Rj21SA,,&typo=1] Kevin Bucknum
Senior Programmer Analyst
MEDDATA / MEDTRON
120 Innwood Drive
Covington LA 70433
Local: 985-893-2550
Toll Free: 877-893-2550
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fwww.medtronsoftware.com&c=E,1,c8_waIgv8_Lam4YAuvtfOwTWdgBZFZbpKB71COFYKBNt_jB_xXdZKjjiX0MenNzamTBvStXOqA6AteuvkGpBglB2mLIDGvmf26-zwmgxgjeqjnnY&typo=1



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: https://linkprotect.cudasvc.com/url?a=https%3a%2f%2flists.midrange.com%2fmailman%2flistinfo%2fopensource&c=E,1,TLH7IuIVBRcfFMvylJAN-KP9B5YABkJJ-JJppEJ7grJijnY3wPajBDeRdlYVO1PTATFuDgXB2U2RZK-a9I-eqVfalI-jMJRdaDYqFa9VaL8o&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,3FAwcYOZnt6m9EqDgqHLoK9CKX4qfrMPuwDozrcnN7LrzF__HFEmNBlVm1h9zudrhC19Tomnp6g_B2OXvUKkW1nhrwNUItJwhTZR72ahEjm0f2pY3Jdufbd2HQ,,&typo=1

Help support https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fmidrange.com&c=E,1,qEeBhPNTFVEgLPSwu-hRguBwuSmY34tu6qV4MSv53cWZBtJbYOCBmj9bkn0ko7DMErL9Rd7z36WZtDTv7wEyIegNN7sSdWa8ANut-P8mh--svw,,&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,st8co09fHEDc_XpBxEWMPwXsKBKYRL9pibGuMyHltFFpv2e244sWSqe3LQlDqdnU8g7HeR2rKhLtYTlMooJkq-qaj_ZeaKooE33JLaI5pS4D9asQMp-aZRjOn1s,&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: https://lists.midrange.com/mailman/listinfo/opensource
or email: OpenSource-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://archive.midrange.com/opensource.

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


[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
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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.