Data File Editor
 Using the Basic Functions
http://www.simotime.com
When technology complements business    Copyright © 1987-2010  SimoTime Enterprises  All Rights Reserved
  Table of Contents Version 09.05.17 
  Introduction
  Adding a Data File to a Project
 
  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
  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 basic functions of the Micro Focus Data File Editor to view records in a data file.

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, 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\DataAsc1" 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, 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 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, 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 "ITEMASC1.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 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 ITEMASC1.DAT should be shown in both the left and right window panes. Double-click on either item (ITEMASC1.DAT) 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, 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, Viewing Hexadecimal Values
(Next) (Previous) (Table-of-Contents)

The following screen should be displayed.

The following window with hexadecimal data should be displayed.

1. Use the mouse to position the cursor to the left of the first hex 40 value as shown in the preceding window.
2. Notice the col (column) value shows 82. The characters at position 82 and 83 are EBCDIC spaces in an ASCII-encoded file.
3. Another indication is the display of the "@" character in the translated display in the larger window pane showing the first few records in the file.

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
(Next) (Previous) (Table-of-Contents)

Founded in 1987, SimoTime Enterprises is a privately owned company. 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
Copyright © 1987-2010  SimoTime Enterprises  All Rights Reserved
When technology complements business
http://www.simotime.com
Version 06.01.05