Re: [IBMiOSS] beginning python

On Mon, Dec 9, 2019 at 1:29 PM Smith, Mike <Mike_Smith@xxxxxxxxxxxxxxxx>
wrote:

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.

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