Hang a Left at Calendarville and Head to the AS/400 Meeting Scheduler

Visual Basic
  • Smaller Small Medium Big Bigger
  • Default Helvetica Segoe Georgia Times

A friend of mine is the chief financial officer for a medical firm. We were chatting one day and out of the blue he said he had a problem: He had 50 employees and not one single standard type of calendaring software. By calendaring, I mean a way to keep track of appointments and meetings. He said that some people were using Lotus Notes, some Microsoft Outlook, and others resorted to chicken scratch on a pad of paper, but not everyone was using the same software for their calendaring needs. He said it made things difficult to figure out who was in what meetings and when. He also said that his budget dollars were all used up so he couldn’t purchase more software. My response was “don’t you have an AS/400?” He looked at me puzzled. “But,” he responded, “I want an application that runs on my PC, not a native green-screen application. It has a better feel to it.” I told him to give me a few weeks to throw something together for him. This is how the AS/400 Meeting Scheduler came to be.

After a few weeks, I threw together the program shown in Figure 1. The program addressed his scheduling needs and didn’t cost him anything other than some time to sit down and learn new software. The AS/400 Meeting Scheduler’s main interface is written in Microsoft’s Visual Basic (VB) for that robust GUI. The main control in the VB program is Microsoft’s ActiveX Data Object (ADO). The back-end database resides on the AS/400. Client Access/400’s OLE DB driver was used as the pipeline to the data on the AS/400. Throw in some embedded SQL, stored procedures, and RPG programs on the AS/400, and you are good to go. No, it doesn’t have all of the bells and whistles of Microsoft Outlook or Lotus Notes, but I’m not Bill Gates either.

Calendarville Information Center

OK. Let’s see what this baby is made up of. There are three distinct areas to the AS/400 Meeting Scheduler that I want to review. (I’ll jump into further detail later.) The areas are as follows:

• Administrative menu—This allows the designated AS/400 Meeting Scheduler Administrator to add, delete, update logon IDs, and control all meetings scheduled on the AS/400. Please note that a logon ID in the AS/400 Meeting Scheduler Profile is not the same as a user profile on the AS/400.

• Schedule a meeting—This allows you to schedule a meeting. It checks for conflicts and allows you to enter meeting information.

• View meeting schedule—You can view today’s meetings or another date in the future. This shows you all of your meetings for the selected date, meeting location, meeting agenda, and all attendees for the meeting.

Before creating your first meeting, you need to make sure that everything is installed correctly on both the PC and AS/400. This program assumes a few things:

• You are running a PC in a Windows 95, 98, or NT environment.

• You are using AS/400 Client Access Express for Windows or a previous version of CA/400 that supports the OLE DB driver. CWBZZODB.DLL is the .DLL that contains the code for the driver and is available with CA/400 V3R1M3. This DLL should automatically be loaded onto your machine when Client Access is installed.

• You have the Microsoft Data Access Components (MDAC) installed. This is free and can be found at download.htm. Be warned that, while the initial download of the MDAC software development kit (SDK) is fast, the actual installation on your PC of the MDAC SDK comes from Microsoft’s Web site and over a dial-up connection. This installation can be a very long-running process.

To get the AS/400 objects and the PC setup program, go to to download the objects related to this article. The readme.txt explains how to install the objects on the AS/400 and the PC.

The first time you run the scheduler, you must do a few things. An input box will appear and ask you to enter the AS/400 system name. Enter the name of the AS/400 that the Scheduler Objects reside on. Next, the input box will ask you the library where the installed programs reside. The library name entered must be the name of the library the objects for this utility were restored into on the AS/400. It is very important that the objects for the AS/400 are restored to a library that is part of the AS/400 user profile, QUSER, library list. It is important so that the QUSER profile behind the scenes can locate the AS/400 objects necessary on the AS/400 end. If all has been entered correctly, you will be asked to log on. Figure 2 shows what the logon screen looks like.

The first time you log onto the scheduler, there is only one valid logon ID and password. The logon ID needs to be MC400. Also, enter MC400 for the password. Press the Sign In to Scheduler button to try to log onto the program. Because this logon ID has administrator rights, you are brought into the Administration Menu. If you have signed on correctly and checked the box titled Save Log on Attributes for Meeting Scheduler, the logon ID, password, system name, and library name are all saved to your PC’s registry. This will bypass typing in each of these parameters each time you log on.

Administration Menu Boulevard

The Administration Menu will only be shown if the logon ID that has logged into scheduler has administrative rights. First, check out the Modify Attributes drop-down box. Select Add/Update/Delete Log In Profile. Figure 3 is what you should see on your screen.

Look under the heading All AS/400 Meeting Scheduler Users. This is where you add all of your scheduler IDs. The only logon ID currently out there should be MC400.

Now you can add a few new identifiers: In the login ID field, type in a Scheduler ID name. The scheduler name cannot be longer than 10 characters and is automatically converted to uppercase. This name will be used to log into the scheduler. Enter the logon person’s first name in the First Name field provided and the last name in the Last Name field. Next, enter the a password. This password will be what the person uses to log on to the AS/400. This, too, can only be up to 10 characters long and isn’t visible when entering in the password field. Check the Administrative Rights? box if you wish this person to be an administrator when he or she logs on the system. Click on the Add Record in Database button. Notice that the new ID was added to the right in the users list.

Notice that in the users list box there are horizontal and vertical scroll bars. The horizontal scroll bar hides the passwords for each person. Scrolling over will reveal the passwords. Scrolling down will show more people enrolled in the Scheduler. All of the entries are in alphabetical order. Click on an entry and it automatically fills in the login ID, first name, last name, password, and administrative right fields. You can change any fields other than the login ID field, and click Update Record in Database to make an update. Clicking the Delete Record in Database button will delete the current record selected. The Clear button clears all of the fields so you can start entering data again.

Notice the colors in the users list box. All of the entries in red indicate that these people have administrative rights. Remember that administrative rights give you access to the Administration Menu tab. All other users will show up in blue. Maintaining users is critical to the success of this program. All of the users that are in your database will show up as valid people who can be selected for meetings. Notice that all changes that you make will show up under the Administrative History list box. You may want to remove the MC400 logon ID and add or change a different ID to be the new administrator. Right-click in the Administrative History area to delete the entries in history. Go back up to Modify Attributes and select Delete Meetings. The meeting administration is now on your screen.

The first time in this screen you’ll see all of the meetings in your scheduler under the heading All Meetings in Scheduler. If you click on a specific meeting, the attendees for that meeting are shown in the Attendees list. Click on the drop-down box for Select Login ID. This will contain all of the IDs that are currently set up in the scheduler. By clicking on a profile, you’ll be shown all of the meetings that this person is scheduled in.

Select a meeting by clicking on it. Right-click on it and a message box will appear allowing you to delete the entry. Press the Yes button for the deletion to occur. Pressing the Clean Up Meetings will delete all meetings in the scheduler that are older than the current date. It is recommended that you do this from time to time. All deletions are recorded in the Administration History list. Go back and enter some valid profiles in your workplace and create a meeting by clicking on the Schedule a Meeting tab.

Schedule a Meeting Street

This screen looks pretty boring. The screen was designed to have the user follow a specific order when entering meeting information. Follow these steps to add a meeting:

1. Fill in a meeting location—The default here is your signature and it is in your in your office. This can be modified.

2. Fill in a meeting title—What could your meeting be called?

3. Enter data for an agenda—Why was the meeting called? What will be discussed in the meeting? Remember, when you enter an agenda, everyone that is scheduled will be able to see what you’ve entered, so be descriptive.

4. Select meeting participants—Choose from the list of possible people on the lower left side of the screen. Double-click on a name to move it into an attendee of the meeting. Select

all of the people you wish to add for your meeting. To remove a person that you’ve selected, click on his name, and it will return back to the original list.

5. Select the date—Choose the date you wish to have the meeting. You cannot select a date that has previously expired.

6. Select the start time—Enter a time from the drop-down box. The meeting can be as early as 7:00 a.m.

7. Select the end time—Based on the start time, entries are automatically provided for you.

Once the end time has been selected, you will either get a confirmation to add a meeting or a conflict message box. The screen will look like Figure 4. A conflict means that one or more of the people that you’ve selected to attend the meeting has already been scheduled during that time frame. The conflict message box looks like Figure 5. The confirmation box, if you decide to add the meeting, will enter all of the data to the scheduler. It is now available for everyone to view. That’s all there is to it. Now view your meetings.

View Meeting Schedule Plaza

This is the easiest part of the entire program. When you first log onto the scheduler, if you do not have administrative rights, you will see Figure 1. The default date is the current date. You will see what meetings you have scheduled for that day. A list on the left-hand side shows what meetings you have scheduled, the start time and end time for the meeting, and the title of the meeting. Click on a specific meeting and the meeting information will appear under Meeting Agenda on the right side. Click on any other date to view what has been scheduled for you as well. If you are an attendee of the meeting, you have been given rights to delete the meeting too. Right-click on a meeting to delete it. This will remove the meeting details and attendee list from the scheduler. It’s that simple.

Final Directions

Hopefully, more people will find some use for the AS/400 Meeting Scheduler in the workplace. This is just a small example of how powerful the AS/400 can be in client/server applications. I remember programming with the Client Access API and having to be a rocket scientist to do it. Client Access came out with its own OLE DB provider, and it made applications very easy to code. This entire application uses regular calls to stored procedures and RPG programs. I chose to use stored procedures and RPG programs because, in the future, someone could also get at this data from a Web browser as well as your everyday native green-screen programs without reinventing the wheel. Thank you for visiting Calendarville. Come back again soon.


• SQL/400 by Example. James Coolbaugh. Loveland, Colorado: 29th Street Press, 1999

Hang_a_Left_at_Calendarville_and_Head_to_the...05-00.png 397x338

Figure 1: The AS/400 Meeting Scheduler on the View Meeting Scheduler tab shows you detailed information about a day’s meeting.

Figure 2: The logon screen for the AS/400 Meeting Scheduler allows only authorized users access.

Hang_a_Left_at_Calendarville_and_Head_to_the...05-01.png 395x336

Hang_a_Left_at_Calendarville_and_Head_to_the...06-00.png 395x336

Figure 3: This shows the Administration Menu on with the login administration screen shown.

Figure 4: The Schedule a Meeting screen allows you to simply coordinate a meeting.

Hang_a_Left_at_Calendarville_and_Head_to_the...06-01.png 406x331

Hang_a_Left_at_Calendarville_and_Head_to_the...07-00.png 406x154

Figure 5: Conflicts have been found for this scheduled meeting.



Support MC Press Online





  • White Paper: Node.js for Enterprise IBM i Modernization

    SB Profound WP 5539

    If your business is thinking about modernizing your legacy IBM i (also known as AS/400 or iSeries) applications, you will want to read this white paper first!

    Download this paper and learn how Node.js can ensure that you:
    - Modernize on-time and budget - no more lengthy, costly, disruptive app rewrites!
    - Retain your IBM i systems of record
    - Find and hire new development talent
    - Integrate new Node.js applications with your existing RPG, Java, .Net, and PHP apps
    - Extend your IBM i capabilties to include Watson API, Cloud, and Internet of Things

    Read Node.js for Enterprise IBM i Modernization Now!


  • Profound Logic Solution Guide

    SB Profound WP 5539More than ever, there is a demand for IT to deliver innovation.
    Your IBM i has been an essential part of your business operations for years. However, your organization may struggle to maintain the current system and implement new projects.
    The thousands of customers we've worked with and surveyed state that expectations regarding the digital footprint and vision of the companyare not aligned with the current IT environment.

    Get your copy of this important guide today!


  • 2022 IBM i Marketplace Survey Results

    Fortra2022 marks the eighth edition of the IBM i Marketplace Survey Results. Each year, Fortra captures data on how businesses use the IBM i platform and the IT and cybersecurity initiatives it supports.

    Over the years, this survey has become a true industry benchmark, revealing to readers the trends that are shaping and driving the market and providing insight into what the future may bring for this technology.

  • Brunswick bowls a perfect 300 with LANSA!

    FortraBrunswick is the leader in bowling products, services, and industry expertise for the development and renovation of new and existing bowling centers and mixed-use recreation facilities across the entertainment industry. However, the lifeblood of Brunswick’s capital equipment business was running on a 15-year-old software application written in Visual Basic 6 (VB6) with a SQL Server back-end. The application was at the end of its life and needed to be replaced.
    With the help of Visual LANSA, they found an easy-to-use, long-term platform that enabled their team to collaborate, innovate, and integrate with existing systems and databases within a single platform.
    Read the case study to learn how they achieved success and increased the speed of development by 30% with Visual LANSA.


  • Progressive Web Apps: Create a Universal Experience Across All Devices

    LANSAProgressive Web Apps allow you to reach anyone, anywhere, and on any device with a single unified codebase. This means that your applications—regardless of browser, device, or platform—instantly become more reliable and consistent. They are the present and future of application development, and more and more businesses are catching on.
    Download this whitepaper and learn:

    • How PWAs support fast application development and streamline DevOps
    • How to give your business a competitive edge using PWAs
    • What makes progressive web apps so versatile, both online and offline



  • The Power of Coding in a Low-Code Solution

    LANSAWhen it comes to creating your business applications, there are hundreds of coding platforms and programming languages to choose from. These options range from very complex traditional programming languages to Low-Code platforms where sometimes no traditional coding experience is needed.
    Download our whitepaper, The Power of Writing Code in a Low-Code Solution, and:

    • Discover the benefits of Low-code's quick application creation
    • Understand the differences in model-based and language-based Low-Code platforms
    • Explore the strengths of LANSA's Low-Code Solution to Low-Code’s biggest drawbacks



  • Why Migrate When You Can Modernize?

    LANSABusiness users want new applications now. Market and regulatory pressures require faster application updates and delivery into production. Your IBM i developers may be approaching retirement, and you see no sure way to fill their positions with experienced developers. In addition, you may be caught between maintaining your existing applications and the uncertainty of moving to something new.
    In this white paper, you’ll learn how to think of these issues as opportunities rather than problems. We’ll explore motivations to migrate or modernize, their risks and considerations you should be aware of before embarking on a (migration or modernization) project.
    Lastly, we’ll discuss how modernizing IBM i applications with optimized business workflows, integration with other technologies and new mobile and web user interfaces will enable IT – and the business – to experience time-added value and much more.


  • UPDATED: Developer Kit: Making a Business Case for Modernization and Beyond

    Profound Logic Software, Inc.Having trouble getting management approval for modernization projects? The problem may be you're not speaking enough "business" to them.

    This Developer Kit provides you study-backed data and a ready-to-use business case template to help get your very next development project approved!

  • What to Do When Your AS/400 Talent Retires

    FortraIT managers hoping to find new IBM i talent are discovering that the pool of experienced RPG programmers and operators or administrators is small.

    This guide offers strategies and software suggestions to help you plan IT staffing and resources and smooth the transition after your AS/400 talent retires. Read on to learn:

    • Why IBM i skills depletion is a top concern
    • How leading organizations are coping
    • Where automation will make the biggest impact


  • Node.js on IBM i Webinar Series Pt. 2: Setting Up Your Development Tools

    Profound Logic Software, Inc.Have you been wondering about Node.js? Our free Node.js Webinar Series takes you from total beginner to creating a fully-functional IBM i Node.js business application. In Part 2, Brian May teaches you the different tooling options available for writing code, debugging, and using Git for version control. Attend this webinar to learn:

    • Different tools to develop Node.js applications on IBM i
    • Debugging Node.js
    • The basics of Git and tools to help those new to it
    • Using as a pre-built development environment



  • Expert Tips for IBM i Security: Beyond the Basics

    SB PowerTech WC GenericIn this session, IBM i security expert Robin Tatam provides a quick recap of IBM i security basics and guides you through some advanced cybersecurity techniques that can help you take data protection to the next level. Robin will cover:

    • Reducing the risk posed by special authorities
    • Establishing object-level security
    • Overseeing user actions and data access

    Don't miss this chance to take your knowledge of IBM i security beyond the basics.



  • 5 IBM i Security Quick Wins

    SB PowerTech WC GenericIn today’s threat landscape, upper management is laser-focused on cybersecurity. You need to make progress in securing your systems—and make it fast.
    There’s no shortage of actions you could take, but what tactics will actually deliver the results you need? And how can you find a security strategy that fits your budget and time constraints?
    Join top IBM i security expert Robin Tatam as he outlines the five fastest and most impactful changes you can make to strengthen IBM i security this year.
    Your system didn’t become unsecure overnight and you won’t be able to turn it around overnight either. But quick wins are possible with IBM i security, and Robin Tatam will show you how to achieve them.

  • Security Bulletin: Malware Infection Discovered on IBM i Server!

    SB PowerTech WC GenericMalicious programs can bring entire businesses to their knees—and IBM i shops are not immune. It’s critical to grasp the true impact malware can have on IBM i and the network that connects to it. Attend this webinar to gain a thorough understanding of the relationships between:

    • Viruses, native objects, and the integrated file system (IFS)
    • Power Systems and Windows-based viruses and malware
    • PC-based anti-virus scanning versus native IBM i scanning

    There are a number of ways you can minimize your exposure to viruses. IBM i security expert Sandi Moore explains the facts, including how to ensure you're fully protected and compliant with regulations such as PCI.



  • Encryption on IBM i Simplified

    SB PowerTech WC GenericDB2 Field Procedures (FieldProcs) were introduced in IBM i 7.1 and have greatly simplified encryption, often without requiring any application changes. Now you can quickly encrypt sensitive data on the IBM i including PII, PCI, PHI data in your physical files and tables.
    Watch this webinar to learn how you can quickly implement encryption on the IBM i. During the webinar, security expert Robin Tatam will show you how to:

    • Use Field Procedures to automate encryption and decryption
    • Restrict and mask field level access by user or group
    • Meet compliance requirements with effective key management and audit trails


  • Lessons Learned from IBM i Cyber Attacks

    SB PowerTech WC GenericDespite the many options IBM has provided to protect your systems and data, many organizations still struggle to apply appropriate security controls.
    In this webinar, you'll get insight into how the criminals accessed these systems, the fallout from these attacks, and how the incidents could have been avoided by following security best practices.

    • Learn which security gaps cyber criminals love most
    • Find out how other IBM i organizations have fallen victim
    • Get the details on policies and processes you can implement to protect your organization, even when staff works from home

    You will learn the steps you can take to avoid the mistakes made in these examples, as well as other inadequate and misconfigured settings that put businesses at risk.



  • The Power of Coding in a Low-Code Solution

    SB PowerTech WC GenericWhen it comes to creating your business applications, there are hundreds of coding platforms and programming languages to choose from. These options range from very complex traditional programming languages to Low-Code platforms where sometimes no traditional coding experience is needed.
    Download our whitepaper, The Power of Writing Code in a Low-Code Solution, and:

    • Discover the benefits of Low-code's quick application creation
    • Understand the differences in model-based and language-based Low-Code platforms
    • Explore the strengths of LANSA's Low-Code Solution to Low-Code’s biggest drawbacks



  • Node Webinar Series Pt. 1: The World of Node.js on IBM i

    SB Profound WC GenericHave you been wondering about Node.js? Our free Node.js Webinar Series takes you from total beginner to creating a fully-functional IBM i Node.js business application.
    Part 1 will teach you what Node.js is, why it's a great option for IBM i shops, and how to take advantage of the ecosystem surrounding Node.
    In addition to background information, our Director of Product Development Scott Klement will demonstrate applications that take advantage of the Node Package Manager (npm).
    Watch Now.

  • The Biggest Mistakes in IBM i Security

    SB Profound WC Generic The Biggest Mistakes in IBM i Security
    Here’s the harsh reality: cybersecurity pros have to get their jobs right every single day, while an attacker only has to succeed once to do incredible damage.
    Whether that’s thousands of exposed records, millions of dollars in fines and legal fees, or diminished share value, it’s easy to judge organizations that fall victim. IBM i enjoys an enviable reputation for security, but no system is impervious to mistakes.
    Join this webinar to learn about the biggest errors made when securing a Power Systems server.
    This knowledge is critical for ensuring integrity of your application data and preventing you from becoming the next Equifax. It’s also essential for complying with all formal regulations, including SOX, PCI, GDPR, and HIPAA
    Watch Now.

  • Comply in 5! Well, actually UNDER 5 minutes!!

    SB CYBRA PPL 5382

    TRY the one package that solves all your document design and printing challenges on all your platforms.

    Produce bar code labels, electronic forms, ad hoc reports, and RFID tags – without programming! MarkMagic is the only document design and print solution that combines report writing, WYSIWYG label and forms design, and conditional printing in one integrated product.

    Request your trial now!

  • Backup and Recovery on IBM i: Your Strategy for the Unexpected

    FortraRobot automates the routine tasks of iSeries backup and recovery, saving you time and money and making the process safer and more reliable. Automate your backups with the Robot Backup and Recovery Solution. Key features include:
    - Simplified backup procedures
    - Easy data encryption
    - Save media management
    - Guided restoration
    - Seamless product integration
    Make sure your data survives when catastrophe hits. Try the Robot Backup and Recovery Solution FREE for 30 days.

  • Manage IBM i Messages by Exception with Robot

    SB HelpSystems SC 5413Managing messages on your IBM i can be more than a full-time job if you have to do it manually. How can you be sure you won’t miss important system events?
    Automate your message center with the Robot Message Management Solution. Key features include:
    - Automated message management
    - Tailored notifications and automatic escalation
    - System-wide control of your IBM i partitions
    - Two-way system notifications from your mobile device
    - Seamless product integration
    Try the Robot Message Management Solution FREE for 30 days.

  • Easiest Way to Save Money? Stop Printing IBM i Reports

    FortraRobot automates report bursting, distribution, bundling, and archiving, and offers secure, selective online report viewing.
    Manage your reports with the Robot Report Management Solution. Key features include:

    - Automated report distribution
    - View online without delay
    - Browser interface to make notes
    - Custom retention capabilities
    - Seamless product integration
    Rerun another report? Never again. Try the Robot Report Management Solution FREE for 30 days.

  • Hassle-Free IBM i Operations around the Clock

    SB HelpSystems SC 5413For over 30 years, Robot has been a leader in systems management for IBM i.
    Manage your job schedule with the Robot Job Scheduling Solution. Key features include:
    - Automated batch, interactive, and cross-platform scheduling
    - Event-driven dependency processing
    - Centralized monitoring and reporting
    - Audit log and ready-to-use reports
    - Seamless product integration
    Scale your software, not your staff. Try the Robot Job Scheduling Solution FREE for 30 days.