Sun Microsystems 5.1.3 manual JcdTableSelect, Sample code from the jcdTableSelect Includes

Chapter 7	Section 7.6
Implementing the VSAM eWay Sample Projects	Building and Deploying the prjVSAM_JCD Sample Project

meet the criteria EMPID=49. The Collaboration also writes a message to

JCD_TableSelect_output0.dat to confirm when records are selected, or when no records are available.

Note: The where clause in the business rule reads the trigger value as a placeholder for input. This permits you to modify the query to select a specific record. Also note that all records are selected from the database when the TriggerTableSelect.in file is empty.

The jcdTableSelect Collaboration contains the Business Rules displayed in Figure 58.

Figure 58 jcdTableSelect

Sample code from the jcdTableSelect Includes:

package prjVSAM_JCDjcdALL;

public class jcdTableSelect

{

public com.stc.codegen.logger.Logger logger; public com.stc.codegen.alerter.Alerter alerter;

public com.stc.codegen.util.CollaborationContext collabContext; public com.stc.codegen.util.TypeConverter typeConverter;

public void receive( com.stc.connector.appconn.file.FileTextMessage input, otdVSAM.OtdVSAMOTD otdVSAM_1, dtd.otdOutputDTD_1935483687.Emp otdOutputDTD_Emp_1, com.stc.connector.appconn.file.FileApplication FileClient_1 )

throws Throwable

{

\\ Writes out a message stating records are being selected.

FileClient_1.setText( "Selecting record(s) from CICSEMP table via table select .." );

FileClient_1.write();

VSAM eWay Adapter User’s Guide 103 Sun Microsystems, Inc.