• Dynamically Invoke SQL UDFs From RPG Code

  September 7, 2011 Hey, Mike

  I’m wondering if it is possible to use dynamic SQL (prepare/execute or execute immediate) to call a User Defined [scalar] Function (UDF). I understand we can use the SET statement in our code but we would like to “soft” code some RPG business logic and we are looking at having the RPG code dynamically call certain UDFs based on certain conditions. So it would be nice to create dynamic SQL statements to call certain UDFs. Thanks! –Brian Hi, Brian: Today is your lucky day because there is a way to do this. Starting with V5R1, the VALUES INTO statement can

  …

  Read more

• Admin Alert: Starting Multiple PC5250 Sessions in a Batch File

  September 7, 2011 Joe Hertvik

  In a recent column, I demonstrated how to configure a PC5250 session so that you can run multiple sessions on the same PC to a single iSeries/System i/Power i partition. The problem with that technique was that it only worked using sessions that connected to the same partition. This issue, I’ll demonstrate how to automatically start multiple PC5250 sessions on the same PC that connect to different partitions. Today’s column was inspired by reader Bill Swann, who reminded me that the iSeries Access for Windows package includes a very simple procedure for launching multiple PC5250 sessions at the same time

  …

  Read more

• Field-Level Encryption Handles Security Compliance for Collections Firm

  September 6, 2011 Dan Burger

  Data encryption has taken on a much larger role in IT departments ever since the protection of sensitive and confidential information became a high priority for so many companies. We hear a lot of complaints about regulatory compliance, but without it your personal information is an easy target for those with criminal intentions. For many IBM i companies, the question is not about whether to encrypt data, it’s how to encrypt data. A good example is Bass & Associates P.C., a law firm providing national debt recovery services. Financial institutions have really felt the heat of regulatory compliance. They handle

  …

  Read more

• Infor Hits the Road with New ‘Infor10’ Brand

  September 6, 2011 Alex Woodie

  Fresh off its acquisition of Lawson Software, Infor has embarked on an international road show to proselytize about its software and its new “Infor10” brand. The name change, which debuted at its Infor Channel Partner Summit held in July, has been applied to all of its mainstream enterprise products–including four IBM i-based ERP suites–but not its newly acquired Lawson products. So, what is Infor10? According to the company’s Infor10 webpage , the new name is an umbrella term that groups all of its current enterprise software, including ERP, CRM, EAM, HCM, business intelligence, and financial management applications. Infor10 has also

  …

  Read more

• Bug Busters Refines HA Software

  September 6, 2011 Alex Woodie

  Bug Busters Software Engineering is shipping a new version of its IBM i high availability software, called Remote Software Facility (RSF). Version 9 brings several new features that should improve the running of an HA environment, including faster role swaps and more automation throughout the product. Bug Busters also included a new “change while active” capability that will reduce administrative downtime. Bug Busters has been chasing the IBM i HA market for the last five years with RSF-HA, which debuted with RSF 7.3. Based on the core RSF product that the Seattle, Washington, company originally developed to help ISVs

  …

  Read more

• looksoftware Wants it Rich and Thin

  September 6, 2011 Dan Burger

  Sometimes we all get tired of people telling us we can’t have it both ways. It has to be one or the other. A good example is the comparison between thin client and rich client. Thin client is popular because it’s convenient. Rich clients are a really graphical, really responsive interface. looksoftware believes they have narrowed the gap between those two with its introduction of lookserver 9. This latest version of looksoftware’s server-based tool that delivers IBM i applications as HTML Web pages and published Web services has put its emphasis on being fast and easy and good looking. Is

  …

  Read more

• Oracle Loses to SAP in Appeals Court

  September 6, 2011 Alex Woodie

  Last week a federal judge threw out the $1.3 billion penalty that a jury awarded to Oracle in its TomorrowNow patent infringement case against SAP, and suggested Oracle accept $272 million, or the actual damages that Oracle proved in the case. Oracle says it plans to fight the decision in a bid to uphold the original damages, which means a new trial is likely. The $1.3 billion verdict against Oracle was “grossly excessive,” U.S. District Judge Phyllis Hamilton wrote in a ruling released last week. Hamilton, who issued a ruling in SAP’s appeal of the case in the U.S.

  …

  Read more

• IBM Bolsters Performance and Capacity of DS3500 Array

  September 6, 2011 Alex Woodie

  IBM‘s entry-level DS3500 Express storage array can now utilize solid state drives (SSDs), giving the array a speed boost for high performance application environments. Meanwhile, the addition of a new high-speed 900 GB 2.5-inch SAS drive and a 3TB 3.5-inch near line SAS drive gives customers more storage options for their growing data library. The DS3500 Express is one of IBM’s lower end arrays. With the optional expansion enclosures (EXP3512 and EXP3524), the DS3500 can support up to 192 SAS drives of various types, speeds, and sizes, giving customers many TBs of storage. And with the capability to mix

  …

  Read more

• Las Vegas Sands Taps SAS for Predictive Analytics

  September 6, 2011 Alex Woodie

  Las Vegas Sands, a $6 billion collection of casino resorts around the world, has selected business intelligence (BI) software vendor SAS to help it gain more insight into the behavior and spending patterns of its patrons, and to ultimately boost profits. The company says the new SAS solution easily handles volumes of data that challenged its previous BI tools. The Las Vegas Sands Corp. (LVSC) owns three properties in Las Vegas, including The Venetian, The Palazzo, and the Sands Expo and Convention Center; three in Southeast Asia, including The Sands Macao, The Venetian Macao, and The Marina Bay Sands in

  …

  Read more

• IntelliChief OEMs OCR from IBM

  September 6, 2011 Alex Woodie

  IBM i shops that have selected IntelliChief as their document and content management standard will soon be using IBM technology if they choose to use IntelliChief’s optical character recognition (OCR) software, called IntelliChief Capture Enterprise. In early August, IntelliChief announced that it has entered into an agreement with IBM to use its OCR functionality with IntelliChief Capture Enterprise. OCR technology eliminates the need for humans to enter data by using scanners that read the data from fields in structured and semi-structured forms, as well as some unstructured sources, too. “Offering IntelliChief customers full OCR capabilities enables them to accelerate document

  …

  Read more

Previous Articles Next Articles