Email this page to a friend

January Newsletter

Select Business Solutions


NOMAD/UltraQuest Newsletter

Brand New Video!
Take a Peak at UltraQuest Reporter 6.0

This new video gives a short overview of UltraQuest Reporter 6.0. If you've never seen Reporter before, this is a great way to see what it can do for you! Click here to watch now.


Puzzler Challenge (for fame and fortune!)

Test your knowledge or learn something new

 

Enter to win a prize

For this month's puzzler, we would like you to send in your answers. We will randomly select a winner from all correct entries received, send this talented and lucky person an UltraQuest bag/backpack, and print the winner's name and company in next month's newsletter.

This challenge is for all UltraQuest Reporter and NOMAD users, so put on your thinking caps and start typing!

 

Efficiency Puzzle

In UltraQuest and NOMAD, you can sometimes modify a SELECT (data filter) to make it more efficient, especially for accessing VSAM or NOMAD/BTREE data. Suppose you have a master (table) with a key ( ) named ACCOUNT_NUM, and you want a report which includes only account numbers 123 or 789. Then you might use the following SELECT (data filter):

(ACCOUNT_NUM eq 123) or (ACCOUNT_NUM eq 789)

What is an alternative expression to the one shown above that can make data access more efficient? Send your response by replying to this email by midnight January 31, 2015 and you may become rich and famous!


Tip of the Month

Emailing PDF files in NOMAD

Last month, we showed you an easy way to generate a PDF report using NOMAD, and promised to tell you this month how to email it. Here is a procedure to do just that:

/* generate report - see last month's newsletter */
database newcmpny BLUE;
file define textin = textin data vfile;
list by type sum(cost) on textin;
file define pdfout = my pdf vfile;
transform text to pdf;

/* define email file-id and SMTP server on VM and z/OS */
file define emailout email create length 32000 ibmvarying
alloc 'SYSOUT(x) WRITER(SMTP_server_started_task_on_z/OS)';
&smtpname = 'SMTP_server_userid_on_VM';

/* specify email with multiple parts and create first part */
email emailout
to             'This email address is being protected from spambots. You need JavaScript enabled to view it.'
from           'This email address is being protected from spambots. You need JavaScript enabled to view it.'
subject        'Report of equipment costs'
contenttype    'multipart/mixed; boundary="xyzzy"'
startboundary
contenttype    'text/plain';
write ' ' fold 'The report is attached, my liege.'
on emailout;

/* add PDF generated above as attachment to email */
email emailout
startboundary
contenttype    'application/pdf'
header         'Content-disposition'
'attachment; filename="report.pdf"'
ctransencoding 'base64';
write ' ' on emailout;
file copy pdfout emailout encode 'base64' wrap to 76;

/* send the email */
file clear emailout;

That's it! The king will receive an email like the following gmail example:

For more information on using NOMAD to send email, see Chapter 9 of the UltraQuest & NOMAD Reference Manual. In particular, Example 11 demonstrates sending worksheet, Microsoft Word, and formatted HTML attachments.

Note: the UltraQuest product from Select Business Solutions can email a PDF report with the click of a button.


z/VM 6.3 Upgrade

For z/VM sites planning to upgrade to z/VM 6.3


In z/VM 6.3, IBM made changes to the output from the CP INDICATE USER command. CP INDICATE USER is used by the NOMAD TRACE RESOURCES command as part of the UltraQuest and NOMAD Application Performance Analyzer (NAPA). z/VM NOMAD sites with NAPA enabled should contact Select Business Solutions Support and request the patch for C33533 prior to upgrading to z/VM 6.3. To request this patch, please contact support at 888-328-7806, click here to submit an electronic icur, or contact Support at This email address is being protected from spambots. You need JavaScript enabled to view it..


Social Media


Check Us Out On

 

 

We would love for you to connect with us by clicking on any of the social network links.

Click here to check out and see our postings on our Social Media page.


 


UltraQuest Demonstrations

Sign up now for an UltraQuest demo to see the new
desktop plus other new features in UltraQuest 6.0

Click here to find dates for upcoming webinars and to register.

If you want to see UltraQuest in action and the posted dates are not convenient for you, please contact Sales at This email address is being protected from spambots. You need JavaScript enabled to view it. .


Did you know???

Select Business Solutions has a team of consultants that can help you with anything from NOMAD/UltraQuest application support, configuration, efficiency improvements to systems programming and installs.

If you want know more, please email This email address is being protected from spambots. You need JavaScript enabled to view it. or call 203-383-4600 ext 6.


Product Suggestions

Select Business Solutions has always based product development and enhancements on the feedback we get from our customers. Features 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..

3 Corporate Drive, Suite 216

Shelton, CT 06484

US Phone: 1.888.472.7347

UK Phone: 44.20.3642.0532

Outside US & UK: 1.203.383.4600

 

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

 

If you do not wish to receive future emails from

Select Business Solutions, please email: This email address is being protected from spambots. You need JavaScript enabled to view it.