Download Structured Data Environment (SDE)

Structured Data Environment (SDE)
Contents
Documentation Notes.........................................................................................................................................................................1
Summary of Changes..........................................................................................................................................................................2
First Edition (October 2012)....................................................................................................................................................2
Introduction to SDE.............................................................................................................................................................................4
Terminology............................................................................................................................................................................5
Getting Started with SDE....................................................................................................................................................................7
Handling Long Command Strings...........................................................................................................................................7
Opening an SDE Edit/Browse View........................................................................................................................................7
Display Records without a Structure................................................................................................................................7
SDE Data Edit vs. CBLe Text Edit............................................................................................................................8
Display Records using a single COBOL or PL/1 Copy Book...........................................................................................8
Create an SDE structure (SDO) from a single COBOL or PL/1 Copy Book.............................................................9
Create an SDE structure (SDO) Compiler Return Code.........................................................................................10
Display Records or Record Segments using multiple COBOL or PL/1 Copy Books.....................................................10
Create an SDE structure (SDO) from multiple COBOL or PL/1 Copy Books.........................................................10
Display Records or Record Segments using an SDO structure.............................................................................13
Display a Subset of Records or Record Segments........................................................................................................13
Subset using FROM and/or FOR............................................................................................................................14
Create a record FILTER dataset.............................................................................................................................14
Filter Unformatted Record Data..............................................................................................................................15
Filter Formatted Record Data.................................................................................................................................15
Subset using FILTER..............................................................................................................................................17
Changing the Record Display...............................................................................................................................................17
Displaying Records of Specific Record Type(s).............................................................................................................18
Display Unformatted Record Data.................................................................................................................................19
Displaying a Record/Segment in Single Record View...................................................................................................19
Displaying Hexadecimal Representation of Record Data..............................................................................................20
Excluding Records from the Display..............................................................................................................................21
Displaying Selected Columns........................................................................................................................................21
Displaying the Record Headers.....................................................................................................................................22
Searching Data Records.......................................................................................................................................................23
Finding Record Data by Search String..........................................................................................................................23
Locating Records Using a Search Expression...............................................................................................................24
Creating a Subset of Records for Display......................................................................................................................24
Editing Data...........................................................................................................................................................................25
Typing New Record Data...............................................................................................................................................25
Find and Replace Data..................................................................................................................................................26
Inserting Records...........................................................................................................................................................26
Deleting Records...........................................................................................................................................................27
Moving Records.............................................................................................................................................................27
Copying Records...........................................................................................................................................................28
Duplicating Records.......................................................................................................................................................28
Undo and Redo Changes..............................................................................................................................................28
SDE Concepts....................................................................................................................................................................................30
Record Structure Definition...................................................................................................................................................30
Structure Definition Object.............................................................................................................................................30
Record Type Object.......................................................................................................................................................30
Record Type Object Data Length..................................................................................................................................30
Structure Definition File..................................................................................................................................................30
Record Type Assignment......................................................................................................................................................31
Structured Data Fields..........................................................................................................................................................31
SDE Window Views..............................................................................................................................................................32
Multi Record View..........................................................................................................................................................32
Field Column-Heading Lines..................................................................................................................................32
Prefix Area..............................................................................................................................................................33
Data Records..........................................................................................................................................................33
Shadow Lines.........................................................................................................................................................34
Single Record View........................................................................................................................................................34
SDE Data Formats................................................................................................................................................................35
Table Format..................................................................................................................................................................35
Single Format.................................................................................................................................................................35
Character Format...........................................................................................................................................................36
Hexadecimal Format......................................................................................................................................................36
Hexadecimal Dump Format...........................................................................................................................................37
SDE Data Types...................................................................................................................................................................37
SDE Edit Techniques............................................................................................................................................................40
Changing Record Lengths....................................................................................................................................................42
SDE Current Window............................................................................................................................................................42
Default Record Type.............................................................................................................................................................42
DB2 Table Display................................................................................................................................................................43
Overview........................................................................................................................................................................43
DB2 Table Edit/Browse..................................................................................................................................................43
Segmented Records.............................................................................................................................................................44
2013-11-13 13:03:23
i