Transcript Surveyor/400 - Linoma Software

Surveyor/400
Agenda

Presenter – Bob Luebbe of Linoma Software

Company Overview

Surveyor/400 Overview

Live Surveyor/400 Demonstration

Questions and Answers
About Us

Linoma Software founded in 1994

Based in Nebraska

Stable company with no Outside Funding

Dedicated to Research and Development

IBM Advanced Business Partner

Member of IBM’s Developer’s Program and Tools Network

Responsive Toll-Free Technical Support
Linoma’s Customers
Over 3,000 Installations Worldwide
AAA Cooper Transportation
Mennonite Mutual Aid
Abbott Laboratories
Midwest of Cannon Falls
AF&L Insurance CO.
Oriental Trading
Banner Wholesale Grocer
Performance Food Group
Blodgett Corp.
Peterson Manufacturing
Cabelas
Pfizer
Charles Kraft
Raynor Garage Doors
Circuit City
Sandusky International
City of Hampton
Service Insurance Group
City of Loveland
SYSCO
Colony Liquor & Wine
U.S. Olympic Committee
Duncan Aviation
Victaulic Co. of America
Empire Fire and Marine
Weir Specialty Pumps
French Quarter Hotels
Werner Company
InfoUSA
Wheatland Electric Cooperative
Kawasaki Motors
Wynne Systems Inc
Manheim Auctions
xpedx
Linoma Products
Innovative solutions for the IBM iSeries & System i…
Transfer Anywhere™ automates data retrieval, translation, file
encryption, compression and distribution– all from one easy-touse interface. Includes OpenPGP, SFTP, FTPS and ZIP
encryption standards.
Surveyor/400™ is an award-winning graphical productivity suite
for secure database queries, reporting, file editing, file transfers,
and spooled file management.
RPG Toolbox™ modernizes existing RPG source code to /FREEform and allows developers to write/maintain applications faster.
Crypto Complete automates the encryption of System i database
fields with strong key management and auditing.
Surveyor/400 Awards and Recognition
Search400.com's
Product of the Year (2003)
eServer Proven by IBM
Search400.com's
Bronze Award (2004)
Selected for IBM’s iSeries
Developer Roadmap
Database Tools for I.T. Personnel

Explore iSeries libraries and database files

View field layouts and database relations. Print or
export into PC documents.

Query, display and edit Database Records
through a spreadsheet-like interface

Perform mass record updates and deletes

Upload/download data, including Excel files.
(Can execute immediately or schedule)

Replicate DB2 records between iSeries systems
and LPARs (Field mapping wizards included)

Enter, run and test SQL statements

Create, alter and drop Tables and Indexes

Create, modify, copy and test Stored Procedures

Reverse engineer database files into DDS or DDL

Manage database files (copy, duplicate,
reorganize, etc.)
“We appreciate your constant attention to the product as it
is our primary DBA tool for our iSeries. No other product
comes close to Surveyor/400!"
Dino Biondo, Amerinet
Other Tools for I.T. Personnel

View extensive details on any object or library

Switch to different iSeries systems, LPAR partitions
and IASPs with the mouse

Distribute libraries and objects to other iSeries
systems and LPARs

Display and change data areas

Clean up disk space by finding and removing
unused objects

Find and track large database files on the system

Verify that libraries and objects are backed up

Create, download and upload Save file objects

View and download spooled files into PDF or TXT

Manage and transfer IFS directories and files

Perform 5250 emulation
Also plugs into Websphere Development Studio (WDSc)
"I have flipped thru the Surveyor/400 guide at least twice, and
every time a new possibility jumps out at me. This is truly a
function rich tool that makes my programming life easier."
Bruce Chaffin, Western Power Sports
Tools for End-Users

Query iSeries data through an intuitive spreadsheetlike interface

Filter and sort data using graphical wizards

Create custom layouts over files which can be saved
and shared with other users

Download data into Excel, XML and text files

View and convert spooled files into PDF or text files

Perform 5250 emulation

Client Access is not required
“We had the FileScope file editor before we purchased
Surveyor/400 about 3 or 4 years ago. Surveyor/400 is like
a space shuttle compared to the horse and buggy we had.
I love Surveyor/400 and so do my 150 users who use it
every day and can't live without it.”
Brian Due, Victaulic
Security and Audit Logging

Each user must have valid iSeries id and password

Honors existing OS/400 security

Manage users within User Groups

Restrict access to Surveyor/400 features by user or user group

Generate audit trails of database record changes

Generate audit trails of file transfers performed

Restrict users to specific:
• Libraries
• Database files
• Fields within database files
• Records within database files

More secure than Client Access File Transfer and ODBC
- No exit programs to write
- No changes to object authorities needed
- Just click on/off the user authorities within Surveyor/400
“Occasionally I stumble across an iSeries 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, iSeries Network
Start Live Demo
Getting Started
Download
Today!
New Customers – How to Install:

Download at http://linomasoftware.com/download/index.html

Automatic 30-day trial

Can install to Microsoft Windows, Macintosh and Linux

Does not require IBM's Client Access

Need a TCP/IP connection to your iSeries
Existing Customers – How to upgrade:
 Choose “Web Update“ from Surveyor/400 Help menu
 Product upgrades can be distributed to additional workstations through the IFS
Help:
 Manual: http://linomasoftware.com/download/manuals/SurveyorUsersGuide_V3.pdf
 Suveyor/400 includes comprehensive on-line help text with index, plus interactive tutorials
 Support forum at http://www.linomasoftware.com/phpBB2/
 Call Linoma Software at 1-800-949-4696 or email at [email protected]
Web site:
E-mail:
www.linomasoftware.com
[email protected]
Toll-free:
Direct:
Fax:
1-800-949-4696
(402) 944-4242
(402) 944-4243
Address:
1409 Silver Street
Ashland, NE 68003 USA