Record formats - Connect_ETL - 9.13

Connect ETL DMXMFJCL User Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect (ETL, Sort, AppMod, Big Data)
Version
9.13
Language
English
Product name
Connect ETL
Title
Connect ETL DMXMFJCL User Guide
Copyright
2023
First publish date
2003
Last updated
2023-09-11
Published on
2023-09-11T19:02:58.140000

Although there are many DSORGs and RECFMs in Micro Focus Server, the data is stored using relatively few file formats. Connect ETL supports most of these file formats natively, so you can use DMXMFJCL with almost any type of data set. The common DSORGs and RECFMs are summarized in the table below.

DSORG RECFM Connect ETL File Type
 

F

FB

Fixed record length
 

FA

FBA

FBM

FM

Fixed record length1
 

V

VB

Micro Focus sequential with variable record length2,3
 

VA

VBA

VBM

VM

Micro Focus sequential with variable record length1,2
  LSEQ Micro Focus line sequential
VSAM * Indexed4
1The “A” or “M” indicate that the records contain control characters that are used for printing. You will need to remove one byte from the beginning of your record layout to accommodate this.

2Variable files include a record descriptor word that is considered part of the data on the mainframe. You will need to remove four bytes from the beginning of your record layout to accommodate this.

3The DMExpress Task Editor does not currently allow you to specify an encoding for Micro Focus files. When using variable files in the same task with fixed files, do not specify encoding for the fixed file(s).

4DMExpress cannot create indexed files, so VSAM data sets cannot be used as output for DMXMFJCL.