Avatar of Lynn Harris
Lynn Harris
Flag for United States of America asked on

AS400 Forms


Help! We currently have a number of forms which have been happily rolling along for years on a very old machine. I have been tasked with identifying them and when they where last used.  I have no clue. These are forms which where developed 20 years ago and have not be modified in at least 10 years.  

Links/info/any is greatly appreciated.

Thank You!
IBM System iDB2

Avatar of undefined
Last Comment
Gary Patterson, CISSP

8/22/2022 - Mon
Kent Olsen

Hi Lynn,

I'm not the AS400 expert around here, so we'll await one of them to pop in.

In the meantime, do you know what tool/package/product was used to create and/or maintain the forms?  There are several of them out there and it could be any of them.

Gary Patterson, CISSP

Lynn, what exactly do you mean by forms?  

Are we talking about AFP overlays?  Those are a type of AS/400 object that gets merged at runtime with variable text generated by a program to allow printing of forms on plan paper without having to handle all the details of drawing lines in your program.  

As Kent mentioned, there are also lots of form creation tools - like TL Ashford Barcode/400, just to pick a common one that has been around a long time that are used to create and produce forms.  There are also plenty of non-IBM AS/400 tools that are often used to download data from the AS/400 (or other systems) and produce complex forms.
Lynn Harris

Hi (and thank you both),

Sorry I should have included that!  These forms are from office vision.  We still have an old machine and only run office vision/email on it. We have got approval to move off it (yes!!!) but I need to identify all forms and am not sure how.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Kent Olsen

Wow.  That is old!  :)

You probably want to investigate the QDLS (Document Library Services File System).  It should contain the creation data and last access date for the forms.
Lynn Harris

No luck with QDLS.

We have a QDOC but it contain all the documents in every document on the system.
Gary Patterson, CISSP

View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Lynn Harris

Excellent.  A place to start.

Thank You!!

Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Kent Olsen

Great job, Gary.

The redbook links that I had to OfficeVision were broken.  :(
Gary Patterson, CISSP

Yeah, not sure why, but the top-level link to that on the Redbooks site has been removed.  I've got a copy of the file I could post, but I searched for the title and found a working link to the PDF.  Whenever something like that happens, I just make a copy of the document, just in case!