Python

Python

Python

 View Only

  • 1.  How to Z/OS DB2 Queries using Python and Docker

    Posted Wed January 18, 2023 12:41 PM
    I am trying  to connect a DB2 instance(Z/OS), execute queries and then turn the results into Parquet files using Pandas.

    Does anyone happen to have experience doing this?  I am struggling just to get the ODBC drivers installed on my Mac so I can test locally.  I haven't even tried creating my Dockerfile yet.  I have experience using MS SQL Server, but I'm brand new to DB2.

    I'm wondering if any of you can give me some tips on installed the DB2 drivers in a Docker container and creating Parquet files from the results.

    ------------------------------
    KS
    ------------------------------


  • 2.  RE: How to Z/OS DB2 Queries using Python and Docker

    Posted Wed January 18, 2023 01:16 PM
    Hi Kurt,

    The likely answer you want for connecting to Db2 on z/OS from Python is to use the package ibm-db. Included on their github page is some instructions for creating docker containers using this package. You should be able to get any further help with using it there.

    ------------------------------
    Steven Pitman
    ------------------------------

    Original Message


  • 3.  RE: How to Z/OS DB2 Queries using Python and Docker

    Posted Thu January 19, 2023 10:49 AM
    Thank you Steven!

    ------------------------------
    Kurt Shull
    ------------------------------

    Original Message


Related Content