MAGAZINES

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

May 2, 2012 | Volume 11 Issue 9

ISSUE HIGHLIGHTS

TOP STORY: Practical SQL: Defining Your Data: TEXT and LABEL
FEATURED ARTICLE: RPG IV and a New Approach to Control-Break Processing
NEWS HIGHLIGHT: IBM Introduces New Foundation for Mobile Computing
ON-DEMAND WEBCAST: Beyond FTP, Securing and Automating File Transfers
EVENT: LANSA: Empowering Your Enterprise Systems Management Team
Manage Subscription | Contact Us

Sponsor - T.L. Ashford & Associates
 
Barcode400 Labeling Software makes it easy for IBM i users to design and print labels in minutes.

T.L. Ashford has over 28 years of experience in software development and backs that commitment with a highly qualified technical support team.

You can count on T.L. Ashford for your bar code, compliance and RFID labeling needs. Call 800-541-4893 to see what Barcode400 Software can do for you or use the Live Chat feature at www.tlashford.com


Read More >>

Feature Article - Programming
 
Practical SQL: Defining Your Data: TEXT and LABEL

Using DDL to define your data has a lot of benefits, but you still need to know a few tricks to get all of the features we enjoy in DDS. Read on for the secrets!

joe_plutaWritten by Joe Pluta

Today's article is my first dedicated to Data Definition Language (DDL), the specific SQL syntax used to define tables. It's counterpart in the green-screen world is Data Descriptions Specifications (DDS), the simple data definition language we've used forever.


Read More >>

Sponsor - CNX Corporation
 

Dazzle your IBM i users!

Valence combines state-of-the-art browser components with your favorite business language (RPG) to produce

World Class Web 2.0 apps on IBM i.

Learn industry-standard techniques for developing true Web 2.0 applications with popular UI features such as grids, forms, trees, charts, graphs and much, much more!

 

Just released: Valence 3.1 – includes the all-new Nitro App Builder for creating browser-based dashboard & query apps with no programming, and the Nitro File Editor for viewing & editing your IBM i database files. Download the Valence 3.1 Community Developer Edition for free!

 


Read More >>

Feature Article - Programming
 
RPG IV and a New Approach to Control-Break Processing

Essentially, what's old is new again!

jim_martinWritten by Jim Martin

Those of us who used the RPG cycle and L1, L2, etc. for control-break processing remember how slick it was. Very few lines of code were needed, since most of the work was being done by the cycle code. As we proceeded into full procedural programming, we became aware that more code was needed to get the same result. Typically, we now needed save fields of control-break key fields, code to load the save fields, logic to see if the control-break key fields in the file changed from the save fields, and then more logic to handle the last group. Also, the save data needed to be updated in our control-break routine. This is pretty standard stuff that has been around for a long time.


Read More >>

Sponsor - The MC Press Bookstore
 
Over 45 eBook Titles to Choose From! Instantly download eBooks on RPG, PHP, SQL, and a wide variety of other IBM Power Systems and information technology topics. Our eBooks are fully searchable, printable, and can be resized for easy readability. And, you can cut-and-paste code directly from the book into your applications. Plus, PDF editions are discounted an ADDITIONAL 15% off of the lowest hard copy price! Click now to see them all. >>
Read More >>

MC Webcast Center
 

FEATURED WEBCAST

Beyond FTP, Securing and Automating File Transfers

Standard FTP is an outdated protocol with serious security issues that can expose your sensitive data, user ids and passwords. Many organizations are rapidly moving away from standard FTP in order to meet privacy policies and compliance requirements like PCI DSS, SOX and HIPAA.

Join us in this free webinar and learn about secure alternatives to FTP that will protect your data transfers with strong encryption and modern authentication methods.

We'll also give you a quick tour of our GoAnywhere Director managed file transfer solution, with its simple intuitive interface that allows you to quickly set up and automate secure file transfers without the need for scripts or programming.

 

Download this important webinar today!

 

(USA and CANADA only!)

 

Be sure to check out these other useful offerings in the MC Webcast Center.

 

 

The MC Webcast, MC White Paper, MC Software, MC Case Study, MC Security, and MC Disaster Recovery Centers bring you the widest selection of IBM Power Systems white papers, software, webcasts and more. And just like on demand TV our partner solutions are waiting and ready to be delivered when you want, where you want. All you have to do is visit and start choosing from dozens upon dozens of offerings and we’ll send them right to you. We’re even giving away not one but THREE Apple TV’s to three very lucky people. Visit the MC Resource Centers today and select as many of the FREE offerings you would like. While there, enter the contest and you may just an Apple TV unit of your very own!

 

Have a On-Demand Webcast you would like to list? click here or call (208) 726-6822 for information.

&n


Read More >>

In the News

Read More >>
Support MC Press - Visit Our Sponsors

Forums Sponsor

POPULAR FORUMS

Forums

Search Sponsor

Search


Read More >>
   MC-STORE.COM