Volume 10, Number 8 -- February 23, 2010

Linoma Bolsters Surveyor/400 with Excel Capabilities, SSL

Published: February 23, 2010

by Alex Woodie

Linoma Software last week launched a new release of Surveyor/400, its "Swiss Army knife" i/OS utility that allows users to do everything from browsing DB2/400 records and editing stored procedures, to building custom reports and converting spool files to PDF. With the new version 3.7 release of Surveyor/400, Linoma has added new integration methods with Microsoft Excel, as well as support for SSL encryption to System i hosts.

The list of things you can do with Surveyor/400--a lightweight Java program with a graphical interface--is extremely long, hence the commonly used "Swiss Army knife" and "do everything" labels. Depending on the user's role--be it programmer, administrator, or end-user--Surveyor/400 can offer a range of useful capabilities.

Power users that often find themselves working with DB2/400 data in Excel spreadsheets will be happy to hear the Linoma product supports the new Excel 2007 spreadsheet software, which offers a range of information-manipulation capabilities (as well as that spiffy "ribbon" interface).

Version 3.7 also brings new Excel formatting capabilities that will allow users to create more polished-looking spreadsheets from System i data. Namely, the new release gives users the capability to automatically specify a range of options when exporting data from the System i, including title, spreadsheet name, autosize columns, and the font used in the title, headings, and data portions of a spreadsheet.

This release adds the capability to import Excel 2007 spreadsheets into database files on the System i, which will likely prove a handy feature for i/OS shops with extensive investments in, and usage of, Excel spreadsheets (which is probably most of them). Linoma provides users with graphical data mapping wizards to simplify the process of uploading data from Excel 07 to DB2/400.

Linoma also added support for Secure Sockets Layer (SSL) encryption when connecting to a System i host. SSL will provide another layer of security when handling sensitive business information with Surveyor/400, and help organizations comply with regulatory requirements governing security. SSL support is provided across many Surveyor/400 functions, including executing queries, editing files, transferring files, and 5250 emulation. (Surveyor/400 also includes a built-in 5250 emulator in its laundry-list of functions and capabilities.)

The new SSL support augments existing Surveyor/400 security capabilities, including the capability for administrators to restrict user access to specific libraries, files, fields, records, subrecords, and objects on System i servers, which was added with Surveyor/400 version 3.0 in 2005.

While Linoma often touted the performance and sub-second response time of Surveyor/400 (a hedge, as it were, against users' long-standing bias for green-screen computing and against anything graphical, let alone Java), it has take steps to improve performance further with version 3.7. To that end, Linoma adopted the Java Virtual Machine version 1.6 with the new release.

A number of other enhancements and fixes made it into this release, including: the capability to work with spooled files from output queue properties; the capability to use null parameters in the execution of stored procedures; the capability to delete triggers; the capability to cancel the Web Update function; among many other features that can be viewed at http://www.linomasoftware.com/products/surveyor/whatsnew.

Surveyor/400 version 3.7 is available now. The software supports IBM i 6.1 and older versions of the operating system. Pricing is unchanged, and starts at $995 for a P05 server with an unlimited number of users. For more information, see www.linomasoftware.com.


Linoma Boosts Surveyor/400's SQL Functionality

Linoma Bolsters Security of iSeries Database Tool

Product Review: Surveyor/400 Puts a Familiar Face on DB2/400 Access

                     Post this story to del.icio.us
               Post this story to Digg
    Post this story to Slashdot

Sponsored By

Robot/CONSOLE monitors your System i
resources--lines, subsystems, controllers, servers,
printers, message queues, or jobs--automatically.

Anytime a resource is not in its expected state,
Robot/CONSOLE responds. It can start or
stop programs, vary devices off or on, send messages--
practically anything.

Lose the burden of monitoring resources manually.

Request your FREE Information Kit today!

Editor: Alex Woodie
Contributing Editors: Dan Burger, Joe Hertvik,
Shannon O'Donnell, Timothy Prickett Morgan
Publisher and Advertising Director: Jenny Thomas
Advertising Sales Representative: Kim Reed
Contact the Editors: To contact anyone on the IT Jungle Team
Go to our contacts page and send us a message.

Sponsored Links

PowerTech:  Strengthen your security. Get a FREE Compliance Assessment today
looksoftware:  Learn more and get your complementary ilook licences
COMMON:  Join us at the annual 2010 conference, May 3 - 6, in Orlando, Florida


IT Jungle Store Top Book Picks

Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
The iSeries Express Web Implementer's Guide: List Price, $49.95
The System i RPG & RPG IV Tutorial and Lab Exercises: List Price, $59.95
The System i Pocket RPG & RPG IV Guide: List Price, $69.95
The iSeries Pocket Database Guide: List Price, $59.00
The iSeries Pocket SQL Guide: List Price, $59.00
The iSeries Pocket Query Guide: List Price, $49.00
The iSeries Pocket WebFacing Primer: List Price, $39.00
Migrating to WebSphere Express for iSeries: List Price, $49.00
Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
Getting Started with WebSphere Express for iSeries: List Price, $49.00
Can the AS/400 Survive IBM?: List Price, $49.00
Chip Wars: List Price, $29.95

The Four Hundred
The Power7 Systems Sales Pitch

i/OS Gets Short Sheeted with Power7 Thread Counts

The System iWant, 2010 Edition: Clustered Boxes

As I See It: Opinions Are Like ISPs--Everybody Has One

Spend on the Old, Scrimp on the New

Four Hundred Guru
Handling Constraint Violations in RPG

CPYTOIMPF Doesn't Create Column Headers, But You Can

Admin Alert: Six Things Power i Administrators Need to Know

Four Hundred Monitor
Four Hundred Monitor's
Full iSeries Events Calendar

System i PTF Guide
February 20, 2010: Volume 12, Number 08

February 13, 2010: Volume 12, Number 07

February 6, 2010: Volume 12, Number 06

January 30, 2010: Volume 12, Number 05

January 23, 2010: Volume 12, Number 04

January 16, 2010: Volume 12, Number 03

TPM at The Register
Teradata ekes out sales and profit growth

SGI spins up Cyclone HPC cloud

Unisys parts with server chief

Red Hat projects to seed cloudy IT

Big Blue says Power7 will make world smarter

Hitachi inks Xsigo pact for server I/O virt

IBM chills sealed data center with outside air

Riverbed WAN optimizers get SSDs, 10 GE

Intel's 'Tukwila' Itaniums - hot n' pricey

AMD talks energy with 'Llano' cores

Power7 v Power6 - it's all about the cache

Power7 - Big Blue eye on UNIX


Linoma Software
Vision Solutions
RJS Software Systems

Printer Friendly Version

Visual LANSA Gets Expanded Interoperability, Developer Convenience

Linoma Bolsters Surveyor/400 with Excel Capabilities, SSL

Lawson Updates M3 Suite of ERP Apps for i/OS

Customers Begin Using ilook to Web-Enable i/OS System Screens

Shield Adds IFS Replication to HA Offering

News Briefs and Product Shorts:

Aldon Ventures Into Professional Services with ACE . . . Micro Focus Streamlines Modernization Activities with Workbench 3.1 . . . Keane Unites AS/400 and Unix Healthcare Products and Teams . . . LogLogic Boosts Performance of Log Devices . . . eCMS Gets an Interface to Vehicle Scales . . .

Four Hundred Stuff


Subscription Information:
You can unsubscribe, change your email address, or sign up for any of IT Jungle's free e-newsletters through our Web site at http://www.itjungle.com/sub/subscribe.html.

Copyright © 1996-2010 Guild Companies, Inc. All Rights Reserved.
Guild Companies, Inc., 50 Park Terrace East, Suite 8F, New York, NY 10034

Privacy Statement