Search Our Site

Knowledge Base: Solutions

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 is currently helping clients upgrade EDI mappings from version 4010 to 5010. By January 1, 2012, all large health care organizations are required to be compliant with version 5010 of the transaction sets to support HIPAA (Health Insurance Portability and Accountability Act ) and ICD-10 (International Classification of Diseases, Tenth Revision) code set changes. Unlike previous version upgrades, the enhancements for 5010 are significant. Specific documents include: 276/277 Health Care Claim Status Request/Response, 837 Health Care Claim, 270/271 Eligibility Inquiry/Response, and 835 Health Care Payment/Advice.

Version 5010 will bring greater automation and interoperability among health care providers, hospitals, pharmacies, and payers. Organizations can leverage these EDI changes in combination with HIPAA and ICD-10 enhancements in their internal systems to reduce administrative costs.

WordPress, according to Wikipedia, is an “open source blog publishing application powered by PHP and MySQL… It has many features including a plugin architecture and a templating system. Used by over 2% of the 10,000 biggest websites, WordPress is the most popular blog software in use today.”

Our Director of Technology used WordPress to manage our web blog, which is running on our IBM i. WordPress and IBM i. You can do it!

Silveredge has recently implemented a full warehouse automation solution custom designed by the client utilizing LANSA as the development tool. The wireless devices display html pages, which are easily understood by the warehouse staff. The pages are directly generated by the IBM i, without the need for additional hardware. The client utilizes this method for picking, receiving, shipping, and cycle counting. While this solution interfaced with the HFA ERP solution, the approach is universal.