• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Linoma Boosts Surveyor/400’s SQL Functionality

    October 9, 2007 Alex Woodie

    With SQL making such deep inroads into the System i platform as a data access language, programmers can use every little bit of help to make writing and managing SQL easier. To that end, Linoma Software recently introduced a new version of its multi-function Surveyor/400 database utility that provides users with more powerful SQL-generating capabilities, including new wizards that automate SQL actions, such as joins, new color-coding to make SQL easier to read, and new security functions.

    Surveyor/400 is a versatile, Java-based, client-server program that enables users to accomplish a range of tasks on the iSeries server, such as viewing and editing DB2/400 files, accessing the IFS, writing and running SQL statements, creating stored procedures, converting spool files to PDF and Excel, and accessing applications via TN5250. The product offers so many features–over 20 of them, according to Linoma–that the company likens Surveyor/400 to a Swiss army knife.

    With Surveyor/400 version 3.4, Linoma has added several new SQL-related functions, including syntax coloring of SQL statements; enhancements to the SQL-generating wizards, specifically around joins; more predesigned SQL templates that feature with color-coding, and new audit logging of executed SQL statements, which will boost the security of SQL-based reports and applications. Non-SQL related enhancements include new testing and execution enhancements to the stored procedure tool; the capability to view detailed properties on database triggers; and support for running the tool as a plug-in to IBM WDSc 7.0.

    One happy user of the new release is Bill Barnes, a programmer with The Pantry, a $6 billion, publicly traded company that includes a chain of nearly 1,500 convenience stores, restaurants, and gas stations in 11 Southeastern United States.

    Barnes particularly likes the new syntax coloring feature in version 3.4, which he says makes it easier to read his hand-written SQL. He also appreciates some of the new error-reporting features added to the product.

    One of the strengths of Surveyor/400 is its error reporting, according to Barnes. Compared to other products, like IBM’s Client Access suite of tools and other third-party DB2/400 tools, Surveyor/400’s simple and intuitive interface makes it easier to track down problems.

    “Surveyor is a lot more forgiving. It doesn’t just blow up if it hits a bad data element,” he says. “It gives you a log, and says ‘Here are the records that didn’t go and here are the reasons why’ rather than just blowing up. Client Access would never tell you where it blew up. It would just blow up, and then you have to start figuring out where.”

    Barnes also uses Surveyor/400 for standard housecleaning tasks, such as identifying old files, and purging them to tape or deleting them to free up DASD. The tool is also used as a SQL editor for writing the data access components of The Pantry’s homegrown RPG applications, for displaying and converting spool files, and for generating reports for the accounting department and the state of North Carolina’s tax collectors.

    The other day, Barnes even discovered a new way Surveyor/400 is being used at The Pantry. One of his users was running a report with the product, and then using it to export the report to a spreadsheet. “I didn’t even know you could do that in Surveyor,” he says. “I just never paid much attention to it. I just print the report, look at it, and be done with it. But you can actually send it to the spreadsheet.”

    Surveyor/400 version 3.4 is available now. The product’s server component requires OS/400 V5R1 or higher, while the product’s client component runs on Windows, Mac OS X, or Linux. The software is priced according to tier, and starts at $995 per server. For more information or trial downloads, visit www.linomasoftware.com.

    RELATED STORIES

    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

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    ARCAD Software

    [Webinar] Synchronous IBM i and non-IBM i Deployments
    April 13 at 12 p.m. ET

    Do you need to automate and synchronize deployments across ALL your environments and applications?

    Many backend IBM i applications have off-platform components, such as an API layer, or Web front-end. To ensure your application stays reliable, artifacts must be deployed securely and in-sync.

    In our Webinar, learn how to orchestrate all your deployments, multi-platform and multi-cloud, using DROPS by ARCAD Software:

    – One single console to deploy across multiple endpoints – IBM i, Windows, Linux, IBM z, on prem or cloud

    – Real-time visibility of application status, from anywhere

    – Deployment plans and one-click-deploy

    – Rollback on error

    Simplify and secure your application delivery.

    Register Now

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    SafeData:  The iSeries HA Solution that’s Guaranteed
    COMMON:  Join us at the annual 2008 conference, March 30 - April 3, in Nashville, Tennessee
    NowWhatJobs.net:  NowWhatJobs.net is the resource for job transitions after age 40

    IT Jungle Store Top Book Picks

    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 Developers' 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
    iSeries Express Web Implementer's Guide: List Price, $59.00
    Getting Started with WebSphere Development Studio for iSeries: List Price, $79.95
    Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
    Getting Started with WebSphere Express for iSeries: List Price, $49.00
    WebFacing Application Design and Development Guide: List Price, $55.00
    Can the AS/400 Survive IBM?: List Price, $49.00
    The All-Everything Machine: List Price, $29.95
    Chip Wars: List Price, $29.95

    What Are Else Are Employees Up To? Shopping Online During Con Calls Controlling System i Shutdown Activities Using an Intelligent Power-Handling Program, Part I

    Leave a Reply Cancel reply

Volume 7, Number 38 -- October 9, 2007
THIS ISSUE SPONSORED BY:

BOSaNOVA
Aldon
nuBridges
Computer Measurement Group
RJS Software Systems

Table of Contents

  • ACOM Updates EZ Content Manager
  • looksoftware’s Modernization Suite Resembling a Full IDE
  • Pat Townsend Normalizes i5/OS Log Data for Security Analyses
  • Linoma Boosts Surveyor/400’s SQL Functionality
  • PowerTech Updates Compliance Manager
  • IBM Comments on iSeries Access and Windows Vista
  • Update on Virtualization Manager’s i5/OS LPAR Capabilities
  • Raz-Lee Supports SSL in i5/OS Firewall
  • Inventive Designers Launches DTM for iSeries Version 3
  • Optio Software Saves Manufacturer from the Paper Chase

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • IBM Tweaks Some Power Systems Prices Down, Others Up
  • Disaster Recovery: From OS/400 V5R3 To IBM i 7.4 In 36 Hours
  • The Disconnect In Modernization Planning And Execution
  • Superior Support: One Of The Reasons You Pay The Power Systems Premium
  • IBM i PTF Guide, Volume 25, Number 13
  • IBM i Has a Future ‘If Kept Up To Date,’ IDC Says
  • When You Need Us, We Are Ready To Do Grunt Work
  • Generative AI: Coming to an ERP Near You
  • Four Hundred Monitor, March 22
  • IBM i PTF Guide, Volume 25, Number 12

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2023 IT Jungle