qshell Archives - IT Jungle

Guru: Copy From Stream File FMTOPT(*NOCHK)

April 13, 2020 Bob Cozzi

Using SQL frequently, as I do, I tend to look for solutions to problems that can be resolved using the database language (i.e., SQL). Sometimes I have to invent a missing piece of the puzzle. Often that entails writing a User-Defined Function (UDF) for use in SQL, but sometimes a CL command is the better choice.

Recently I had a situation where what the client calls an “EDI File” was being downloaded using sftp on the IBM server running i. This file is created at a vendor that runs IBM mainframes (an actual mainframe by the way) and the file …
Read more
Guru: Passing Parameters To Python

August 5, 2019 Mike Larsen

Python scripts offer great benefits to developers, whether used standalone or in conjunction with RPG programs. As I’ve been exploring Python and recently I had a need to execute a Python script from an RPG program. In addition to executing the script, I also wanted to pass it parameters.

One of the benefits of passing parameters is to give us the ability to soft-code programs or scripts. Soft-coding makes programs more flexible and re-usable, and helps to reduce maintenance.

To illustrate how to do this, I’ve coded a very simple RPG program and an even simpler Python script. I’ll start …
Read more
Guru: IBM i Save File Compression Options

April 1, 2019 Michael Sansoterra

As I finished populating some test tables with a large volume of data on a small and transient IBM i partition in the cloud, I thought life was good. But my countenance fell as I realized the tables plus OS hogged over 70 percent of the disk space. I wondered how to get all the data into a single save file for safe keeping.

The buzzer in my mind was loud and clear: it ain’t gonna work, you don’t have enough room. As I loathed the thought of using multiple save files to save my test data, I remembered that …
Read more
Building Out The .NET Stack Around Mono for IBM i

March 13, 2019 Alex Woodie

The first release of a Mono .NET port to IBM i was issued last year. Since then, the IBM i open source community has been busy building many of the other middleware components that will make it easier for developers to build IBM i applications using Microsoft tooling.

Mono was ported to AIX and IBM i (via the PASE AIX runtime) last year, which gave IBM i and AIX shops the capability to run the open source .NET runtime on Power Systems servers, thus opening the door to allowing Microsoft‘s highly regarded suite of development tools to be …
Read more
Guru: DB2 For i XML Composition And The IFS

June 11, 2018 Michael Sansoterra

Hey, Mike! Regarding Composing An XML Document From Relational Data, Part 1, I have built an XML document using DB2 and i. When I run the query, I get a worthless result set. How do I use the SQL XML functions to get a usable XML file?

This question comes from reader RA, and he doesn’t exaggerate. The result set from his XML-based query looks like this:
```
....+....1....+....2....+....3....+....4....+
************Beginning of data************** 

XMLDATA 
-------- 
#CGULIB#

  1 RECORD(S) SELECTED.

 ************End of Data********************
```
Notice that DB2 for i does nothing to make the XML attractive to human eyes as the entire XML …
Read more

Content archive

Recent Posts

Subscribe

Pages

Search

Guru: Copy From Stream File FMTOPT(*NOCHK)

Guru: Passing Parameters To Python

Guru: IBM i Save File Compression Options

Building Out The .NET Stack Around Mono for IBM i

Guru: DB2 For i XML Composition And The IFS

Content archive

Recent Posts

Subscribe

Pages

Search