Connect With Us

Carsten Flensburg


Carsten Flensburg is an iPro Developer senior technical editor and has been an IBM i programmer since 1992. His focus areas are modular system design, API programming, system integration, and communication. Carsten works as an IBM i application development manager for a European vacation rental company called Novasol, which is a part of the U.S.-based Wyndham Worldwide Corporation.

Working with Database Files--the API Way!
APIs by Example: Working with Database Files--the API Way! 
A Swiss Army knife provides a variety of useful tools in one place. Carsten Flensburg presents a similar toolset that helps database programmers get the job done efficiently: the Work with Database Files command.
APIs by Example: Working with Printers
APIs by Example: Working with Printers -- All Printers, Please! 
The WRKPRT command lets you manage local, LAN, and remote output queue writers, all in one. Carsten Flensburg explains.
Work Management APIs: Keeping an Eye on Job Activity
Work Management APIs: Keeping an Eye on Job Activity 
With this updated collection of past work management CL commands, you can easily monitor, manage, and interact with your subsystems, job queues, and related jobs. Carsten Flensburg explains how.
Work Management APIs: Putting the Pieces Together
Work Management APIs: Putting the Pieces Together 
Carsten Flensburg demonstrates a programming technique that supports more commands in a User Interface Manager list panel than the panel’s list options space permits. He also shows you how to identify and handle jobs in a message wait state via the Work Management API support.
Extract Database Journal Entry Images
APIs by Example: Extract Database Journal Entry Images  4
With the Extract Journal Data (EXTJRNDTA) command, you can extract and recover database journal entry images and add them to an output file.
Exit Points, APIs, and Environment Variables
APIs by Example: Exit Points, APIs, and Environment Variables 
With the help of exit points, exit point programs, and environment variables, you can control the replies returned in inquiry messages. Carsten Flensburg shows you how to use inquiry handling and reply handling exit points to manage message replies in an interactive job.
Where Is That Module Bound?
APIs By Example: Where Is That Module Bound? 
To help you resolve cross-references in an ILE development environment, the Work with Module References (WRKMODREF) command is a handy tool to add to your toolbox. Carsten Flensburg demonstrates how you can put this command to work in your shop.
APIs by Example: Keeping Track of Your Exports 
Do you often find yourself needing a routine but can't remember which service program it resides in? Or maybe you're writing a new procedure and want to verify whether a procedure of the same name already exists. Carsten Flensburg offers his Work with Program Export (WRKPGMEXP) command, which lets you list all modules and service programs that export a specific procedure or data item.
Job Accounting and the Retrieve Journal Entries API 
An IBM i running a full production workload can produce a heap of information, but gleaning valuable knowledge from that mound of data might require the programming skills of an API programmer. To that end, Carsten Flensburg shows how to use the QjoRetrieveJournalEntries API and ANZJOBACG command to immediately extract and select job resource information from the QACGJRN system accounting journal.
How to Display the Screen of Another Interactive Job 
If you've ever had a requirement to run a program to perform a process in another job, or make the 5250 data stream communicate directly to a display device without the intervention of a display file or panel group, this article is for you. Carsten Flensburg shows how to satisfy both requirements by using the APIs and commands discussed here.
Working with Job IFS Object Locks 
To find the IFS object that a specific job is locking or accessing, consider using the Retrieve Referenced Objects (QP0LRRO) API. With this API, and the WRKJOBIFSL and WRKIFSLCK commands, you'll be well equipped to investigate and handle IFS object locks.
Working with IFS Object Locks 
To quickly find IFS object lock information, use this shortcut to take advantage of the Retrieve Object References (QP0LROR) API to implement the Work with IFS Object Lock (WRKIFSLCK) CL command.
Analyze Object Authorities Using Security APIs 
Do you sometimes wonder why a particular user can delete a certain object, or why a user can't access an object that everybody else can? If you do, the Retrieve User Authority to Object (QSYRUSRA) API is designed to help answer these types of questions. In addition to retrieving a user profile’s authority to a specific object, QSYRUSRA also returns information about the source of this authority.
Let Users Instantly Access RUNSQL Command Instructions 
IBM's new Run SQL (RUNSQL) command, delivered midrelease, lacks a help text panel group that would let users instantly access information about the command and its parameters. To fix this situation until IBM corrects it with the next IBM i OS release, Carsten Flensburg provides a help text panel group you can install today to let users easily access RUNSQL command instructions from the command line.
Run Your Watch Definitions and Create a Watch Event Exit Program 
Using the Start Watch Definition (STRWCHDFN) command presented here, you can activate a previously created watch definition. As a bonus, Carsten also provides examples of how to write and take advantage of watch event exit programs.
iPro Forums

Get answers to questions, share tips, and engage with the iPro Community in our Forums.

From the Blogs
Application Modernization Redbook Unleashed
Mar 27, 2014

Application Modernization Redbook Unleashed  

The Application Modernization Redbook draft version has been released! Tim Rowe has the details....More
Free-Form RPG Transformation, Part 2
Mar 19, 2014

Free-Form RPG Transformation, Part 2  

Tim Rowe continues his series on ISV tools for free-form RPG with a look at Linoma Software's free-format transformation tool, RPG Toolbox....More

Sponsored Introduction Continue on to (or wait seconds) ×