March 23, 2011 Skip Marchesani
|
In my previous article Duplicating CPFY Function Using SQL, I presented three questions that are frequently asked regarding SQL that are interrelated:
I said the answer to all three questions was a qualified YES and introduced the concept of using the INSERT INTO |
March 23, 2011 Hey, Ted
|
I am working on a project using DB2 for i, but my experience is with other database management systems. I can’t find the SQL TRUNCATE TABLE statement. Does DB2 cover this functionality some other way? –Brad Even in 7.1, the latest release, IBM does not implement the TRUNCATE TABLE statement. However, since this statement is included in other DB2 products, as well as in Informix, I expect we’ll see it eventually as part of our world. For the benefit of readers who are not familiar with TRUNCATE TABLE, this statement removes all rows of a table (records of a physical |
March 23, 2011 Hey, Joe
|
Last year, I stumbled on a cool method for automatically deleting spooled files. When you create a spooled file, you can set the number of days that you want to keep that file on your system. Then once a night, you can submit a job that runs the Delete Expired Spooled Files (DLTEXPSPLF) command that will automatically delete expired spooled files. You should try it. –Peter After working with the Power i and its antecedents for almost 30 years, I always find it interesting when somebody shows me something valuable that I haven’t used before. DLTEXPSPLF is a simple command |
March 22, 2011 Alex Woodie
|
The capability to track the performance of a database in real time can be a critical success factor, particularly for enterprise applications and large e-commerce websites. One company that’s carving itself a niche in this department, ExtraHop Networks, recently added support for IBM‘s DB2 database management system–including the IBM i variant commonly known as DB2/400–giving the Seattle startup coverage of the most popular types of databases. ExtraHop was founded four years ago to serve the market for performance management tools. The founders, who hailed from networking product developer F5 Networks, started with the vision that the best |
March 22, 2011 Alex Woodie
|
Several years ago, the owner of InterForm A/S tasked two business partners with leading the expansion of the Danish company’s products into the United States. The company, whose suite of IBM i-based document management software is well known in Europe, is still trying to find its footing in a U.S. market that has become more open following the divestiture of IBM‘s printing unit to Ricoh. InterForm is a fairly young company that has a rich 30-year history of developing output management solutions for the AS/400, iSeries, System i, and now IBM i servers. The company’s recent history is |
March 22, 2011 Dan Burger
|
Any debate that compares graphical user interfaces to green-screen interfaces is usually over before it begins. It’s almost a unanimous decision. Green screens users, like four-leaf clovers, still exist, but the GUI wins by a technical knockout in 99 out of 100 cases. Last year, RPG Open Access was the new thing–a much talked about native RPG GUI. IBM i ISV Profound Logic Software was one of the first companies to put RPG OA into a product. For many RPG programmers, and companies with an investment in skilled PRG programmers, this is a big deal. New language learning curves always |
March 22, 2011 Alex Woodie
|
IBM i customers who are looking for a replacement for IBM Domino Fax for i5/OS may want to check out the FastFax migration path unveiled last week by Quadrant Software. The third-party software vendor says its FastFax for Domino i offering is a plug-and-play replacement for IBM Domino Fax for i5/OS, which IBM recently stopped selling and will stop supporting next year. Quadrant has long been a leading proponent of fax integration with IBM i applications. While its FastFax offering doesn’t run fax workloads on the IBM i platform (It offloads them to a dedicated “black box” device.), Quadrant |
March 22, 2011 Alex Woodie
|
Was 2010 the year that IBM i shops finally got religion and took security seriously? (Can pigs suddenly sprout wings and fly?) We’ll find out next week, when PowerTech releases its eighth annual “State of IBM i Security” study. Year after year, the PowerTech security study highlights the mostly dreadful state of security of IBM i systems. Like Charlie Brown repeatedly getting the football pulled out from under him, PowerTech’s annual exercise seems doomed to showcase the abject failure of many organizations when it comes to securing their IBM i-based applications and data. Every year, PowerTech dutifully reports the facts |
March 22, 2011 Alex Woodie
|
Magic Software took the plunge into free software last week when it announced uniPaaS Jet, a single-user version of its tool for developing Web applications. While Magic still supports deployment on the IBM i platform, the company is clearly looking to build name recognition among the new generation of mobile and cloud app developers with the launch of uniPaaS Jet. uniPaaS is Magic’s flagship application development tool for creating so-called rich Internet applications (RIAs), which deliver the richness of regular Windows applications but within the construct of a Web browser. The product, which debuted as G5 in 2008, uses a |
March 22, 2011 Alex Woodie
|
i365 yesterday unveiled a virtualized version of its EVault for Microsoft‘s Data Protection Manager (DPM). The new offering builds on last year’s launch of the appliance-based EVault for DPM solution and gives customers the freedom to run the EVault for DPM software on any X64-based server equipped with a hypervisor. i365 launched its EVault for Microsoft DPM solution about a year ago to give DPM customers a way to extend the disaster recovery (DR) benefits of the DPM solution to other platforms and applications, including IBM i, Linux, Solaris, HP-UX, AIX, NetWare, VMware, the Oracle‘s database, and |
