Log in
 NESTU - An IBM i users group

** ALL DAY Event - SQL (Thirty Tips), Avoid the Green Screen of Death, Alternatives to Ext.Printer Files, Assertive Programming ****

  • 19 May 2011
  • 8:00 AM
  • Tiffany & Co. 141 Parsippany Road, Whippany, NJ 07981


  • NESTU Board Members Only

Registration is closed

Start Time: Reg. 8:00am


All Day Education with

Ted Holt

An Alternative to Externally Described Printer Files

No matter how much hardware and software technologies change, some things always stay the same. A prime example is the generation of columnar reports. Whereas columnar reports were once printed on green-bar paper, nowadays they show up in spreadsheets, PDF files, and web browsers. This session presents a way to write report programs that are easily modified as business requirements change. For example, if you use this method to increase the width of a column, headings and totals automatically adjust to the new detail line format.

Thirty SQL Tips in Sixty Minutes

SQL is THE data access language. It runs interactively from green screens and System i Navigator. It's in RPG and COBOL programs, in ODBC and JDBC. It's ubiquitous, and it's everywhere, too! You can't know too much about SQL. This session presents a collection of powerful, effective, and easily implemented SQL tips and techniques. These tips and techniques are based on i5/OS, but many of them apply equally to other platforms. There's something for everyone, from the SQL novice to the advanced user. Come learn some new techniques and reacquaint yourself with some you may have forgotten.

Avoid the Green Screen of Death

Ideally, users should never see the Display Program Messages panel. Similarly, batch jobs should not halt due to invalid data values. Unfortunately, many midrange programmers have never been taught how to handle errors. Happily, error handling is easy to learn and to implement. Come to this session to learn easy yet effective ways to deal with errors in RPG and CL programming.

Programming with Assertions

An assertion is a routine that checks the validity of an assumption and stops execution if it finds the assumption to be false. When used during program development and maintenance, assertions save time and effort by pointing out errors. Each problem that an assertion brings to light is a problem you don't have to search for. Assertions also work well in production; use them to cancel programs before errors can occur. Assertions have long been used in the Unix world, and now they are available in the world of i for business. Attend this session and add a powerful tool to your programming toolbox.


Powered by Wild Apricot. Try our all-in-one platform for easy membership management