Tag Archive for: Python

Alan Seiden

Seiden Group Now Supports Mapepire for Node.js and Db2 for IBM i Connectivity

/0 Comments/in /by

Mapapire database driver for IBM iSeiden Group is pleased to announce that we now provide production support for the open source Mapepire database connector for IBM i. This includes support for Node.js applications and cloud-based or containerized workloads that connect to Db2 for i—whether from IBM i itself or from external systems.

Many developers already rely on Mapepire every day—sometimes without realizing it—because it’s the back-end to the Db2 for i extension for VS Code. We’re excited to help clients adopt this lightweight, high-performance connector.

Read more →

Richard Schoen

New QSHONI Commands: Integrate Python, PHP, Java with CL & RPG

/0 Comments/in /by

QSHONI integration for IBM i RPG, CL and open sourceA few years ago I introduced you to my QShell on i utility – QSHONI. QSHONI makes it easy for traditional CL, RPG, and COBOL programs to call Python utilities and other QShell/PASE utility programs (PHP, Node, Java, etc.) and directly use their output. QSHONI opened up a whole new world of integrations to open-source apps from traditional IBM i applications.

I keep thinking I will run out of interesting things to add to the library, but the ideas keep on flowing.

Read more →

Richard Schoen

Call/Parm Your Open Source Apps from RPG and CL with QSHCALL

/2 Comments/in , , , /by

QSHONI integration for IBM i RPG, CL and open sourceA few years back I created the QShell on IBM i (QshOni) project to allow QShell/PASE (open source) apps to be more easily integrated and used with traditional IBM i job streams written in RPG and CL. Since then, many developers have adopted QshOni to utilize their open source apps in conjunction with their classic traditional apps.

Recently I added several new commands to QshOni to make living the PASE life even easier for RPG developers. Today’s focus will be on the QSHCALL command.

Read more →

Amy Lantz

IBM i API Examples Using RPG, Node.js, PHP, and Python

/0 Comments/in /by

The Toronto User Group recently invited Alan to speak with them about how to implement secure, flexible APIs to connect IBM i applications to other systems.

Using several real-world code examples written in various free tools and languages—including RPG, PHP, Python, and Node.js—Alan demonstrated how others send and receive data safely using their favorite language paired with IBM i business logic. This video contains the details.

Read more →

Amy Lantz

What’s New in Open Source on IBM i

/0 Comments/in , /by

Open source on IBM i is moving fast these days. Alan recently shared his favorite updates to IBM i open source—focusing on improved security, performance, and ease of programming—at a Summit Lunch & Learn hosted by Paul Tuohy.

Read more →

Richard Schoen

curl Your RPG Apps with QSHCURL

/2 Comments/in , , /by

curlIn this post we’ll take a closer look at how IBM i developers can use the QSHCURL command to easily reach out from CL or RPG and talk to internet-based services and APIs, then consume the resulting data, without a lot of extra effort.

First we’ll provide a short curl intro, and then we’ll look at an example of how to use the PASE-based curl command with an RPG program.

Read more →

Amy Lantz

Tips for Fast, Reliable Open Source on IBM i

/0 Comments/in , /by

Open source continues to gain traction in IBM i shops, and for good reason. It excels at delivering new interfaces and functionality for RPG and COBOL applications, plus it broadens the talent pool for your development team.

Read more →

Alan Seiden

Encrypting IBM i ODBC Connections from Linux with TLS/SSL

/0 Comments/in , /by

ODBC with Db2 for IBM i

ODBC connections between Linux and IBM i should be encrypted to keep their Db2 data safe in transit.

To encrypt ODBC data, IBM recommends the industry-standard TLS encryption protocol (the successor to SSL).

Read more →

Calvin Buckley

ODBC Connection Strings for IBM i Db2

/12 Comments/in , /by

ODBC with Db2 for IBM iAs ODBC gains popularity for IBM i database access, developers of web applications and APIs need information on defining ODBC database connections. This article demonstrates tips and techniques for effectively using ODBC connection strings in all programming environments, including popular languages such as PHP, Python, and Node.js.

For an example of how connection strings are used in a program, see How to Query IBM i Data with PHP and PDO_ODBC.

Read more →

Amy Lantz

VS Code for IBM i: A Resource Guide

/26 Comments/in , /by

Code for IBM iVS Code for IBM i makes IBM i a powerful environment for modern developers. Code for i supports development in RPGLE, COBOL, JavaScript, PHP, Python, Node.js and much more, while including a Db2 for i SQL interface and other powerful tools, and a community of forward-thinking developers and leaders.

Read more →