• Run SQL Scripts: Use Temporary JDBC Settings

  January 20, 2010 Skip Marchesani

  I consider myself to be a power user of Run SQL Scripts and use them for a variety of purposes, including ad hoc queries to do data analysis. Run SQL Scripts can be configured for your personal preferences (SQL default schema or current library, schema or library list, SQL or system naming convention, and other parameters) by clicking on Connection in the toolbar and then JDBC properties. Once you select your personal preferences and click the Connect button on the bottom of the JDBC Setup panel, your preferences are saved and become the default each time you invoke Run SQL

  …

  Read more

• Can a Function Return More Than One Value?

  January 20, 2010 Hey, Ted

  Is it possible for an RPG subprocedure to return more than one value? (I assume it isn’t; the RETURN opcode only allows for one argument.) I want to write a function subprocedure that will return a data structure of information taken from various database files. However, the subprocedure will also need to return a status code to indicate whether or not the I/O was successful. Do you have any suggestions? –Travis What you want to do is something like this: eval (MyDataStructure: Status) = GetData (KeyValue) No, that won’t work. But I can show you two other ways that will.

  …

  Read more

• Admin Alert: Erasing i5/OS Disk for Fun and Compliance

  January 20, 2010 Joe Hertvik

  When decommissioning iSeries, System i, or Power i systems, there may be legal considerations in erasing disk drive data. Decommissioning can occur when removing disk drives from a system; when completing a Disaster Recovery Test on an outside provider’s machine; or when an i5/OS machine is sold or returned to a leasing company. The problem is that decommissioning disk drives can easily violate legally mandated compliance standards. Compliance and Decommissioned Disk Drives Like most systems, i5/OS data doesn’t necessarily disappear when you reinitialize your disk drives. Clever and determined hackers may be able to reconstruct supposedly erased data if they

  …

  Read more

• Unitrends Delivers Backup Simplicity with D2D Appliances

  January 19, 2010 Alex Woodie

  Complexity can be a killer in the IT business. Layer too many moving parts into a given business process, and you can be sure that somebody will find a way to break it. One IT vendor that’s been helping small and mid-sized businesses root out complexity from their backup and recovery processes is Unitrends, which has quietly amassed a substantial customer base with its all-in-one line of disk-to-disk (D2D) and D2D2D backup appliances. Mark Campbell, the CTO and COO of Unitrends, knows a thing or two about the lasting power of simple yet elegant designs. Campbell was running NCR’s

  …

  Read more

• Rainmaker’s Profit Optimization Software Good as Gold to Casinos

  January 19, 2010 Alex Woodie

  If you’ve ever been turned down for a room in a major Las Vegas casino when the hotel was obviously not full, it probably made you mad. And it probably doesn’t help knowing that the software that told the front desk to reject you was written by the Rainmaker Group. But when you realize that Rainmaker’s revenue optimization software has made casinos hundreds of millions, if not billions, of dollars, you can begin to understand why it’s in such widespread use. Rainmaker started out in 1998 writing schedule optimization software for a completely different business: the airline industry. But

  …

  Read more

• Pat Townsend Updates MFT Offering for i/OS

  January 19, 2010 Alex Woodie

  Patrick Townsend Security Solutions last week introduced Alliance All-Ways Secure version 5.0, a new release of its managed file transfer (MFT) solution for System i customers. The product brings support for 128-bit SSH encryption over FTP (sFTP), which will allow customers to share files with banks that have standardized on sFTP. Version 5.0 also brings enhancements in the area of configuration and logging, and makes it easier for IBM i users to comply with data privacy laws, PTSS says. Pat Townsend (the man and the company) is a recognized expert in encryption on the i/OS platform, and has been selling

  …

  Read more

• Linoma Bolsters GoAnywhere MFT Tool with New Features

  January 19, 2010 Alex Woodie

  Linoma Software last week announced a new version of GoAnywhere Director, its enterprise-strength managed file transfer (MFT) solution that runs on i/OS and other major operating systems. With version 3.0, the vendor has expanded its support for secure transfer protocols and digital signatures, and delivered new ways that customers can use the tool to automate recurring business processes that involve secure file transfer. GoAnywhere Director debuted nearly two years ago as the platform-independent, browser-based replacement for Transfer Anywhere, which Linoma debuted in 2002, and which ran only on OS/400 and Windows. About four months ago Linoma split the GoAnywhere product

  …

  Read more

• FIS Reports Solid 2009 Sales of i/OS Core Banking System

  January 19, 2010 Alex Woodie

  Jack Henry & Associates and Fiserv may dominate discussions of so-called “core” account processing platforms that run on the IBM i/OS platform. But with more than a dozen new multi-year licenses for its HORIZON core banking system in 2009, Fidelity National Information Services (FIS) is making a strong case for its i/OS-based software. FIS was created in November 2006 when Fidelity National Financial spun off its information services division into a separate entity, and combined it with card issuer Certegy. Several years and several acquisitions later, FIS chairman William P. Foley, II led the company’s biggest acquisition yet: the $2.94

  …

  Read more

• Capitalware Rolls Out Visual Editing Tools for MQSeries

  January 19, 2010 Alex Woodie

  Capitalware last month debuted two new tools that allow users to browse and edit the contents of their MQSeries (WebSphere MQ) messages. MQ Visual Edit version 1.5.1, which supports full editing capabilities, and MQ Visual Browse version 1.5.1, which restrict users to viewing messages, will be welcomed by programmers and testers who need to work with MQ messages, the company says. MQ Visual Edit provides a full range of capabilities for developers and support professionals working with MQ messages. The Java-based software provides a graphical environment that allows users to open and work with the contents of MQ messages from

  …

  Read more

• ProData Updates Deleted Records Software for i/OS 6.1

  January 19, 2010 Alex Woodie

  ProData Computer Services last week unveiled the first new version of its Reactivate Deleted Records (RDR) software in nearly a decade. The software, which recovers files that have been accidentally deleted on the System i server, needed to be updated to work with the latest release of IBM i/OS, version 6.1. RDR helps to automate the process of recovering records that have been accidentally deleted, which occurs surprisingly often on this platform. The product provides access to the RDR command, which allows users to recover all the records from any member of a physical file that has been deleted, or

  …

  Read more

Previous Articles Next Articles