WMCPA 2013 Spring Technical Conference

February 7th, 2013

Silveredge was a sponsor and exhibitor at the 28th Annual Spring seminar sponsored by the Wisconsin Midrange Computer Professional Association (WMCPA). We enjoyed seeing so many of you at Lake Lawn Resort in Delavan, WI, March 12-14, 2013.

The WMCPA described the two-day event as the largest in the Midwest and featured more than 30 informative presentations on current topics to IBM i professionals. The bulk of the day was filled with educational sessions and hands on labs. Over 30 sessions across 2 days were conducted by industry experts and professional speakers.

WMCPA serves the Midwest business community of Wisconsin, Illinois, Indiana, Michigan, Missouri, Iowa and Minnesota.

COMMON 2013

February 7th, 2013

COMMON 2013 Annual Meeting and Exposition

Silveredge was a sponsor and exhibitor at Common’s Conference and Expo April 7-10, 2013 at the Convention Center in Austin, Texas. Ambrose Marton represented Silveredge, providing information regarding our current projects involving modernization, EDI, etc. Ambrose provided an Education Session – Skill Set Modernization or “Don’t be a Relic!”

We enjoyed seeing many of you at that great event!

You can visit the Common website at www.common.org for more information about the Common community.

Using SQL User Defined Functions for Sorts

February 6th, 2013

By using a UDF to manipulate your raw data during the SQL select process, you can;

  • retrieve associated values that require complex calculations,
  • perform data cross-referencing, and
  • manipulate data beyond the basic build in SQL functions.

Using traditional methods without the utilization of SQL/UDF, several steps are involved.  They include copying required data to a work file, running business logic to perform calculations (e.g. inventory age), then sorting and outputting the data in the desired format.

Through the use of a UDF,  the inventory age calculation can occur during the data selection process, eliminating the overhead and processing associated with using temporary files for this task.  This results in your selected data being fully ready for output into the final format desired.

Additionally, a UDF offers the same benefits and advantages of service programs and APIs.   The most important benefit is developing standard business logic external to any specific program, allowing it to be re-used instead of repetitively developed and debugged!  If you need help deploying this strategy on the IBM i, let us know!

Wisconsin Midrange User Group Spring Conference (WMCPA)

January 25th, 2012


Silveredge was a sponsor at the Wisconsin Midrange Computer Professional Association (WMCPA) 2012 Spring Technical Conference.  It was held March 21-22 at the Grand Geneva in Lake Geneva, Wisconsin.  This IBM I Conference is well attended by companies from Minnesota, the greater Chicago area, Northern Illinois, and all of Wisconsin.  It is a great venue to gain quality education sessions and meet other members and speakers from the IBM I Community at large.  It was exciting to see so many of you and meet so many NEW STUDENTS as well as IBM i Customers.


Speakers for the 2012 Spring Conference include: Aaron Bartell, Larry Bolhuis, Bob Cozzi, Mike Pavlak, Jon Paris, Susan Gantner, and Alan Seiden.  Steve Will and Pete Massiello will each be doing a Keynote.


Don’t miss out on exciting door prizes, Casino Night and more!!


The full schedule and speaker list can be found at www.wmcpa.org.


If you register with the code “Silveredge”, we get extra credit!  See you there!