MC Systems Insight
MC Power Technology Manager
MC RPG Developer
MC Power Developer
MC TNT Tips 'n Techniques
MC AIX Expert
MC Linux Expert
MC Mobile on Power
This Week @ the MC Press Bookstore

October 19, 2016 | Volume 15 Issue 20


LEAD ARTICLE: The JavaScript Event Loop for IBM i Developers
FEATURED ARTICLE: SQL 101: Tools of the Trade - Old, Reliable STRSQL, Part 1
NEWS HIGHLIGHT: Kisco Announces New System Monitoring Tool for IBM i
EVENT: Work Smarter: Integrate IBM i and Desktop Applications

Sponsor - ProData Computer Services

ProDataSecurely access and share data using ProData programmer utilities!

DBU - allows access to ALL data on ALL systems using ONE interface. Use DBU to access, analyze and secure data on all your servers. DBU for RDi now available!

RDB Connect - provides direct access to remote data (like MySQL, Oracle, etc.) from all high-level languages on the IBM i.

SQL/Pro - saves time/money by reducing workloads with fast/easy informational retrieval.

Increase productivity with these easy-to-use database utilities.

Download 30 day trial NOW!>>

Visit us at the COMMON Fall Conference and Expo, Booth #1


Feature Article - Programming
The JavaScript Event Loop for IBM i Developers

Understanding the Event Loop is critical to JavaScript development both in the browser and in Node.js.

brian mayWritten by Brian May

In my day-to-day work, I switch between RPG and JavaScript development constantly. While I do not consider myself the ultimate authority on JavaScript, I do have a solid working knowledge of the language. There was a time when JavaScript was only used for browser manipulation at runtime, but with the rise of Node.js, which is now available on IBM i, JavaScript is becoming a major player for server-side development as well.


Sponsor - ASNA


Your IBM i RPG applications are the lifeblood of your business. But with old-fashioned green-screens, they are the old brown shoes of your business.

ASNA Wings puts a modern Web user interface on your RPG applications quickly and easily. Wings quickly adds power and pizzazz to your IBM i RPG portfolio. Learn how in our free October 20th, 1pm CDT Webcast.

Click here to register for the free Webcast!


Feature Article - Programming
SQL 101: Tools of the Trade - Old, Reliable STRSQL, Part 1

This article kicks off a new subseries in which I’ll discuss a few tools at your disposal to write, validate, and run SQL statements. The first of the list is the Interactive SQL, better known as STRSQL.

rafael victoria preiraWritten by Rafael Victória-Pereira

Perhaps the most used (and certainly the oldest) tool to execute SQL statements is the green-screen Start Interactive SQL Session command, STRSQL. This command is somewhat similar to the QCMD command in the sense that it provides similar function keys.


Sponsor - The MC Press Bookstore

MC Press BookstoreNow available at a special price! One of our most popular certification study guides, DB2 10 for z/OS Database Administration, prepares you for IBM Certification Exam 612 like nothing else can. This is a comprehensive review, written by two members of the test creation team, which walks you through all areas covered on the exam. You’ll get tips on working with DB2 for z/OS and new information about Version 10. Includes an 85-question practice exam complete with detailed answers.

 Save 50% off the Sale Price Enter Promo Code "BLOWOUT-5127" at Checkout

Promo Code valid 10/17/2016 from 12:01am till 10/21/16 at 11:59 pm MDT Only


MC SCBG Featured Product

TLAFormsTLAForms by TL Ashford converts your traditional IBM i spool files into high quality, professional forms.

Use a GUI Designer to create forms using data from a spool file and data from your IBM i files. Forms can be designed with true-type fonts, bar codes – including QR Code and Datamatrix, color images, overlays, lines, boxes and ellipses all in full color.

The software generates your forms as PDF documents that are archived to the IFS, automatically emailed and/or printed. Forms can be printed to IBM i PostScript printers, any printer connected to the network, or any printer connected to a PC. IFS locations, email addresses, and printers can be variable based on data within the spool file, data within the IBM i file or spool file attributes.

No programming is required to generate the new forms from your existing ERP, WMS or in-house application software.

The experienced TL Ashford technical support team will provide any pre-designed templates like the VICS Bill of Lading, and make sure working with the software is as easy and productive as possible!


In the News

Vendors:  Have a press release to share?  Send it to MC Press.

The Latest from IBM

Support MC Press - Visit Our Sponsors


Search Sponsor




Element Break

MC Press Resource Centers


White Papers

Trial Software

 120x90-WOD-MCPOct2015  SB SkyView PPL 5194-120x90  SB HelpSystems ROBOT Generic120x90
Create Amazing, Modern Apps With Profound UI What Authorities Do Programmers Really Need? Easiest Way to Save Money? Stop Printing IBM i Reports
Interested in IBM Power System White Papers, Webcasts and Software solutions? Visit our resource centers today!

Element Break

Check out these current and upcoming Bookstore Deals
Weekly Collection Sale
Monday's Blowout Book
Tuesday's 2-Day Sale
Thursday's 2-Day Sale

5154 200pxl

 See All New Books