IIB Java Compute Node to retrieve database information and convert it to COBOL.

Often several of my students have asked me to show a scenario on how to retrieve database records using java compute node.
Some others have asked, how to build the complete message tree from scratch in JCN.
And some others have asked how to build a COBOL result records in JCN.

I have put all three of them together to demo a simple scenario.

Pre-requisites :-

1. In my classes I have shown you, how to setup DB2 sample database. We will use the same EMPLOYEE table from that database.
2. In my database classes I have shown you how to create configurable services and ODBC/JDBC DSNs. We will use the same JDBC type 4 drivers with configurable service defined.
3. You should have the EMPLOYEE.cpy COBOL and inputmessage XML file which I have shared in the class to successfully run this example.

Steps to implement this lab :-

1. Create an Application and create a model using supplied COBOL file. You would get EMPLOYEE.xsd generated by the DFDL Message Model editor
2. The generated EMPLOYEE.xsd would look like :-
   
3. Create a simple message flow :- MQInput Node -> Java Compute Node -> MQOutput Node
4. Set MQInput properties 
1. Basic :- Give the input queue name 
2. Input Message Parsing :- XMLNSC domain
5. Set MQOutput properties 
1. Basic :- Give the output queue name
6. Set Java Compute (choose to create a message tree without copying input tree)
1. Import the following as shown in the figure :- 
   
2. Use the following two methods :- Copy Message Headers & Evaluate method  
   
   
   
   
   
7. Deploy the flow for a quick test.
8. Put the test input message with the employee number something like <EmployeeID>000010</EmployeeID>
9. See the output in COBOL format like :-

000010CHRISTINE   IHAAS        A00         3978        1995-01-01  PRES        18          F           1963-08-24  152750.00   5000.00     4220.00