** New Product Announcement **
UltraQuest Cloud Server
Within the next couple of months Select Business Solutions will formally announce a new product to add to our already strong product suite.
By now, I am sure you have heard the buzz about The Cloud and have seen many of the articles describing the benefits of utilizing this type of architecture & technology. Select Business Solutions wants to help you move to The Cloud with UltraQuest Cloud Server.
UltraQuest Cloud Server is a solution that allows SOA applications, BI tools and report-generating products (e.g. Cognos, Business Objects & Crystal Reports) to access all the data types and sources that UltraQuest and NOMAD can access.
With the Cloud Server, you can use Cognos and other software packages to access data from NOMAD, VSAM, DB2, IMS & QSAM to name a few. End users can retrieve up-to-the-minute information with the BI tools or reporting solutions they already use.
Because of UltraQuest Cloud Server's architecture, the user no longer needs to know where the data resides. All of the setup is done behind the scenes in a controlled and secure environment.
Select will also be scheduling demonstrations of UltraQuest Cloud Server pulling data from VSAM, QSAM and SQL Server data using Cognos as the user interface.
For more information about The Cloud, there are several links to articles posted on our Social Media Page about The Cloud running on zSeries machines.
Select Business Solutions has been actively posting to our social media pages on Facebook and Twitter. We have been sharing links to interesting articles and educational posts about NOMAD/UltraQuest functions and features.
Also, we have been posting the same information to our Social Media Page on our website, click here to see our posts and to find the links to out social media pages.
NOMAD/UltraQuest ALPHA Operator Explained
UltraQuest and NOMAD have several powerful built in operators to help with screening data for reporting.
The ALPHA function checks a character expression and returns a TRUE condition if the expression contains only letters or blanks, and a FALSE condition if it contains any digits or any other characters.
Problem: You have a text field, STATE_CODE, that should only contain letters and because of data entry errors some of the records have numbers in the field. To determine which records needs to be corrected you want to create a list of records that STATE-CODE has numbers in the field.
To add a column to UltraQuest Reporter, go to the ‘Columns’ dialog, press [Add (x*y)+2] to open the Expression Column dialog, select ALPHA from the ‘Operators & Functions’ drop down choosing ‘Alpha Functions’ then scroll down and select ‘ALPHA(character-expresion)’ and press [Insert].
In the ‘Expression’ box change to the template inserted to:
IF ALPHA(STATE_CODE) THEN ‘NO’ ELSE ‘YES’
‘Column Format’ to A3
‘Heading’ to ‘BAD:RECORD’
Then go to the ‘Data Filtering’ dialog and select ‘BAD_RECORD’ and press [ Add > ] to move the column over to ‘Columns in filter’ and press [ Build Filter ]. Next set ‘Operator’ to ‘EQ’, enter ‘NO’ into the text box and press [ Continue ]
DEFINE BAD_RECORD AS 3 = IF ALPHA(STATE_CODE) THEN ‘NO’ ELSE ‘YES’;
SELECT ADD BAD_RECORD EQ ‘YES’;
Now when you run the request it will only contain the following accounts:
Please feel to contact UltraQuest and NOMAD support if you have any additional questions about the ALPHA function.
More information about the ALPHA function may be found in the "Functions and Operators" section of Chapter 5 of the UltraQuest and NOMAD Reference Manual.
Word Hunt Puzzle
See if you can find the words in the following puzzle. All of the words are Select Business Solutions Products, Product Features or Data Sources
For a printable version click here.
Featuring the Latest Release, Version 5.5
UltraQuest is still the only web based reporting solution that allows customers to create reports and files directly from the application files, providing access to every field, and giving you up to the minute access. With UltraQuest there is no need to move the data to a different platform, invest in additional hardware or deal with multiple vendors. UltraQuest runs on the mainframe, therefore it can handle large amounts of data and users, providing centralized control and easy backup recovery procedures.
Select Business Solutions' UltraQuest software is utilized by hospitals, banks, insurance companies, manufacturing, federal & local government agencies and schools. UltraQuest is used to do customized ad-hoc reporting, building dashboards/scorecards, ETL Tool, delimited files and can also produce production type reports and batch processing.
Sign up now for an UltraQuest demo and see the new Reporter desktop plus other new facilities in version 5.5!
With UltraQuest You Can:
- directly access to VSAM, QSAM, DB2, IMS, IDMS, NOMAD, Oracle and SQL Server
- easily create dashboards/scorecards, reports and files
- allow end users to create and/or execute reports themselves
- reduce the workload on your IT Department
- schedule reports using UltraQuest scheduling facilities
- report from the transaction files to do research
- join applications together for marketing analysis and quality assurance of the data
- replace applications such at EasyTrieve, Focus, RAMIS and other costly products
- reduce the time to complete any mergers or conversions
- take advantage of our flexible licensing and payment options to fit any budget
The scheduled dates for the next UltraQuest Webinars are:
- September 28, 2011 @ 3:00 pm ET
- October 26, 2011 @ 3:00 pm ET
- November 23, 2011 @ 3:00 pm ET
Click here to register.
We Want To Hear From You!
35 Nutmeg Drive
Trumbull, CT 06611