04
Mon, Nov
5 New Articles

Technology Focus: IBM i File and Program Editors Offer a "Power" Punch for Knocking Out App Projects

Development Tools
Typography
  • Smaller Small Medium Big Bigger
  • Default Helvetica Segoe Georgia Times

Whether you're just tinkering with source code or doing global updates on databases, tools for composing and correcting source code and databases are more than just handy.

 

Last month, we covered the list of interactive development environments (IDEs) for IBM Power Systems (IBM i) that can help you build Web applications in "More Tools for Putting Apps on the Web." That article was a follow-up to "Facing the Strain: Web-Enablement Tools for System i," which covered tools that can help you modify existing apps to be Web-friendly.

 

Falling in between those two categories of application-development aids are editors for manipulating databases and the source code of application programs. Obviously, database file and program editors aren't exclusive to building Web apps, but they can be useful timesavers in building and maintaining the application software that underpins any enterprise's finances, and as such are worthy of a review.

The Hard Right

Source-code file editors have been around the longest, having descended from binary and hex-code editors that programmers originally used to alter machine code. As higher-level languages came into vogue for business applications, editors for directly altering source code became a critical tool for building new apps. Although the industry has moved on to IDEs and more automated forms of building code for apps, the file editor remains a useful tool on the programmer's workbench.

 

Generally speaking, you can be sure that all file editors provide certain basic functions. These include providing designers with the ability to create, edit, and print source members as well as to copy records from another source member or spooled file. They also offer a variety of commands for controlling function-key operations and code displays, checking syntax, and inserting breakpoints for code-debugging operations. What distinguishes file editors from their competitors is the number and depth of additional bells and whistles, which in turn affect how well they can be adapted to each programmer's individual coding style.

The Left Hook

Database editors are nearly as important as file editors for IBM i shops because the strengths of the platform make it particularly good with database-intensive apps, and many enterprises play to that strength. This symbiotic relationship can make file and database editors the big punches for programmers looking to knock out application problems, particularly in situations where more advanced programming tools are unaffordable due to the size of the business.

 

Features common to all database editors are the ability to add, change, delete, and display records in any file; global search-and-replace or deletion tools for individual records; security features that restrict access and change authority to designated users; and the ability to generate audit logs and reports of all change activity.

 

If you're in the market for a file or database editor, the product names, descriptions, and links to vendor Web sites below will help you focus your initial research. The brief descriptions provided here highlight some of the features each product offers that go beyond standard features expected in any file or database editor. However, the summaries here don't cover all features each product provides. You should consult the links for each product and contact the associated vendors for a more complete picture of what each product has to offer. 

 

You should also be aware that the articles on Web app building tools referenced above contain links to IDE products that, in nearly every case, incorporate source-code and database editors as part of their standard features. The products listed below are standalone editors that are available at lower prices because they don’t include the other features that are part of IDE solutions. They also generally offer more editing features than editors included within IDEs.

 

And as always when looking for products or services, be sure to check the MC Press Online Buyer's Guide.

Source-File Editors for IBM i

Application Development ToolSet for AS/400 Source Entry Utility (SEU)

IBM Corporation

SEU is the granddaddy of all System i source-code file editors, providing developers with a variety of commands to find and change character strings, set up user-defined line commands, hide selected code lines, tailor editing sessions, and create custom prompts.

 

EngInSite PHP Editor

LuckaSoft

PHP Editor is an IDE and code editor for Zend Corporation's PHP language. The product lets designers create, edit, debug, and run programs written in PHP4 and PHP5. Features include auto-completion for common lines of code, a hint system that knows 3,076 major PHP functions, the ability to set breakpoints in scripts while running the main form of an application, HTTP server environment emulation within the editor, and user-defined color schemes for code displays. The editor also supports use of Unicode, UTF-8, and CVS code in programs.

 

Mozilla Skywriter

Mozilla Labs

If you're brave enough to try a more experimental, cloud-based editor, there's Mozilla Skywriter, formerly codenamed Bespin. It's an all-platform browser-based source-code editor still in beta, for which Mozilla is currently looking for more testers. Skywriter Embedded lets developers use it on their own Web sites, and Skywriter Bookmarklet enables programming on any Web site. Because programming in the cloud is likely to be a significant method of the future, here's your chance to get in on the ground floor of some cutting-edge editing technology.

 

RPG-Alive

Profound Logic Software

The RPG-Alive product family consists of two solutions for editing and analyzing code on System i. RPG-Alive for SEU augments IBM's SEU to add graphical features within Client Access or a 5250 emulation environment, such as automatic highlighting for conditions and loops, and graphic illustration of RPG III/IV syntax. RPG-Alive GUI is an RPG code editor for PCs that helps developers generate ILE RPG and CL programs that run on System i machines. Both products outline RPG code as it's built; automatically connect CL DO/ENDDO statements; highlight comments; and auto-complete names of keywords, built-in functions, and previously defined custom subroutines and subprocedures.

Database Editors for IBM i

DataLens for DB2/400

Information Consultants

DataLens is a realtime database editor that gives users the ability to determine relationships between database files and fields, dynamically create new access paths to selected data, parse and edit records without fields, set up rules for record selection, and execute specific or global operations against database records.

 

Database Utility (DBU)

ProData Computer Services

DBU is a versatile database editor that operates interactively or in batch, offers a choice of GUI or 5250 interface modes, provides a wizard-based access and security setup, lets users export SQL data definitions to support migration of DDS-based files to SQL tables, and enables complex searches using SQL. DBU supports multiple national languages, DDM, ECS, and display of database triggers on physical files.

 

File Edit Utility (FEU)

Applied Logic Corporation

FEU is a database editor and data-manipulation tool. It lets users execute inquiries and global file updates, delete records, restore deleted records, convert and export spooled files to a variety of formats (e.g., HTML, PDF, XML), create and save custom database views, and work with record lengths up to 32K.

 

File-Flash Plus

Business Computer Design International (BCD)

File-Flash Plus lets end users view, edit, query, and print DB2 database files without requiring an RPG program. It also lets users export data to Microsoft Excel spreadsheets, make field changes in databases, change data on the fly, customize and save settings for working with files, and print selected fields and records.

 

Surveyor/400

Linoma Software

Surveyor/400 is a database tool and file editor for the IBM i. It offers a drill-down interface, displays of relationships between physical and logical files, and filters for selecting records for global updates or other changes. Surveyor/400 gives users the ability to query, display, and edit file records; enter, run, and test SQL statements; create, copy, modify, and test stored procedures; display and change data areas; duplicate objects between systems/LPARs/IASPs with a few mouse clicks; and graphically design custom reports that can be executed, saved, and reused.

 

QuestView

Touchtone Corporation

QuestView works on physical and logical files to enable inquiry, maintenance, debugging, and analysis of a DB2 database. It also is a database- and program-generation tool for building interactive data-retrieval programs. The product features a GUI designed for IBM Rational Developer and WebSphere Development Studio users, works with large-object fields, can scan for different values in different fields simultaneously, sends audits to the user's choice of spooled or database files, and obeys any restrictions imposed by trigger programs.

as/400, os/400, iseries, system i, i5/os, ibm i, power systems, 6.1, 7.1, V7,

John Ghrist

John Ghrist has been a journalist, programmer, and systems manager in the computer industry since 1982. He has covered the market for IBM i servers and their predecessor platforms for more than a quarter century and has attended more than 25 COMMON conferences. A former editor-in-chief with Defense Computing and a senior editor with SystemiNEWS, John has written and edited hundreds of articles and blogs for more than a dozen print and electronic publications. You can reach him at This email address is being protected from spambots. You need JavaScript enabled to view it..

BLOG COMMENTS POWERED BY DISQUS

LATEST COMMENTS

Support MC Press Online

$

Book Reviews

Resource Center

  • SB Profound WC 5536 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. You can find Part 1 here. In Part 2 of our free Node.js Webinar Series, Brian May teaches you the different tooling options available for writing code, debugging, and using Git for version control. Brian will briefly discuss the different tools available, and demonstrate his preferred setup for Node development on IBM i or any platform. Attend this webinar to learn:

  • 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 company are not aligned with the current IT environment.

  • SB HelpSystems ROBOT Generic IBM announced the E1080 servers using the latest Power10 processor in September 2021. The most powerful processor from IBM to date, Power10 is designed to handle the demands of doing business in today’s high-tech atmosphere, including running cloud applications, supporting big data, and managing AI workloads. But what does Power10 mean for your data center? In this recorded webinar, IBMers Dan Sundt and Dylan Boday join IBM Power Champion Tom Huntington for a discussion on why Power10 technology is the right strategic investment if you run IBM i, AIX, or Linux. In this action-packed hour, Tom will share trends from the IBM i and AIX user communities while Dan and Dylan dive into the tech specs for key hardware, including:

  • Magic MarkTRY 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. Make sure your data survives when catastrophe hits. Request your trial now!  Request Now.

  • SB HelpSystems ROBOT GenericForms of ransomware has been around for over 30 years, and with more and more organizations suffering attacks each year, it continues to endure. What has made ransomware such a durable threat and what is the best way to combat it? In order to prevent ransomware, organizations must first understand how it works.

  • SB HelpSystems ROBOT GenericIT security is a top priority for businesses around the world, but most IBM i pros don’t know where to begin—and most cybersecurity experts don’t know IBM i. In this session, Robin Tatam explores the business impact of lax IBM i security, the top vulnerabilities putting IBM i at risk, and the steps you can take to protect your organization. If you’re looking to avoid unexpected downtime or corrupted data, you don’t want to miss this session.

  • SB HelpSystems ROBOT GenericCan you trust all of your users all of the time? A typical end user receives 16 malicious emails each month, but only 17 percent of these phishing campaigns are reported to IT. Once an attack is underway, most organizations won’t discover the breach until six months later. A staggering amount of damage can occur in that time. Despite these risks, 93 percent of organizations are leaving their IBM i systems vulnerable to cybercrime. In this on-demand webinar, IBM i security experts Robin Tatam and Sandi Moore will reveal:

  • FORTRA Disaster protection is vital to every business. Yet, it often consists of patched together procedures that are prone to error. From automatic backups to data encryption to media management, Robot automates the routine (yet often complex) 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:

  • FORTRAManaging messages on your IBM i can be more than a full-time job if you have to do it manually. Messages need a response and resources must be monitored—often over multiple systems and across platforms. 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:

  • FORTRAThe thought of printing, distributing, and storing iSeries reports manually may reduce you to tears. Paper and labor costs associated with report generation can spiral out of control. Mountains of paper threaten to swamp your files. Robot 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:

  • FORTRAFor over 30 years, Robot has been a leader in systems management for IBM i. With batch job creation and scheduling at its core, the Robot Job Scheduling Solution reduces the opportunity for human error and helps you maintain service levels, automating even the biggest, most complex runbooks. Manage your job schedule with the Robot Job Scheduling Solution. Key features include:

  • LANSA Business 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.

  • 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:

  • LANSASupply Chain is becoming increasingly complex and unpredictable. From raw materials for manufacturing to food supply chains, the journey from source to production to delivery to consumers is marred with inefficiencies, manual processes, shortages, recalls, counterfeits, and scandals. In this webinar, we discuss how:

  • The MC Resource Centers bring you the widest selection of white papers, trial software, and on-demand webcasts for you to choose from. >> Review the list of White Papers, Trial Software or On-Demand Webcast at the MC Press Resource Center. >> Add the items to yru Cart and complet he checkout process and submit

  • Profound Logic 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.

  • SB Profound WC 5536Join us for this hour-long webcast that will explore:

  • Fortra IT managers hoping to find new IBM i talent are discovering that the pool of experienced RPG programmers and operators or administrators with intimate knowledge of the operating system and the applications that run on it is small. This begs the question: How will you manage the platform that supports such a big part of your business? 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: