• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Closing Files in ILE Service Programs

    May 5, 2004 Hey, Ted

    We’re moving all our new development to RPG IV and ILE, and as part of this process we are looking at putting our commonly used processes into service programs. Many of these functions require access to database files. For example, one function would retrieve the price of an item according to the area in which it is being sold, the date for which the price is applicable, and whether any discounts have been set up. This is quite a complicated procedure, and we want a simple function we can call that will prevent us having to code it separately each time.

    We have put this calculation into a subprocedure, which uses the passed parameters to retrieve the correct information, using three files. This subprocedure then has been put into a service program, and so far, so good–the price is returned to the program. The problem becomes apparent when the calling program ends– the three files used within the service program are still open. I assume the files are open because there is no program cycle processing that will ever close them. Short of manually opening and closing these files (which I guess would be very inefficient), I can’t see any way around this problem. Am I missing something obvious?

    –Simon

    The files will remain open until the activation group in which they are open is destroyed. If you assign the service program and the calling programs to the proper activation groups, you won’t have to explicitly close the files.

    When you create the service program, specify ACTGRP(*CALLER) to make the service program run in the caller’s activation group. This is the default setting for service programs.

    Here is the key: make sure that calling programs do not run in the default activation group. The usual way to achieve this objective is by creating them to run in either a *NEW or named activation group. It’s okay to create calling programs with ACTGRP(*CALLER) if they will always run under programs that run in *NEW or named activation groups. The problem with running your service program in the default activation group is that the only way to destroy the default activation group, and thereby to close your files, is by ending the job.

    There are two ways to destroy an activation group: one is to end the job that contains the activation group, and the other is to use the Reclaim Activation Group (RCLACTGRP) command.

    For more information about activation groups, see “What You Should Know About Activation Groups” and “ILE Strategies.”

    –Ted

    Share this:

    • Share on Reddit (Opens in new window) Reddit
    • Share on Facebook (Opens in new window) Facebook
    • Share on LinkedIn (Opens in new window) LinkedIn
    • Share on X (Opens in new window) X
    • Email a link to a friend (Opens in new window) Email

    Tags:

    Sponsored by
    WorksRight Software

    Do you need area code information?
    Do you need ZIP Code information?
    Do you need ZIP+4 information?
    Do you need city name information?
    Do you need county information?
    Do you need a nearest dealer locator system?

    We can HELP! We have affordable AS/400 software and data to do all of the above. Whether you need a simple city name retrieval system or a sophisticated CASS postal coding system, we have it for you!

    The ZIP/CITY system is based on 5-digit ZIP Codes. You can retrieve city names, state names, county names, area codes, time zones, latitude, longitude, and more just by knowing the ZIP Code. We supply information on all the latest area code changes. A nearest dealer locator function is also included. ZIP/CITY includes software, data, monthly updates, and unlimited support. The cost is $495 per year.

    PER/ZIP4 is a sophisticated CASS certified postal coding system for assigning ZIP Codes, ZIP+4, carrier route, and delivery point codes. PER/ZIP4 also provides county names and FIPS codes. PER/ZIP4 can be used interactively, in batch, and with callable programs. PER/ZIP4 includes software, data, monthly updates, and unlimited support. The cost is $3,900 for the first year, and $1,950 for renewal.

    Just call us and we’ll arrange for 30 days FREE use of either ZIP/CITY or PER/ZIP4.

    WorksRight Software, Inc.
    Phone: 601-856-8337
    Fax: 601-856-9432
    Email: software@worksright.com
    Website: www.worksright.com

    Share this:

    • Share on Reddit (Opens in new window) Reddit
    • Share on Facebook (Opens in new window) Facebook
    • Share on LinkedIn (Opens in new window) LinkedIn
    • Share on X (Opens in new window) X
    • Email a link to a friend (Opens in new window) Email

    Proper CL Error-Handling Admin Alert: Hitting the Limits of the QNTC File System

    Leave a ReplyCancel reply

Volume 4, Number 15 -- May 5, 2004
THIS ISSUE
SPONSORED BY:

T.L. Ashford
Guild Companies
GST
WorksRight Sofware
Damon Technologies

Table of Contents

  • Using RPG As Your ASP Language, Part 2
  • Proper CL Error-Handling
  • Closing Files in ILE Service Programs
  • Admin Alert: Hitting the Limits of the QNTC File System
  • OS/400 Alert: Fix Central Is Now Firewall-Enabled

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • IBM i Delivers New Development Tooling With 2026 Fall Tech Refreshes
  • Big Blue Says AI Is Not Behind The Big Uptick In IBM i Security Alerts
  • Guru: Web Service With Pagination
  • The GenAI Revolution And Product Shortages Send IT Budgets Skyward
  • IBM i PTF Guide, Volume 28, Number 40
  • IBM i PTF Guide, Volume 28, Number 41
  • Bob Code Assistant Gets Better Understanding Of IBM i Applications
  • IBM i In The Cloud And The Case For Reversing Replication
  • Guru: From Hiking Boots To Long-Term Memory
  • Inside IBM’s New PowerHA Cloud Offering, Full System Manager

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2025 IT Jungle