Some areas of Java expertise include

• Extracting data from the iSeries into Excel
• Web application development using Struts
• Parsing XML data and updating DB2/400
• Calling native iSeries programs from Java using PCML
• JDBC access to iSeries data
• Running Open Source Apache Tomcat on the iSeries

Work samples:

Payto Inquiry Sample

Data downloaded from iSeries tables and loaded into Oracle for country wide billing clerk inquiry.

Java JSP and Struts Technology

CCB was asked to design a browser based application that would display all payees associated with any insurance carrier. Our first job was to write the Use Cases that served as the foundation of the application’s design. The Oracle tables used by the application were then defined by the client’s database group; the web pages were laid out by their HTML group. CCB’s major responsibility was to write the Struts-based application that allows access to the data.

Now, billing clerks from all over the country can view payee data in their browser, reducing data entry times and eliminating mistakes.

 

Download to Excel using Java Technology

As a web application:

We have developed a J2EE intranet web application based on Struts to access data from multiple iSeries servers and display the results in Excel. The web application runs on a Unix-based web server and requires no Microsoft components other than Excel on the desktop. User access is controlled by iSeries security and passwords are protected by SSL. The data is gathered on request by SQLRPGLE programs on the iSeries and returned to the web server where the Excel workbook is constructed. The finished workbook is streamed to the browser where the user can choose to view or save the workbook to their local drive.

As a standalone application running on the iSeries:

We have also developed a system to construct an Excel workbook containing check reconciliation information in batch on the iSeries, create an email message with names, addresses and greeting, attach the finished workbook, and transmit the completed message via the client’s SMTP server to their bank. Every day – automatically – all with Java.

Invoice API

Producing invoices utilizing Java and XML technology

WebSphere MQ Fault Tolerant Delivery

We have developed a Java/XML application that allows external systems to interface with an existing invoicing and policy system to create policies and billing transactions.

This system resides on the clients’ iSeries platform. We built an WebSphere MQ interface to receive requests sent as an XML document. This document is parsed by a Java Application Interface (API) written to take advantage of JDOM (Java Document Object Model). The parsed data is then validated by a set of pre-defined business rules. If the information received does not pass the validations, the API rejects the record and returns an error message(s). If no errors are found, policy and billing transactions are created in the invoicing and policy system and an invoice is printed. All information, whether it is invoices or errors, is returned to the sender as an XML document.

Value Added benefits to client:

• Re-engineered the external Invoicing procedures, saving client both time and effort by eliminating many manual processes
• Ability to generate Invoices without disruption to existing Invoicing and policy systems
• Software created using industry standard, platform independent languages (Java, XML)
• Provide a fault-tolerant delivery mechanism utilizing WebSphere MQ messaging
• Allows heterogeneous business units the ability to generate Invoices using existing business rules