Surveyor/400

Surveyor/400 provides an intuitive graphical interface for efficiently working with your IBM i database files, spooled files and IFS files. Surveyor/400 is so powerful and user-friendly, both IT personnel and end-users will immediately benefit from its comprehensive features.

Image

Productivity Suite 

A wide variety of users can take advantage of the benefits of Surveyor/400. With its extensive built-in security, your organization has control over which features, libraries, files, fields and records are available for each individual user.

Image

Developers/Analysts/DBAs 

• Surveyor/400 provides a variety of tools for IBM i Developers:
• Explore your IBM i through a drill-down tree interface similar to Windows Explorer
• View extensive details on any object through an intuitive multi-tabbed panel
• Query, display and edit database records using Surveyor/400’s graphical File Editor
• Perform mass updates and deletes of database records that meet your filter criteria
• Track database record changes with detailed audit logs
• Display database relations between Physicals and their Logicals
• Print or copy database file layouts into Excel
• Enter, run and test SQL statements using Surveyor/400’s comprehensive SQL editor
• Create, modify, copy and test Stored Procedures
• Reverse engineer database files into their corresponding DDS or DDL source code
• Display and change data areas
• Find objects and files using a wide variety of search criteria (generic name, dates, sizes, etc.)
• Access objects quickly by keying in their object name through a “fast path” dialog
• Organize related files into user-defined groups
• Manage objects using the mouse or a command line (e.g. duplicate, move, delete, change, etc.)
• Switch to different IBM i systems, LPAR partitions and IASPs with just a few mouse clicks
• Launch Surveyor/400 components from RDi (WDSc)

Performance 

Surveyor/400 was designed with the speed and efficiency of traditional “green screen” applications in mind while using a user-friendly GUI. There are several ways to access files and objects through Surveyor/400’s interface depending on the user’s knowledge of the system. Users can either perform filtered searches or drill down through libraries to explore objects on the system. Surveyor/400’s exclusive “Fast Path” feature can also be used to access an object by its name. IT personnel can launch Surveyor/400’s Graphical File Editor directly from a green screen command line.

Security & Auditing 

Surveyor/400 provides access to IBM i data without compromising file integrity or security. All existing object and library permissions will be honored for each user. Additionally, a Surveyor/400 administrator can restrict features by user ID or group, which offers precise control over which functions can be utilized (e.g. an end-user can be granted rights to only view and download data in a particular library). 

For a specific user (or group of users), you can configure Surveyor/400 to create audit logs for when any of the following events occurs: 

• Records are edited (added, changed, deleted)
• Records are imported or exported from IBM i
• Spooled files are exported from IBM i • SQL statements are executed
• SQL statements are executed

Administrators/Operators 

Perform any of these administrative functions on the IBM i via an intuitive, point/click graphical interface: 

• Duplicate objects between IBM i systems, LPARs and IASPs
• Replicate DB2 data between systems using wizards for filtering records and mapping fields
• Clean up disk space by finding and removing unused objects
• Find and track large database files on the system
• Verify that your libraries and objects are getting backed up
• Create, download and upload Save file objects
• Work with files and directories on the Integrated File System (IFS)
• Import and export Excel documents and text files into database files

IBM i End-Users 

End-users now have much easier access to the information they need: 

• Query and sort data using built-in graphical wizards
• Browse data through an intuitive spreadsheet-like interface
• Graphically design custom reports that can be executed, saved and reused
• Download data into Excel documents and text files
• View and convert spooled files into PDF or text files
• Perform 5250 emulation using Surveyor/400’s built in emulator (client access is not required)
• Automate file transfers to/from IBM i

What People Are Saying About Surveyor/400 

“We were looking for a spooled file for a user who generates hundreds of spooled files into a large output queue. We decided to put Surveyor/400’s Spool File Manager to the test. Wow! It’s fast, powerful and versatile. We are most impressed.” 

-Tom Prusa, Pfizer 

“This is a great product and is proving to be very useful since we are importing and exporting a lot of data to share with other companies. Surveyor/400 has many features which save me a great deal of time and effort - delimited exports, imports, data cleaning, etc.” 

-Ted Hendricks, Fluke Biomedical Corporation 

“I have really enjoyed using Surveyor/400. These are three main ways I use it: 

1. Instead of going through a combination of several other programsI can now run a quick query on the IBM i and in seconds export that data for use in Excel or Access. It saves me probably two hours a week and lots of hair. 

2. The properties section gives me much more information quickly than other programs and in a format that is very easy to view and understand. 

3. The Surveyor/400 File Editor gives me a great place to do quick, flexible queries. I no longer need to go into Query/400 for a fast look at a file. Once in the file editor, I am able to make changes quickly. THANKS!” 

-John Conlon, Nobel/SYSCO Foodservice 

“Our programmers just love the WDSc plug-in. It’s great having quick access to Surveyor/400’s tools from within the WDSc environment.” 

-Brian Due, Victaulic Company of America

“Occasionally I stumble across an IBM i utility that’s so easy to use and well designed it immediately appears on my ‘must have’ software list. Linoma Software’s Surveyor/400 is one such utility.” 

-Bryan Meyers, System i Network