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.

Articles by Carsten Flensburg
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.
Let Users Instantly Access SNDSMTPEMM Command Instructions 6
IBM's new Send SMTP Email (SNDSMTPEMM) command, delivered midrelease, lacks a help text panel group that would let users instantly access information about the command and its parameters. To remedy this situation until IBM corrects it with the next IBM i OS release, Carsten Flensburg provides QSMTPUSR, a help text panel group you can install today to let users easily access SNDSMTPEMM command instructions from the command line.
APIs by Example: Watch Definitions and the Start Watch (QSCSWCH) API 
Since release 5.4, we've had the ability to define and start watches on your IBM i. A watch can monitor for specific or generic messages in a job log or all messages of a specific type issued in any job or named jobs on the system. You can also associate watches with traces when issuing the trace commands that specify watches parameters. Here, the watches in scope are the ones initiated using the STRWCH command or the QSCSWCH API. When it comes to system and job monitoring, watches are a powerful tool.
APIs by Example: Physical File Triggers and the QDBRTVFD API 
Though we can use native CL commands and SQL statements to create and manage physical file triggers, we still lack a CL command for listing and working with the triggers defined for a physical file. One easy workaround is to use the Retrieve Database File Description (QDBRTVFD) API and User Interface Manager programming techniques. To find out how you can use QDBRTVFD to access details about the triggers associated with a specified physical file, read on.
Try New Subsystem Entry Commands MVP eBook 

Configuring and maintaining a subsystem description, which includes subsystem entries of many different types, requires quite a bit of effort on the IBM i. While the Work with Subsystem Description (WRKSBSD) command allows you to see all the subsystem entries currently associated with the subsystem, there's no way to directly manipulate these entries using this command.

In this ebook, Carsten Flensburg looks to make your life easier by providing Work with commands that cover all subsystem entry types.

APIs By Example MVP eBook 

APIs by Example's original purpose was to establish a library of API samples for you to use as a starting point for programming tasks involving APIs. Over time, this intention has evolved into putting the APIs in the context of CL commands and utilities to add a practical aspect to the API code samples and utilities. This set of seven APIs by Example articles deals with the many cryptographic APIs involved in the key management part of the challenge of setting up a secure, manageable cryptographic environment.

You will learn about:

3 CL Commands to Manage Digital Certificates 
Ensuring that digital certificates are up-to-date is essential to keeping your enterprise's Internet business transactions running smoothly. Although the IBM i provides no automated notification of certificate expiration, the Retrieve Certificate Information API provides a means for accessing information useful for certificate management. Carsten Flensburg uses the API to simplify the task of managing digital certificates on the IBM i, by creating three useful commands that let you check the expiration status of digital certificates, work with digital certificates, and display certificate information.
MVP Members


• 80+ hours of Videos
• eBooks
• Articles
• Digital Magazine
• Discounts

Join Now!

Already a member

iPro Forums

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

Featured Products

Let your PHP Apps Fly on IBM i: High-performance PHP

Tuesday, July 30th Presented by: Alan Seiden EARLY BIRD DISCOUNT – Enroll by July 12th and SAVE 20% Learn how to ensure excellent performance for your PHP applications that run on IBM i (or that connect to IBM i). This one-day, three-session eLearning event contains techniques not available anywhere else. This event will have you brimming with ideas to make your application fly....More

Let your PHP Apps Fly on IBM i: High-performance PHP & iPro Developer Digital Subscription

Tuesday, July 30th Presented by: Alan Seiden EARLY BIRD DISCOUNT – Enroll by July 12th and SAVE 20% Learn how to ensure excellent performance for your PHP applications that run on IBM i (or that connect to IBM i). This one-day, three-session eLearning event contains techniques not available anywhere else. This event will have you brimming with ideas to make your application fly....More

Let your PHP Apps Fly on IBM i: High-performance PHP - Session 3

In sessions 1 and 2 you learned to leverage IBM i with PHP to produce content quickly, but the journey is only beginning. Your dynamic content must travel to the user's browser or device. Then you must deliver images, JavaScript, and cascading style sheets (CSS). Don't let your application get bogged down there. Learn how to speed delivery of your PHP-generated content, AJAX, JavaScript, CSS, and all the components of a modern web application. You will learn:...More
From the Blogs
May 15, 2013
blog

Integrated Middleware: 25 Years of Building it the Right Way

Integrated Middleware: 25 Years of Building it the Right Way...More
XML Service
May 8, 2013
blog

Getting at Your Data: XML Service

During the process of putting the PHP ecosystem on IBM i, IBM realized that it needed a better option for data access—not just from PHP, but from any language, either on the local systems or on a remote machine. The result is something IBM calls “XML Service.”...More