Data File Editor

A SimoPATH Task

Using Structure Files

http://www.simotime.com

Version 06.01.23

	Step 1, Specifying the Data File Directory
	Step 2, Specifying the Data File Type
	Step 3, Specifying the Data File Name
	Step 4, Add the File to Project

Using the Data File Editor

	Step 1, Viewing a List of Records
	Step 2, Viewing Hexadecimal Values & EBCDIC Data from Net Express
	Step 3, Preparing to Load a Structure File
	Step 4, Loading a Structure File
	Step 5, Viewing a Record Mapped to a Structure File

Summary

	Software Agreement and Disclaimer
	Downloads and Links to Similar Pages
	Glossary of Terms
	Comments or Suggestions
	About SimoTime

Introduction
(Next) (Previous) (Table-of-Contents)

This document describes how to use the Micro Focus Data File Editor to view the contents of a file. The following features and functions will be discussed.

1.	How to start the Data File Editor from within a Micro Focus Net Express project.
2.	How to view an ASCII or EBCDIC encoded file.
3.	How to view a list of the records in the file.
4.	How to view a record in the file using the hexadecimal dump format
5.	How to view a record in the file and map the record to a record layout that was initially defined in a COBOL copy file or other COBOL source member.

Note: This module is part of The SimoPATH Series of training and reference materials. For more information refer to The Home Page for The SimoPATH Series.

Adding a Data File to a Project
(Next) (Previous) (Table-of-Contents)

The following describes the steps to add a data file to a Net Express project and then view the file using the Micro Focus Data File Editor.

From the Net Express desktop (IDE) do the following.

1	From the left window pane do a right-click on the mouse button (position the mouse-pointer to any white area in the left pane).
2	From the drop-down list select "Add files to project...".

Step 1, Add a File, Specifying the Data File Directory
(Next) (Previous) (Table-of-Contents)

The following window should be displayed.

1.1	From the "Look in:" box use the down-arrow to select the "C:\DataMig1\DataEbc1" directory. Notice the "Recent folders:" box is refreshed as you select the drive and directories from the "Look in:" box.
1.2	Notice the Directory now appears in the "Recent folders:" box.

Step 2, Add a File, Specifying the Data File Type
(Next) (Previous) (Table-of-Contents)

After selecting the directory where the file resides it will be necessary to select the proper file from the directory. Since the data files have an extension of ".DAT" perform the following from the same screen.

2.1	Select the "Files of type:" box and use the down-arrow to to display a drop-down list.
2.2	Scroll to the bottom of the drop-down list using the vertical scroll bar.
2.3	Select the "*All Files (.)*" option.

Step 3, Add a File, Specifying the Data File Name
(Next) (Previous) (Table-of-Contents)

After selecting all file types it will be necessary to select the specific file.

3.1	Click on the "ITEMEBC1.DAT" to select the Item Master File. After the file is selected the file name should appear in the "File name: " box. Note; Make sure to select the ".DAT" and not the ".IDX" file.
3.2	Click on the "Add" button.

Step 4, Add a File, Add the File to the Project
(Next) (Previous) (Table-of-Contents)

The following screen should be displayed.

4.1	Check the "No to all" box
4.2	Click on the "No" button.

Using the Data File Editor
(Next) (Previous) (Table-of-Contents)

The Net Express Desktop (IDE) Window should be displayed.

1.	The ITEMEBC1.DAT should be shown in both the left and right window panes. Double-click on either item and the Micro Focus Data File Editor should display a list of the first few records in the file.

The following screen should be displayed.

Step 1, Using File Editor, Viewing a List of Records
(Next) (Previous) (Table-of-Contents)

The following screen should be displayed.

1.	Use the mouse to select the first record and click on the right mouse button to show the preceding drop down list.
2.	Select the "Show Hex" option.

Step 2, Using File Editor, Viewing Hex Values & EBCDIC Data
(Next) (Previous) (Table-of-Contents)

The following screen should be displayed.

The following window with hexadecimal data should be displayed.

1.	By examining the hexadecimal display it is easy to determine the file is EBCDIC-encoded.
2.	Using the mouse click on the down arrow as shown in the preceding screen display. A drop-down list should be displayed. Select the EBCDIC option.

After selecting the EBCDIC option the list of records should now be displayed in a readable format.

Step 3, Using File Editor, Preparing to Load a Structure File
(Next) (Previous) (Table-of-Contents)

Prepare to load the structure file as shown on the following screen.

1.	From the Net Express tool bar select the "File" option.
2.	From the drop-down list select the "Data Tools" option.
3.	From the context menu select the "Load Record Layouts..." option.

Step 4, Using File Editor, Loading a Structure File
(Next) (Previous) (Table-of-Contents)

The following screen should be displayed.

1.	If a list of structure file (.STR) is not displayed use "Look in:" box to select the c:\DataMig1\STR directory as displayed in the "Recent folders:" box. Once the directory is selected the list of files should be displayed.
2.	Using the mouse, double- click on the "ITEMMAST.STR" file.

Step 5, Using File Editor, Viewing a Record Mapped to a Structure File
(Next) (Previous) (Table-of-Contents)

The following screen should be displayed.

1.	Notice the "List of Records" is displayed in the left pane..
2.	The selected record (highlighted in the left pane) is displayed in the right pane and is mapped to the structure file.
3.	By positioning the mouse pointer over the vertical line that separates the left and right panes the window pane sizes may be adjusted by dragging the vertical line to the left or right.

Note: Refer to the Create a Structure File document for more information. .

Summary
(Next) (Previous) (Table-of-Contents)

The purpose of this document is to show how to add a data file to a Net Express project and then view the file using the Micro Focus Data File Editor.

Software Agreement and Disclaimer
(Next) (Previous) (Table-of-Contents)

Permission to use, copy, modify and distribute this software, documentation or training material for any purpose requires a fee to be paid to SimoTime Enterprises. Once the fee is received by SimoTime the latest version of the software, documentation or training material will be delivered and a license will be granted for use within an enterprise, provided the SimoTime copyright notice appear on all copies of the software. The SimoTime name or Logo may not be used in any advertising or publicity pertaining to the use of the software without the written permission of SimoTime Enterprises.

SimoTime Enterprises makes no warranty or representations about the suitability of the software, documentation or learning material for any purpose. It is provided "AS IS" without any express or implied warranty, including the implied warranties of merchantability, fitness for a particular purpose and non-infringement. SimoTime Enterprises shall not be liable for any direct, indirect, special or consequential damages resulting from the loss of use, data or projects, whether in an action of contract or tort, arising out of or in connection with the use or performance of this software, documentation or training material.

Downloads and Links to Similar Pages
(Next) (Previous) (Table-of-Contents)

The Home Page for The SimoPATH Series is the starting point to view information about training sessions and learning materials available from SimoTime Enterprises.

The SimoZAPS Utility Program has the capability of generating a COBOL program that will do the conversion of sequential and VSAM (KSDS) files between EBCDIC and ASCII. SimoZAPS can also read a sequential file in EBCDIC format and create an ASCII/CRLF file or VSAM KSDS file in ASCII format. The conversion tables may be viewed or modified to meet unique requirements. The Hexcess/2 function provides the capability of viewing, finding or patching the contents of a file in hexadecimal.

The SimoREC1 Utility Program has the capability of generating a callable COBOL program that will do the conversion of a data string between EBCDIC and ASCII. The generated COBOL source code or the conversion tables may be viewed or modified to meet unique requirements. The generated program may be called by an I/O program generated by SimoZAPS.

This item will provide a link to an ASCII or EBCDIC translation table. A column for decimal, hexadecimal and binary is also included.

Check out The VSAM - QSAM Connection for more examples of mainframe VSAM and QSAM accessing techniques and sample code.

This document provides a quick summary of the File Status Key for VSAM data sets and QSAM files.

Check out The SimoTime Library for a wide range of topics for Programmers, Project Managers and Software Developers.

To review all the information available on this site start at The SimoTime Home Page .

Glossary of Terms
(Next) (Previous) (Table-of-Contents)

Check out The SimoTime Glossary for a list of terms and definitions used in the documents provided by SimoTime.

Comments or Suggestions
(Next) (Previous) (Table-of-Contents)

If you have any questions, suggestions or comments please call or send an e-mail to: helpdesk@simotime.com

We appreciate your comments and feedback.

About SimoTime Enterprises, LLC
(Next) (Previous) (Table-of-Contents)

Founded in 1987, SimoTime Enterprises is a privately owned, Limited Liability Corporation located in Novato, California. We specialize in the creation and deployment of business applications using new or existing technologies and services. We have a team of individuals that understand the broad range of technologies being used in today's environments. This includes the smallest thin client using the Internet and the very large mainframe systems. There is more to making the Internet work for your company's business than just having a nice looking WEB site. It is about combining the latest technologies and existing technologies with practical business experience. It's about the business of doing business and looking good in the process. Quite often, to reach larger markets or provide a higher level of service to existing customers it requires the newer Internet technologies to work in a complementary manner with existing corporate mainframe systems. Whether you want to use the Internet to expand into new market segments or as a delivery vehicle for existing business functions simply give us a call or check the web site at http://www.simotime.com

Return-to-Top

When technology complements business

http://www.simotime.com

Version 06.01.05

Introduction(Next) (Previous) (Table-of-Contents)

Adding a Data File to a Project(Next) (Previous) (Table-of-Contents)

Step 1, Add a File, Specifying the Data File Directory(Next) (Previous) (Table-of-Contents)

Step 2, Add a File, Specifying the Data File Type(Next) (Previous) (Table-of-Contents)

Step 3, Add a File, Specifying the Data File Name(Next) (Previous) (Table-of-Contents)

Step 4, Add a File, Add the File to the Project(Next) (Previous) (Table-of-Contents)

Using the Data File Editor(Next) (Previous) (Table-of-Contents)

Step 1, Using File Editor, Viewing a List of Records(Next) (Previous) (Table-of-Contents)

Step 2, Using File Editor, Viewing Hex Values & EBCDIC Data (Next) (Previous) (Table-of-Contents)

Step 3, Using File Editor, Preparing to Load a Structure File (Next) (Previous) (Table-of-Contents)

Step 4, Using File Editor, Loading a Structure File (Next) (Previous) (Table-of-Contents)

Step 5, Using File Editor, Viewing a Record Mapped to a Structure File (Next) (Previous) (Table-of-Contents)

Summary(Next) (Previous) (Table-of-Contents)

Software Agreement and Disclaimer(Next) (Previous) (Table-of-Contents)

Downloads and Links to Similar Pages(Next) (Previous) (Table-of-Contents)

Glossary of Terms (Next) (Previous) (Table-of-Contents)

Comments or Suggestions(Next) (Previous) (Table-of-Contents)

About SimoTime Enterprises, LLC(Next) (Previous) (Table-of-Contents)

Introduction
(Next) (Previous) (Table-of-Contents)

Adding a Data File to a Project
(Next) (Previous) (Table-of-Contents)

Step 1, Add a File, Specifying the Data File Directory
(Next) (Previous) (Table-of-Contents)

Step 2, Add a File, Specifying the Data File Type
(Next) (Previous) (Table-of-Contents)

Step 3, Add a File, Specifying the Data File Name
(Next) (Previous) (Table-of-Contents)

Step 4, Add a File, Add the File to the Project
(Next) (Previous) (Table-of-Contents)

Using the Data File Editor
(Next) (Previous) (Table-of-Contents)

Step 1, Using File Editor, Viewing a List of Records
(Next) (Previous) (Table-of-Contents)

Step 2, Using File Editor, Viewing Hex Values & EBCDIC Data
(Next) (Previous) (Table-of-Contents)

Step 3, Using File Editor, Preparing to Load a Structure File
(Next) (Previous) (Table-of-Contents)

Step 4, Using File Editor, Loading a Structure File
(Next) (Previous) (Table-of-Contents)

Step 5, Using File Editor, Viewing a Record Mapped to a Structure File
(Next) (Previous) (Table-of-Contents)

Summary
(Next) (Previous) (Table-of-Contents)

Software Agreement and Disclaimer
(Next) (Previous) (Table-of-Contents)

Downloads and Links to Similar Pages
(Next) (Previous) (Table-of-Contents)

Glossary of Terms
(Next) (Previous) (Table-of-Contents)

Comments or Suggestions
(Next) (Previous) (Table-of-Contents)

About SimoTime Enterprises, LLC
(Next) (Previous) (Table-of-Contents)