MC Press Online

Sunday, Jun 25th

Last updateFri, 23 Jun 2017 1pm

You are here: Home PUBLICATIONS MC TNT Tips 'n Techniques April 14, 2017

MC TNT Header 2


Lead Article - Programming

TechTip: Node.js JoinJS

SQL result sets are flat for joins. That makes it more complex to process both in business logic and UI. JoinJS to the rescue!

Written by Aaron Bartell

I am currently coding a Node.js project for a customer that uses the HapiJS web framework. We had the need to create a JSON result object from DB2 that conveyed a list of employees and their department associations and send it to the browser. In short, the SQL result set looked like the below.

T. L. Ashford

Barcode400 Labeling Software for the IBM i

All Data and Software Resides on the IBM i: Everything is centralized and secure.
Graphical Designer: Design labels in minutes.
Integrate and Print with Existing Apps: Call from RPG, COBOL, CLP and JAVA programs.
Compliance Labels Provided: Extensive library of predesigned label templates.
Supply Chain Solution: Easily integrated into any IBM i ERP or WMS solution.

Learn about new Features here, or watch a quick video on 4.0 features here. Download a 30-day trial here!

TL Ashford - Since 1983

MC Press Bookstore

Introducing the complete guide to building business Web applications! Now programmers of all levels can learn to build Web apps that do real business work. Written by business developers for business developers, Developing Business Applications for the Web bridges the gap between website and business application programming. You'll master the fundamentals of Web development tools and gain all the necessary skills to build Web browser front-end applications that let users interact with business data.

Order your copy today!

MC Press Bookstore

Confused About Identity Management? Get expert help in this latest release from MC Press. Author Graham Williamson explains identity management for business people. Business managers and CIOs will learn how to manage today's identity challenges relating to access control, the cloud, consumers, data security, and the Internet of Things. If you are tasked with fitting identity management into your business strategy, then Identity Management: A Business Perspective is the perfect guide for you!

Order your copy today!

Feature Article - Analytics & Cognitive

TechTip: Watson Products

A couple of articles ago, we looked at what an API was and even what Watson was, but we didn’t get into an example of the kinds of stuff Watson is mixed up in. Stand by to be amazed. 

Written by Dave Shirey   

In a previous TechTip, we started to get into what the new world of APIs allows us to do (interface complex applications, not just point functions, with your custom applications) and what Watson really is (a set of very fast processors running with a parallel architecture, DeepQA, to provide a new way to approach the question-and-answer application). But we didn’t talk about how you can get involved with that world.

MC Resource Centers

Business Intelligence for the SMB's Budget

Think only large organizations can afford and implement business intelligence (BI)? Think again.

Today, BI isn’t just for the big guys. Small-to-medium businesses (SMBs) can (and, indeed, do) deploy BI tools—and it doesn’t cost them a fortune. Here’s why: they choose a BI tool that’s the right size for their business. They gain the clear, actionable information they need to make sound business decisions. And, since the BI tool is scaled—in size and cost—to their needs, they achieve fast ROI.
Need help finding the right BI for your SMB? Start here.
You'll learn the must-haves for BI on IBM i at SMBs:

  • Get BI without missing a beat by importing existing queries
  • Give your SMB the ability to make better decisions
  • Increase productivity with real-time data access
  • Achieve fast ROI

Plus, you’ll see a demonstration of how Sequel Data Access makes BI for SMBs easy. Quick installation, simple setup, and easy data access mean you can start pulling reports from your IBM i within an hour.
Ready to help your SMB move faster and get more done? Watch the webinar today!

Watch Now!

MC Video Showcase