Email this page to a friend

September 2011 Newsletter

Select Business Solutions

 Select Business Solutions


NOMAD & UltraQuest Newsletter


September 2011

Newsletter

Contents


New Product


Social Media


How To:


Word Hunt


UltraQuest Webinars


Product Suggestions


Contact Information

** 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.

To learn more please contact your Account Manager or myself at This email address is being protected from spambots. You need JavaScript enabled to view it. or 972-899-5221.


Social Media

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.


How To...

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.

SAMPLE RECORDS

ACCOUNT STATE_CODE
1 AR
2 NY
3 C4
4 TX
5 G0
6 FL

UltraQuest Reporter:

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:
ALPHA(character-expresion)

IF ALPHA(STATE_CODE) THEN ‘NO’ ELSE ‘YES’

Set:
‘Column Format’ to A3
‘Heading’ to ‘BAD:RECORD’
Check ‘Define’
‘Name’ ‘BAD_RECORD’

Press [Continue]

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 ]

NOMAD:

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:

ACCOUNT STATE_CODE BAD_RECORD
3 C4 YES
5 G0 YES

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.

Wordhunt Puzzle

NOMAD
ULTRAQUEST
TRANSIT ETL
REPORTERS
NAVIGATORS
VSAM
QSAM
ORACLE

SQL SERVER
IMS
IDMS
WEB SERVICES
XML
DELIMITED
EMAIL
PDF

OUTPUT
FIXED FORMAT
DATABASE
QUERY
DATAMART
CLOUD SERVER
ZSERIES
MAINFRAME


UltraQuest Demonstrations

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.

If you want to see UltraQuest in action and these dates aren't convenient for you, please contact Dennis Street at This email address is being protected from spambots. You need JavaScript enabled to view it. or call 972-899-5221 to schedule a time.



Product Suggestions

We Want To Hear From You!

Select Business Solutions has always based product development and enhancements on the feedback we get from our customers.  Recent additions like the interfaces to Oracle and SQL Server and the UltraQuest Scheduler were based directly on requests from our customer base.  We pride ourselves on being responsive to our customers’ needs and the changing IT environment, and we want to hear from you.  If there is a product feature you would like to see added, or if you have any suggestions on how to make our products better please email them to us at This email address is being protected from spambots. You need JavaScript enabled to view it.


Contact Us

Select Business Solutions

35 Nutmeg Drive

Trumbull, CT  06611

Phone: 1-888-472-7347

Email: This email address is being protected from spambots. You need JavaScript enabled to view it.

If you do not wish to receive future e-mails from Select Business Solutions, please email: This email address is being protected from spambots. You need JavaScript enabled to view it.