• NOMAX? No Way!

  April 25, 2012 Hey, Ted

  I just read *NOMAX Does Not Mean Infinite Capacity and I politely beg to differ. I work at some shops with smaller and older systems with smaller disk capacity (70 GB, 140 GB). Some are already using more than 70 percent of available space. If I read the capacities correctly, a physical file can hold over four billion records. I did some calculations and I think I’d fill up a system before reaching capacity. For DDS-described files, I usually set some maximum number of records, as 10,000 seems ridiculously low. Now that you have mentioned SQL described tables, which I

  …

  Read more

• Specify SQL Table-creation Library at Runtime

  April 25, 2012 Hey, Ted

  I have an RPG programs that creates work tables in QTEMP. I’d like to be able to specify the library at runtime. I tried using a host variable for the library in a CREATE TABLE command, but that didn’t fly. I am using the system naming convention. Can you help? –Ben I wish CREATE TABLE would allow a host variable for the explicit qualifier, but it doesn’t. Here are a few ways that work. 1. Use dynamic SQL. Embed the library name in the SQL command. D SqlCommand s 256a varying D WorkLib s 10a /free *inlr = *on; SqlCommand

  …

  Read more

• Getting PC5250 F1-F24 Keys to Work Correctly on HP Laptops

  April 25, 2012 Joe Hertvik

  Today’s tip comes from my own experience with a recent model HP Pavilion laptop that I use for my business. The problem occurred when I loaded up the PC5250 emulator software that comes with System i Access for Windows V6R1M0. I attached to and signed on to my production IBM i box with PC5250, executed a green-screen command, and hit the F3 key to exit the screen. Nothing happened. The F3 key didn’t work. Neither did F5, F10, F12, or any other F-key from F1 all the way up to F24. My PC5250 F-keys were dead. Experimenting with different keystroke

  …

  Read more

• SAP Fleshes Out HANA’s Roadmap with Heavy Dose of Sybase

  April 25, 2012 Alex Woodie

  SAP last week announced additional details of the roadmap for HANA, the in-memory database technology that the German ERP software giant is currently using for business intelligence workloads. Not surprisingly, the plans calls for HANA to become the underlying database powering everyday business transactions in the SAP Business Suite, not just analytic workloads. But before then, SAP’s Sybase database will play a bigger role. SAP executives have not been shy about telling the world about their grand plans for HANA, which has become an exceptionally popular product for SAP since the company started selling it less than a year ago

  …

  Read more

• Key Info Wins Award for IBM i Video

  April 25, 2012 Alex Woodie

  Key Information Solutions has won an award from IBM for a video about how it helped recycling company Recology implement an IBM i application that helps it achieve its mission of reducing waste in San Francisco. Recology has contracts with the City by the Bay to collect recyclable materials from homes and businesses. Every week day, fleets of Recology trucks span out across the hilly town, picking up used bottles, cans, paper, and vegetable material and food scraps. The trucks haul the materials back to Recology’s sorting plant, where it is turned back into 16 different raw materials that are

  …

  Read more

• A ‘New’ Infor Proclaims Need for Speed

  April 24, 2012 Alex Woodie

  Infor is using this week’s user conference in Denver, Colorado, as a coming out party to reintroduce its customers to the company. During his opening keynote yesterday, CEO Charles Phillips explained to several thousand Infor and Lawson attendees how dramatically Infor has changed over the last 18 months, and told them to expect a rapid period of product development in the near future, with a strong focus on standardization across ERP product lines. “This is really kind of a unique event because you’re really being introduced to a new company. . . called Infor,” Phillips said during his keynote. “I

  …

  Read more

• Oracle Revs JDE EnterpriseOne and World

  April 24, 2012 Alex Woodie

  Oracle yesterday unveiled new releases of both JD Edwards ERP suites, including JDE World version 9.3 and JDE EnterpriseOne 9.1, at the vendor’s Collaborate 2012 conference in Las Vegas. The new releases contain hundreds of enhancements, with an emphasis on user interface improvements, enhancements to industry- and process-specific functionality, and continued regulatory compliance. EnterpriseOne also gets a new operational reporting tool, called OneView, while World now requires IBM i 7.1. The simultaneous launch of new releases of both major ERP suites is a first in JD Edwards history, according to Lyle Ekdahl, group vice president and general manager of Oracle’s

  …

  Read more

• Why You Need a Data Warehouse

  April 24, 2012 Alex Woodie

  If your IBM i shop is like most, it uses some type of business software, such as an ERP system built atop DB2/400, to process transactions. And while it may excel at processing data quickly and efficiently, the setup is not ideal for answering detailed questions that a manager may have about the business, i.e. running analytical workloads. For various reasons, a separate data warehouse will be a far superior solution–especially if it’s implemented on an IBM i server, says data warehousing expert Alan Jordan. There are lots of good reasons to run a data warehouse. Perhaps the most obvious

  …

  Read more

• Enforcive Delivers Better SQL Monitoring for IBM i

  April 24, 2012 Alex Woodie

  Enforcive (formerly Bsafe Information Systems) last week unveiled a new release of its IBM i security suite, called Enforcive/Enterprise Security. With version 7.2, the company delivered support for monitoring interactive SQL queries in real time, providing a way to monitor the execution of both written and embedded SQL statements. This release also brings enhancements to file integrity monitoring, auditing, and alerting features of the suite. Enforcive has helped IBM i customers keep an eye on SQL for some time. The company’s SQL monitor looks for SQL activity, including interactive SQL statements submitted by users and statements embedded in RPG, DRDA,

  …

  Read more

• Kisco Locks Down IBM i Security Tool

  April 24, 2012 Alex Woodie

  Kisco Information Systems last week unveiled SafeNet/i 9.0, a new version of its IBM i network security tool, which used to go by the name SafeNet/400. The new version uses IBM journaling to keep irrefutable logs of system activity. Other areas of enhancement include support for new IBM exit points, IFS object checks, user profile security, and a GUI redesign. SafeNet/i is a network security tool that uses IBM exit points to lock down potentially dangerous routes of access to the IBM i server, such as ODBC and FTP connections. It has been said over and over again, but it’s

  …

  Read more

Previous Articles Next Articles