Record Description: Trial Mode Execution - mfx - 3.1

Syncsort™ MFX Programmers Guide

Product type
Software
Portfolio
Integrate
Product family
Syncsort™ Software
Product
Syncsort™ MFX > MFX
Version
3.1
Language
English
Content type
Programmer’s Guide
Product name
Syncsort™ MFX
Title
Syncsort™ MFX Programmers Guide
Topic type
How Do I
Copyright
2024
First publish date
2010
Last edition
2024-08-27
Last publish date
2024-08-27T08:14:56.318001
When first developing an application, knowledge of the actual input record layout built from the query is required. This can be obtained from a trial mode execution. The trial mode execution uses a query provided in the SORTDBIN data set to generate a report of the input record layout in the MFX message data set (SYSOUT). The trial mode execution does not perform any other processing or request data from DB2. To request trial mode execution, modify the SQL SELECT keyword in the SORTDBIN data set to $ELECT. This indicates a trial mode execution is to be performed. For trial mode, execute MFX with JCL of the following form:
Figure 1. Sample JCL for Trial Mode Execution

Note that only the SYSOUT and SORTDBIN DD are required for a trial mode execution. An actual execution of the application will require other DDs as documented for SORT or COPY applications.

The STEPLIB DD statement specifies where the MFX and DB2 products can be found. The STEPLIB DD statement would be needed if these products could not be found in the standard system libraries.

The DB2 EXEC statement parameter would be set to the DB2 subsystem name to be accessed.

The SYSOUT data set will contain an input record layout report as shown in the following sample:

Figure 2. Sample SYSOUT

You would create MFX control statements with field specifications based on the input record layout and place the control statements in the data set specified by the SYSIN DD statement. You would then create a set of JCL statements for the application.