User and Reference Manual - Applied Logic Corporation

1 1984-2007 Applied Logic Logic Corporation174 Shore Pointe Place N, Suite 100 Keizer, Oregon 97303(503) and Reference ManualF i l e E d i t U t i l i t yProfessionalFEUD atabase Maintenance and Morefor the AS/400, iSeries and System i5TM Version 15TM 1984-2007 Applied Logic , File Edit Utility, and FEU Professional are trademarks ofApplied Logic is a registered trademark of International Business Machines , eServer, AS/400 and /400, and System i are registered trademarks ofInternational Business Machines Reference Manual may not be reproduced in any form without the express writtenconsent of Applied Logic Logic Corporation reserves the right to make improvements to this product atany time and without notice.

2 1984-2007 Applied Logic of Contents3 Contents1 - 152 - InstallationInstalling from CD Using the AS/400 CD Drive :.. 17 Installing from CD using a PC CD Drive:.. 18 Installing from Tape :.. 19 Licensing:.. 193 - Getting 21 Ways to Use the STRFEU 21 The FEU 21 Setting up FEU for Use with 22 STRFEU Command Prompt 23 Screen Input 24 Select Object and/or View 26 Screen Input 27 Available Function Keys .. 29 Find Object 30 Select Object 32 Select File 34 Select Member 36 Select View 38 Select RPG Source Member 40 Screen Input 41 Available Function Keys .. 41 Data Dictionary Information 42 Screen Input 43 Available Function Keys.

3 43 Table of Contents 1984-2007 Applied Logic - General Menus and ScreensFile Edit Utility 45 Available 46 Functions 48 Available 49 Files 50 Available 51 Views 53 Available 54 Display Modes 55 Available 56 Options 58 Available 59 Defaults 61 Input 62 Available Function Keys .. 63 Database Relations 64 Selecting a new access 65 Displaying Data Base 65 Finding an access path with a specified 65 Printing Data Base 65 Available Function Keys .. 65 Find Logicals 66 Input 67 Available Function Keys .. 67 OPNQRYF Command 68 Using the OPNQRYF 68 Select/Order and Join Operation 69 Select/Order Records 70 Selecting records from the 71 Changing the Order of records in the 71 Creating a Logical 72 Available Function Keys.

4 72 1984-2007 Applied Logic of Contents54 - General Menus and Screens (cont.)Define Join Operation 73 Input 74 Duplicate field 76 Creating a Logical 76 Logical File Creation 77 Input 78 Create DDS from FEU View 80 Input 81 Available Function Keys .. 82 Record Layout Report 83 Available Function Keys .. 84 Report 85 Create Test File 86 Input 87 Compare Two Database File Members 89 Input 90 Deleted Records Display 93 Select Spooled File 94 Input 94 Extract Journal Entries to Database File 95 Input 96 Package Library or File for PC Transport 99 Input 100 Restoring the packaged library or 102 Copy a PF and Related LFs 103 Input 104 Convert a Spool File to HTML 106 The CVTSPLHTM 106 Input 107 Table of Contents 1984-2007 Applied Logic - General Menus and Screens (cont.)

5 Convert a Spool File to PDF 110 The CVTSPLPDF command .. 110 Input 111 Convert a Spool File to TXT 113 The CVTSPLTXT 113 Input 114 List Objects Referencing a File 116 Input 117 Display Duplicate Field Names 119 Input 120 Copy a File Using FTP 121 Input 122 List Level Checks 124 Input 125 Delete Dependent Logical Files 126 Input 126 Clear all members 127 Input 127 Create SQL from FEU View 128 Input 129 Reclaim Deleted Record Space 130 Input 130 Decrypt Physical File 133 About 1335 - Working with 135 Selecting a 135 Change View Screen (View 1) 136 Input 136 Available Function 137 1984-2007 Applied Logic of Contents75 - Working with Views (Cont.)

6 Change View Screen (View 2) 138 Input 139 Available Function 139 Save the View 140 Input 140 Available Function 141 List of Views 142 Input 143 Available Function 143 Deletion of Views 144 Input 145 Available Function 145 Add Fields 146 Input 147 Available Function 148 Change View 150 Available Function 151 Printing a List of all Saved 152 Locking Fields in a Fixed Display 1526 - Browsing a 153 Full Screen Browse by Field 154 Available Function 155 Single Record Browse by Field 156 Available Function 157 Full Screen Browse by Position 158 Available Function 159

7 Single Record Browse by Position 160 Available Function 161 Table of Contents 1984-2007 Applied Logic - Editing a 163 Full Screen Edit by Field 164 Adding 165 Updating 165 Deleting 165 Retrieving Deleted 166 Multiple 166 Working with Null 166 Available Function 166 Single Record Edit by Field 168 Adding a 169 Updating a 169 Deleting a 169 Retrieving Deleted 169 Working with Null 169 Available Function 170 Full Screen Edit by 171 Adding 172 Updating 172 Deleting 172 Retrieving Deleted 173 Available Function 173 Single Record Edit by Position 175 Adding a 176 Updating a 176 Deleting a 176 Retrieving Deleted 176 Available Function 177 Hexadecimal Edit by Position 178 Adding a 179 Updating a 179 Deleting a 179 Retrieving Deleted 180 Available Function 180 1984-2007 Applied Logic of Contents98 - Search 183 Control 183 Interrupting a 183 Field Search/Record Selection 184 Performance 184To search and DISPLAY 185To search and PRINT.

8 185To search and COUNT .. 185To search and REPLACE 186To search and REPLACE records in Another 186To search and DELETE 186To search and EXTRACT .. 187To search and RESTORE 187To search and CONVERT records to .. 187To search and CONVERT records to .. 187To search and CONVERT records to .. 187 Searching Input 188 When found 191 Search Control 193 Available Function 195 Index Key to Begin/End Search Window .. 196 Searching and 197 Replacing Data 198 Replacement 199 Available Function 202 Define Link to Other File 203 Input 204 Available Function 204 Save Changes for Undo Window.

9 204 Searching and 205 Deleting Selected Records 206 Deletion Parameters .. 207 Available Function 207 Save Changes for Undo Window .. 208 Table of Contents 1984-2007 Applied Logic - Search Operations (Cont.)Searching and 209 Printing Selected Records 209 Printing 210 Available Function 211 Print Calculated Field 212 Input 213 Available Function 215 Searching and 216 Counting Selected Records 216 Counting 217 Searching and 218 Copying Selected Records 218 Extracting 219 Encryption 220 Searching and 221 Searching and 222 Converting Records to CSV File 222 Converting 223 Converting Records to TXT File 225 Converting 226 Converting Records to XML Format 228 Converting 229 Global changes saved for Undo 231 Undoing an 231 Available Function 232

10 Select Field 233 Input 234 1984-2007 Applied Logic of Contents119 - Control 235 Windowing the Display 235 Searching for a String of 236 Selecting a Key, Packed Key, or Partial Key .. 237 Index Key Entry 237 Selecting a Relative Record 240 Moving Forward a specified number of 240 Moving Back a specified number of 241 Going to the Top or beginning of a 241 Going to the Bottom or end of a 241 Fast-Path 24210 - Miscellaneous FunctionsStatus Line .. 247 Changing Display 247 Adding 247 Deleting 248 Displaying Records Marked as 248 Retrieving Deleted 248 Working with Blocks of 248 Counting 249 Finding an Object Anywhere on the 249 Finding Logical Files that use a Specified 249 Creating a New Logical 250 Saving a Library or File for Transport Via a 250 Restoring a Library or File that Has Been 250 Working with Spool 251 Converting Spool Files to 251 Converting Spool Files to PDF.