• Control the Library List from a SQL Server Linked Server Definition

  July 23, 2008 Hey, Mike

  We are having more and more users call AS/400 jobs from a SQL Server session on their PCs, and we have trouble giving them the proper library list. Usually, just giving them the libraries in QUSRLIBL works fine. Is there a way to make sure every user, regardless of originating machine or system, gets the library list values of QUSRLIBL? –Barry Barry, I’m guessing that you’re using the SQL Server’s linked server facility to connect to the AS/400. If so, the first thing you need to do is check the linked server’s data provider. SQL Server will use either an

  …

  Read more

• Print Part of an IFS File

  July 23, 2008 Hey, Ted

  Let’s say I have an IFS file with several thousand lines in it. Let’s say I want to print a few lines of that file. My current method is to copy the IFS file to another file, use Edit File (EDTF) with the copy to delete the lines I don’t want, and use EDTF’s Print command to get the report. Please tell me there’s an easier way. –Bob I recommend two Qshell commands. Sed, the stream editor, can select the lines you want to print. The Rfile utility can send them to a printer. Now, how do you want

  …

  Read more

• Using LTO 3 Tapes In an LTO 2 Drive

  July 23, 2008 Hey, Joe

  Do you know if we’ll be able to read tapes created from a new Linear Tape Open Ultrium drive (400 GB native format) on our old Ultrium LTO 2 drives? We want to take tapes from a scientific vessel at sea that may purchase the LTO 3 drive and read the tapes back in the office on our LTO 2 drive. –Anne When comparing LTO 2 and LTO 3 tape drives, the rule is that an LTO drive can usually read tapes that were created at a lower tape drive level, but not tapes that were created at a higher

  …

  Read more

• CNX Aims to Streamline Web 2.0 Development for i OS with Valence

  July 22, 2008 Alex Woodie

  CNX has released a new development tool that’s aimed at making it easy for RPG developers to create Web 2.0 style interfaces. The new toolset, called Valence, is based on the collection of JavaScript classes called EXTJS, and uses JavaScript’s native data-formatting language, JSON. According to CNX executives, Valence delivers a native and extremely fast connections between Web browsers and back-end RPG applications running on the i-based Power Systems server. The Valence story starts in 2001, when the folks at Chicago-based CNX started looking for a tool to Web-enable their add-on planning system for BPCS called ATOMIC, according to Richard

  …

  Read more

• Resolution Moves Database Automation Forward

  July 22, 2008 Dan Burger

  The IBM Power System i users tend to be a volatile mix of old and new. Examples are many, but on this occasion the spotlight is on creating, populating, and manipulating databases. Dating back to the System 38, databases on this platform were created using DDS (data description specification). Outside this universe, other relational database management systems (RDMS) use structured query language (SQL) to define the database. Some System i shops have been converting to SQL, but there have been obstacles. Those obstacles exist despite IBM’s efforts to enhance DB2 UDB for iSeries and convince users that SQL offers more

  …

  Read more

• IBM Delivers ID Management as a Service with Tivoli FIM

  July 22, 2008 Alex Woodie

  IBM recently delivered a new product called Tivoli Federated Identity Manager, or FIM, that acts as an identity and authentication hub for the multitude of platforms and authentication methods used in the field, including WS-Trust, SAML, Kerberos, and RAC-F. What’s more, because Tivoli FIM can be called as a Web service, the software is ideal for use in new service oriented architectures (SOAs) and Web 2.0 applications, including those running on i. While SOAs bring many benefits to developers, such as re-use of code and simplified application integration, user access security is not an area that necessarily benefits from SOA.

  …

  Read more

• Micro Focus Moves NetManage Acquisition Forward

  July 22, 2008 Alex Woodie

  Now that the dust has settled following Micro Focus International‘s sudden acquisition of NetManage this spring, teams with the two software companies have had a chance to evaluate their respective products and develop a roadmap for how the products will evolve in the midterm. Meanwhile, the acquisition has reshaped the former NetManage company, with some developers getting re-assigned, other workers being let go, and the closing of NetManage’s former headquarters in Silicon Valley. In early May, Micro Focus surprised the midrange when it announced plans to buy NetManage for $73.3 million. In rationalizing the acquisition, Micro Focus CEO

  …

  Read more

• ARCAD Opens New Office in Singapore

  July 22, 2008 Alex Woodie

  ARCAD Software, aka “The Kilt People,” last week announced the opening of a new office in Singapore to serve the growing demand for its software in the Asia Pacific region. The new office is the latest indication of how the French company, which sells application lifecycle management tools (ALM), has been moving to expand the company and its sales. ARCAD develops a collection of ALM tools and assorted programmer utilities aimed at making life easier for System i application developers. Recently, the company has moved aggressively to fill the void for change management tools left when one of that

  …

  Read more

• Agilysys Sells Hospitality Suite to New Laotian Casino

  July 22, 2008 Alex Woodie

  Agilysys may be looking to sell its entire company, but that’s not stopping it from selling its suite of popular i OS-based hospitality solutions, which are used by much of the Vegas Strip and many of the largest hotels in the world. The latest company to license the collection is Savan Vegas Hotel & Casino, a new 180-room luxury property in Savannakhet, Laos. When the Savan Vegas opens in September, it will be the first five-star hotel and entertainment complex in Savannakhet Province, a region in southern Laos that borders Vietnam and Thailand, and which is perhaps best known for

  …

  Read more

• English Manufacturer Extends ERP for Chinese Expansion

  July 22, 2008 Alex Woodie

  For the folks at Speedy Products, the U.K.-based manufacturer of advanced “window furnishings technology” (i.e. decorative poles, curtain tracks, tiebacks, and holdbacks), extending their i-based IBS ERP software implementation to their newly acquired Chinese factory and distribution center was as easy as opening a curtain. Last week, Sweden-based IBS announced that Speedy Products will expand its U.K. implementation of the IBS ERP system, called Enterprise, to support its newly acquired Paloma Decorative Products division in China. Paloma operates a factory and a warehouse in Suzhou and Shanghai, and both locations will be hooked in, via VPN, to the new i-based

  …

  Read more

Previous Articles Next Articles