APIs by Example: Extract Database Journal Entry Images

Add extracted data to an output file.

Combining good ideas and smart techniques adds a certain dimension to my efforts when I’m searching for topics to cover in APIs by Example. In “Thinking Outside the SQL Box, Part 2” (February 2012), John Vriezen describes a clever way to use SQL to extract file data from journal entry images. Although I read his article, I never got around to putting the technique to use. Then, a while later, iPro Developer reader Arthur Adams presented me with an idea to implement a CL command that can extract and recover database journal entry images and add them to an output file.

So in this article, I’ll provide the Extract Journal Data (EXTJRNDTA) command, as well as a couple of CL commands that help EXTJRNDTA perform a database journal extract. For full instructions on how to create the EXTJRNDTA command and its prerequisite objects, see the “How to Compile” sidebar below.

Download the save file containing the source code.

Read the entire article.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s