CNX Kickstarts Development with Valence 5.1
May 24, 2017 Alex Woodie
A new release of the Valence Framework from CNX will enable IBM i shops to get more Web programming and modernization work done with even less effort than before.
Nitro’s auto-coding capabilities are once again front-and-center in Valence 5.1, which CNX launched two weeks ago at the COMMON conference in Orlando, Florida. Specifically, the enhancements land in Nitro Query, the add-on tool for building graphical Web or mobile apps that can query the DB2 for i database.
With Valence 5.1, CNX is doing its best to give Nitro Query many of the features and functions needed to use it as a replacement for green-screen maintenance applications. Employees spend a lot of time in these applications, so why should customers be the only ones to benefit from the Web and mobile fun?
Specifically, Nitro Query now gets support for edit grids with joined files. This allows users to build file maintenance applications that can access and update two or more DB2 for i files at the same time.
Nitro Query also gains support for making external RPG calls, another feature that that users of 5250 service programs take for granted, but which wasn’t previously available with Nitro Query programs.
The utility can also now use a pre-existing SQL statement as the basis for a new auto-generated Nitro Query program by importing the query from STRQRY. Users can also directly paste in SQL statements to enable instant conversion into a grid or spreadsheet.
This feature will jumpstart the creation of file maintenance apps more than any other. “This handles it for you automatically,” CNX Senior Partner Robert Swanson told IT Jungle at the COMMON show.
Richard Milone, the CTO of CNX, says the new release will make it easier for resource-strapped IBM i shops to begin generating the kinds of applications and user experiences that users demand.
“Development resources on IBM i are often stretched pretty thin just keeping daily operations humming,” Milone says in a press release. “So, Valence 5.1 Nitro Query tool addresses this problem by serving as an intuitive tool for quickly whipping out highly functional IBM i applications with a rich user interface within minutes of installation.”
Other new features in Valence 5.1 include a new pivot grid widget in Nitro Query, which will make it easier for users to visualize large data sets. Users also get more options for using images, icons, links, and texts.
The software also gains the capability to utilize Node.js for back-end business logic. Valence currently supports RPG, PHP, and Java, while its support for Node.js is limited to beta at the moment.
“With Ext JS and Valence, we’re capitalizing on the emerging convergence of devices of multiple shapes and sizes being used to interact with corporate systems,” he says.
CNX will provide the core Valence Framework as a free product for any IBM i customers under its Community Developer license (although it’s limited to five seats maximum). Additional features, such as the Nitro apps, can be activated on a per-IBM i partition basis. For more info, see www.cnxcorp.com.