Archive for February, 2013

WMCPA 2013 Spring Technical Conference

Thursday, 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

Thursday, 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

Wednesday, 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!

Silveredge Holiday Party 2012

Wednesday, February 6th, 2013

The Whole Gang

Our Holiday Party at the Bulls!  We had a great time!