filescopetools 4 use.. - Raz-Lee
Contents
1. All libraries in the job s library list are searched until the first match is found CURLIB The current library for the job is used to locate the journal receiver If no library is specified as the current library for the job QGPL is used Ending Journal Receiver Specify the name of the last journal receiver whose entries are to be converted for output CURRENT The journal receiver that is currently attached when starting to convert journal entries is used Library Library The name where the journal receiver is located LIBL All libraries in the job s library list are searched until the first match is found CURLIB The current library for the job is used to locate the journal receiver If no library is specified as the current library for the job QGPL is used Starting Date and Time Specifies the date and time of the first journal entry being converted for external representation Starting Date MM DD YYYY Specify the starting date of the first journal entry occurring at or after the specified starting date This becomes the starting point for the range of entries to be converted for external representation Starting Time Specify the starting time of the first journal entry occurring at or after the specified time of the first journal entry on or at that time This becomes the starting point for the range of entries to be converted for external representation The time can be specified with or with2. by IBM FileScope Tools 4 User Manual Appendix C Technical Description Libraries Objects in QGPL library to QGPL Library list FileScope Tools 4 User Manual SMZ2 SMZXDTA All commands are copied from the product not changed during or after execution and should include QGPL Appendix D Product defaults System wide defaults can be customized To modify them select option 81 from the main menu accessed by STRFST FileScope Tools 4 User Manual
3. 1 next to the item you wish to view and press Enter Display User Spac System User Space FSRCDLST Library QTEMP TYPE ave ao OE ENE USRSPACE Length 3 Text Offset H 50 100 150 200 REDL 200DEMOPF SMZ1 250 300 350 400 Press Enter to continue F3 Exit F12 Cancel Pressing F12 will return you to the main menu FileScope Tools 4 User Manual 5 4 Display Edit Data Queue Options 31 32 allow for the displaying and editing Data Queues in either standard data queue format or where data is divided into fields based on a template file It allows the user to use their current file editor to display or edit the data in the data queues The screens below reflect the criteria input screens for displaying and editing the data queues Display Data Queue DSPDTAQ Type choices press Enter Data queue Dot Name generic ALL Library e LIBL Name LIBL CURLIB Format file DTAQ Name DTAQ NONE Library DTAD Name DTAQ Maximum data length FMIFILE Number FMTFILE Bottom F3 Exit F Prompt F5 Refresh Fl2 Cancel F13 How to use this display F24 More keys Edit Data Queue Type choices press Enter Data oueue LL 222 generic ALL Library LIBL Name LIBL CURLIB Format file DTAQ Name DTAQ NONE bibrarg 245 2 rer ok He DTAD Name DTAQ Lock data queue YES YES NO Maximum data length
4. Definition To change the definition of a field press F10 from the Reorder Screen You are prompted for the name of the field to change You will be shown a display of the current definition allowing you to make the changes RGB Input Specification Fields Fields defined as RPG input specifications or as Data Structure can be imported automatically by using S 36 Files Support Option 31 on the service screen Formulas and Functions Enter a formula or function in combination with fields Constants can be used to define the calculated field Fields in the record can be selected from a list using F4 The functions supported by FileScope Tools are those that are supported by most file editors and include date time conversion field concatenation character and string conversion and IF logic functions Pressing F7 will bring up the Function List window 14 records Show file SM21 DEMOPF contents mbr DEMOPF Add an internal calculated field Field name Date Time List of functions From posit or Formu Select function to be placed at the cursor position 1 Select 5 Help Position to S Sel Name Type Text Column hea ADDDAT SYS Getdate from base date added Hdays CAT SYS Concatenate fields CATP xSYS Concatanate fields padding Text CHR2NUM SYS Convert char fields to numeric S CYTDAT SYS Convert date F3 Exit CYTLTR xSYS Convert letters Case S CYTSTR SYS Convert String CY TTIM SYS Convert time F3
5. Exit F12 Cancel More F3 Exit F6 Un Fold F9 Add Fld Fi Chg Fld Fi2 Cancel F16 Find F17 Top F18 Bot tom F20 Renum F22 KeySeg F23 I FileScope Tools 4 User Manual By putting a 5 next to a function on the List of Function will provide help on that function The available functions are ADDDAT Get Date from base added days CAT Concatenate fields CATP Concatenate fields padding CVTDAT Convert Date CVTLTR Convert Letters Case CVTSTR Convert String CVTTIM Convert Time DAYWEEK Find the weekday out of the date FLIP Reverse field data IF IF Function IFAND IFAND Function code IFOR IFOR Function code MAP Copy and map to field to new attributes RANDOM Fill file randomly WEEK Get the week year for a date FileScope Tools 4 User Manual IF IFAND and IFOR Functions The IF IFAND and IFOR functions can be use to return a value for a calculated field based on tests between one or two sets of values The test operators s can be EQ NE GT GE LT or LE If using File Scope as your file editor there is a full explanation of the usage of these functions in the manual A brief description and example is provided below to demonstrate these functions The IF function allows a test to be made between two values each value can be either a constant or a field The result of the test true or false determines which of another two values fields or constants are returned by the calculation Format IF amp val
6. F5 Refresh F12 Cancel F13 How to use this display F24 More keys Data Area Specify the name and library of the data area whose value you wish to edit ALL Edit the entire data area generic Data that starts with the first letter specified LDA Local Data Area that is associated with your job can be edited The length of this data area is 1024 bytes GDA Group data area associated with your job can be edited The length of this data area is 412 bytes Library The library where the data area you wish to work with is located LIBL All libraries in the job s library list are searched until the first match is found CURLIB The current library for the job is used to locate the data area Name Specify the name of the library where the data area is located FileScope Tools 4 User Manual Edit Data Area EDTDTAARA Type choices press Enter Data area pk tee oe Name genericx LDA GDA Libra Data areas in DEMOTMP ALL Type option press Enter 1 Select Opt Name Text DEMODTAARA DEMO DATA AREA DEMOLGLARA DEMO LOGICAL DATA AREA Bottom F3 Exit F12 Cancel F3 Exit F24 Mor If you have chosen ALL in your search criteria you are presented with all the data areas in the named directory Make your selection by pressing 1 next to the data area you wish to work with You are only able to work with one data area at a time Edit Data Area System 44K1246 Data Area s DEMODTAARA Lib
7. Option to use prompt file editor Yes No Journal Code Value Specifies the journal codes for which journal entries are converted for output ALL The conversion of journal entries is not limited to entries with a particular journal code A System Accounting Entry C Commitment Control Operation F Database File Member Operation J Journal or Receiver Operation L License Management M TCP IP and Network Management Data O Object Oriented Entry Journal Code Selection Specify which journal code you wish to have converted for output ALLSLT The journal with the specified journal codes are converted for output only if all other selection parameters are satisfied FileScope Tools 4 User Manual Job Name Specifies that the journal entries being converted for external representation are limited to the journal entries for a specified job Only journal entries for the specified job are converted for external representation Name Specify the name of the job ALL The conversion of journal entries for external representation is not limited to entries for a specified job User Specifies the user of the job Name Number Specify the system assigned job number Program Specifies that the journal entries being converted for external representation are limited to the journal entries created by a specified program ALL The conversion of journal entries is not limited to entries create
8. but it will run the Viewpoint NO A viewpoint has been selected but it will not run Allow new file vpt selection Specifies whether the use may select a different file to use with the selected Viewpoint YES The use may select a different file to use with the Viewpoint when exiting the product NO The user many not select a different file when exiting the product Auto run function in batch Specifies if and what functions have to be performed in a batch run NO batch run is not required SHWFC runs online PRINT runs the print multiple records REPORT runs the report generator option PRNTONE runs the print single record option Pressing F10 will bring up the following options Allow save of VPT Specifies whether Viewpoint modifications can be saved ALL Enables update of all viewpoints including PERMANENT Viewpoints YES ViewPoint modifications can be saved NO ViewPoint modifications cannot be saved Save modified VPT as default Specifies whether modified Viewpoints should be saved by default YES The modifications to the ViewPoint are saved by default when exiting the product NO The modified ViewPoints are not saved when exiting the Product System Specifies whether the file is on the local system or on the remote system LCL The file is on the local system RMT The file is on the remote system ALL The file is on bot
9. fields you can break the fields into smaller ones enabling easier viewing and updating The modified layout can then be saved for future use when using your file editor Using the From Position parameter you define the Internal Fields By using this parameter you designate the starting position within the record Internal Fields which do not cross field boundaries i e Start and Finish within one external field can be used in selection tests for a SUBSET Calculated Fields are defined using either formulas or functions Press F9 to define a new Internal or Calculated Field Add an internal calculated field Field name Type _ Length Decimals __ Date Time format Separator _ DDS name From position or Formula Function Column headings F3 Exit F4 Prompt fields F7 Select function Fi Cancel Enter the name of the new field type starting position length decimal position formula and column headings or function and text The ORDER number for each new field adds set at 1 00 and all other ORDER numbers are incremented accordingly The new field can be used with the CHGFC command to update a file It can also be used like any other field for scanning FileScope Tools 4 User Manual Internal field definitions can be saved together with an associated ViewPoint To remove an Internal field definition from a ViewPoint change the ORDER number to a value greater than 900 00 Changing Field
10. mbr DEMOPF VPT NEW Modify Order Spaces and Column heading to rearrange field layout Find CT Use Order gt 900 to ignore a field DEMO ITEM MASTER FILE ttributes Fr To Relative 9 ITEM 1 6 DESCRIPTION j 7 18 ITEM 19 22 OTY 23 26 OTY 27 28 29 31 PRICE 32 37 PRICE 36 40 41 42 bh UDO E ve SALES DESCRIPTION W 43 72 15T OTR 73 76 2ND OTR 77 60 SRD OTR 61 84 A 5 A A 5 B B ITEM P S P P A P P P P l l le l w e e e w e e e je fit NNNNOGCGNONOOGO ONDO D On On On oN NS ATH DTR 85 88 More F9 Add F ld F1 Chg F ld F12 Cancel F16 Find F20 Renum F22 Keyseqg F23 Ignore New fields can be added to the list without changing the file definition and all FileScope Tools displays will reflect the newly defined order All changes made via the Reorder Screen including the addition of internal fields can be saved as a ViewPoint FileScope Tools 4 User Manual 1 6 Internal and Calculated Fields FileScope Tools combined with your existing file editor lets you define additional fields that can be used with the display change and print functions of your editor This can also help you query and maintain files that do not have external definitions The fields can be defined for files that do not have external definitions DDS as well as for files with external definitions For files that contain large
11. ES YES NO Auto run function in batch NO PRINT REPORT NO Botto F3 Exit F4 Prompt F5 Refresh F10 Additional parameters F12 Cancel F13 How to use this display F24 More keys To keep the default settings press the Enter Key to change the information type your changes in the supplied fields File Name Enter the name of the file you wish to use PRV Automatically will retrieve the previous file Select Display the file member viewpoint selection screen S Short cut for Select Library Enter the name of the Library where the file is stored LIBL Search the library list to locate the file Member name Enter the name of the file member FIRST Start with the first member in the file SELECT Display the file member viewpoint selection screen S Shortcut for SELECT Show by Key Sequence Define the sequence in which keyed fields will be displayed YES Keyed files are accessed in their key sequence NO File is accessed in its physical sequence ViewPoint name Enter the name of the defined viewpoint DFT H a viewpoint with an identical name to the current file name exists is used Otherwise the DDS of the file is used NEW The DDS of the file is used SELECT Display the file member viewpoint selection screen FileScope Tools 4 User Manual S Short cut for SELECT Run ViewPoint Runs the selected viewpoint YES If viewpoint has been selected
12. FMTFILE Number FMTFILE Bottom F3 Exit Fd Prompt F5 Refresh Fi2 Cancel F13 How to use this display F24 More keys FileScope Tools 4 User Manual Chapter 6 Previous Commands RTV Related Products and Maintenance 6 1 All Previous Commands To work view and run previous commands without pressing the F9 key until you get to the command that you are looking for pressing 61 will display all previous commands that have been entered Work with Previous Commands Type options press Enter 1 Run 2 Change Opt Message CHGFC FILE LIBL DEMOPF chgfc demopf dsplib qtemp strfst strgsnet F3 Exit Fo New F12 Cancel This screen will show the last ten AS 400 commands that were processed This allows you to easily work through the menu and recall commands most commonly used By pressing the PgDn key you will see the next ten commands that were run Pressing F6 will allow you to enter a new command and add it to the top of your page When you enter the command it will be run automatically Pressing F12 will return back to the All Commands Screen Pressing F3 will return you back to the FS Tools Main Menu To run a command place a 1 next to the command that you wish to run To change a command place a 2 next to the command you wish to edit the command FileScope Tools 4 User Manual 6 2 FileScope File Editor Pressing 71 from the FS Tools Main Menu switches you between FileScope or
13. RAZ LEE gt The iSeries Security Experts iSecurity FileScop Tools An Assortment of Utility Programs designed for the iSeries Programmer using FileScopeTM or another file editor User Manual Version 4 ABOUT THIS GUIDE Who should use this guide What you should know Using FileScope Tools is very simple and requires no special technical background You only need to know the basics of display station operation Help is only a keystroke away How this guide is organized This guide is divided into chapters beginning with an introduction to FileScope Tool s capabilities and followed by detailed descriptions of the functions available in the product Subsequent chapters cover Appendices cover installation instructions and other technical aspects Before using FileScope Tools you may find it helpful to follow along with the examples that begin in Chapter 1 Contents CONTENTS si eege eene EE nananana raai da kikao 1 Welcome to FileScope Tools rrsrnnnvnnvnnnvnnnvnnnvnnnnnnnnnnvnnnennnnnnnnnnnnnnnnnnennnnnnnnnnnnne 3 Whats FIIESCODE TOOS Las r akk bigaust 3 FileScope Federal use 3 How FileScope Tools Can Help vo 3 Getting STEG avse 2 pelen 2 Entering the Product Authority Code ennnnrnevnnnnnnnnnnenarernnennndnennnnnrnenennnsnte 3 The Main Menu EE 4 QUICK kee es EE 4 Displaying the FileScope Tools menu 4 Chapter 1 File Information ernnnnnnnnnvnnnvnnnnnnnnnnnnnnvnnnnnnnnnnnnnnnnnn
14. S 36 conversion Report Generator Join files etc Through this screen it is possible to display more infor4mation about the file through the operating system commands The contents of this screen vary according to the command used SHWC or CHGFC the parameter setting of the command and the relevant FileScope File Editor you are working on Refer to your specific file editor manual for the proper settings FileScope Tools 4 User Manual 1 7 Edit Pressing 2 from the main display file information menu brings you to the edit screen File Control Layout Mode Subset Print Window Special 20 records Change file SM21 DEMOPF contents mbr DEMOPF Control _ T Top B Bottom N Nxt P Prv nnn K Key Fmt ITEMAS 15t Fld 1 n Name O n F4 Vpt NEW Scan Test _ Value Relative ITEM HIDESCRIPTION ITEM PRICE Record TRUNCATED VENDH ON HAND ON ORDER PRICE DATE Number ITEMNO SDESCR VEND OTYOH OTYOO PRICE PRCDAT CDRO10 CD RECORDABL 26 930418 CI999X COPIR INK 778 i 950412 093757 CASSETTES 43 f 39 950515 D001 DISK 8 D2 15 8 45 950305 E3100 ELC SHARPEN 13 i 44 941247 F2100 FILE FOLDER H i 57 931215 F2101 FILE FOLDER 5 57 931215 HPO003 3 HOLE PUNCH 30 i 98 950119 L00028 LETTER OPEN 15 i 24 881005 MPO001 MARK PEN BLK 5 2 211231 MPO002 MARK PEN RED K 8 102 941216 1 NPOQO1F NOTEPAD A4 L ER 100 991231 F3 Exit F5 Refresh F6 Mode F10 Update Fi1i Single F13
15. SFRMPC Programming Deleted records 61 ALL previous commands RTV 21 Undelete records WIZARD DTAQ Related products 31 Display Data Queue DSPFSDTAQ 71 File editor 92 Edit Data Queue EDTFSDTAQ DTAARA USRSPC Maintenance 41 Edit Data Area EDTFSDTAAR 81 System Configuration 427 Display User Space DSPFSUSSPC 62 Maintenance Menu 43 Edit User Space EDTFSUSSPC with field level support Selection or command F3 Exit F4 Prompt F9 Retrieve F12 Cancel F13 Information Assistant F16 AS 400 main menu FileScope Tools 4 User Manual Chapter 1 File Information 1 1 Working with File Information Full Screen Display Selecting option 1 from the FileScope Tools main menu to bring up the multi file screen FS Tools Work with File Information File 2 2 al ALL ALL Generic name Library SMz1 Position to Type options press Enter 1 Display 2 Edit J Journal contents A Attributes M Members O Formats R Re lations S Select Omit K Keys F Fields Opt File Type Keyed Text CHGDFNPF PF Y ViewPoint definition CHGJIRNP PF Y Log of file changes CHGRESP PF Y FileScope restriction file DEMODATE PF Demo file emphesize on date formats DEMOPF PF Y Demo file DEMOPFOLD PF Y Demo file FSKEYP PF FS key representation FSOUTF PF FS Outfile template FSOUTS PF FS Outfile template not add specal FSPARM PF FileScope parms FSPDP PF FS Pull Down logic physical file More F3 Exit F5 Refresh F12 Cancel F17 Sub
16. Service F24 More keys To update data on the Multi record screen press F10 The first record or the record where the cursor is located will appear The Tab Key will move the cursor from field to field within the window Change an input field or fields by typing over the displayed data Press Enter to open a window on the next row The cursor can also be moved up or down This is in order that the user can be free to choose the next record on the screen to be changed Enter will open the window on the chosen record If the journaling system is active you should enter text describing the planned group of updates so that you are more easily able to identify other changes in case they need to be revoked If the journaling system is not active a warning message will be displayed Pressing enter will complete the update of the records and leave the update mode After modifying the last displayed record the process will be completed exactly like the F10 key Pressing F12 leaves the update mode without updating the records A warning will appear Press F12 again to exit without updating To return to the update mode press Enter FileScope Tools 4 User Manual Chapter 2 Copy from PC Format FileScope Tools is now capable of copying a stream file from the PC to the AS 400 The stream file needs to be either a Comma Separated File CSV or a TAB created file You must have Client Access installed on your PC to view the file from a PC or anothe
17. d by a particular program Name Specify the name of the program whose journal entries are being converted for external representation User Profile Specifies that the journal entries being considered for conversion for external representation are limited to the journal entries created for the specified user profile name The user name identifies the user profile under which the job was run that deposited the journal entries ALL Specify the name of the program whose journal entries are being converted for external representation Name Specify the name of the user profile whose journal entries are being converted for external representation FileScope Tools 4 User Manual Work with Journal Contents WRKJRNC Type choices press Enter Dependent entries xALL NONE Outfile format xTYPE3 Entry data length Field data format Number QUTFILFMT xCALC Variable length field length Number CALC Allocated length Number FLDLEN Bottom F3 Exit F4 Prompt F5 Refresh F10 Additional parameters F12 Cancel F13 How to use this display F24 More keys Dependent Entries Specify whether the journal entries to be converted for output include the journal entries recording actions that occur as a result of a trigger program and actions on records that are part of a referential constraint ALL The journal entries relating to activate programs and referential constraints are converted NONE The journal entries relating to t
18. ding date This becomes the ending point for the range of entries to be converted for external representation Ending Time The ending time of the first journal entry This time becomes the ending point for the range of entries to be converted for external representation The time can be specified with or without a time separator Without a time separator specify a string of 4 or 6 digits hum or hhmmss where hh hours mm minutes and ss seconds With a time separator specify a string of f or 8 digits where the time separator specified for your job is used to separate the hours minutes and seconds If you enter this command from the command line the string must be enclosed in apostrophes If time separator other than the separator specified for your job is used this command will fail FileScope Tools 4 User Manual Number of Journal Entries Enter the total number of journal entries that are being converted for output ALL All journal entries that meet the selection criteria values and that are in the specified journal receiver range are converted Number Enter the maximum number of journal entries to be converted Command to use You may edit or simply display the journal contents using the default file editor as defined in the global parameters EDIT Edit journal DSP Display journal Additional params for command Type any additional command parameters as required by your file editor Prompt File Editor
19. e rest of these instructions Sign on as QSECOFR or a user with equal authority Load the tape and enter the LODRUN TAPxx where TAPxx is the tape drive name or LODRUN OPTxx where OPTxx is the Optical Drive name After some minutes an INSTALLATION MENU will be displayed Choose the products you need to install by typing 1 under the OPT field Key in the Authority Code s if necessary in the authority code column Remark the Product Authority Code can also be keyed after the installation see Chapter Entering the Product Authority Code The products will be installed one after the other At end press F3 to exit FileScope Tools 4 User Manual Entering the Product Authority Code The Authorization Code is a character string that releases FileScope Tools for operation on your AS 400 There are two types of authorization codes a demonstration code for a predetermined evaluation period or a permanent code for normal use During the product evaluation period FileScope Tools can be installed on multiple machines by using the demonstration code From your AS 400 type the command STRFST to obtain the Product Menu Choose Option 81 Configuration Press F22 then enter the Authority Code Press F3 to exit to the product menu Obtaining the CPU Serial Number To obtain a permanent Authorization Code you must determine the computer serial and model number To do this enter the fol
20. h local and remote systems Initialization subset Define a subset for report generation YES You will be able to define the subset NO You will be able to define the subset Note The example used shows results when using FileScope as your file editor Using another editor will not bring up the SHWFC screen FileScope Tools 4 User Manual Your display screen will show you the first 12 records of your file as shown in the picture below File Control Layout Mode Subset Print Window Special 14 records Show file SMZi DEMOPF contents mor Control T Top B Bottom N Nxt P Prv nnn K Key Fmt 1st Fld 1 In Name O n F4 Scan Test _ Relative DESCRIPTION Record TRUNCATED ON ORDER SDESGR FILE FOLDER 3 HOLE PUNCH R OPEN PEN BLE PEN RED S E AD A4 L S E 99123 LS 2 S i 960106 LS 3 S gt f 941233 CASSE 950346 m CASSE S i 920314 Dp G BINDR S d H 006 STAPLER H D s 940319 F3 Exit Fii Single red Fis Servic 24 More key aa L CG 03 T5 S i en T ee Ow TN e Oo 1 1 1 1 The display screen has two parts The top part shows a pull down menu and the bottom is where you can enter your view information The actual file member number of records and ViewPoint name are displayed as well FileScope Tools 4 User Manual 1 4 Single Record Display By press F11 you will be able to view an individual record If you do not
21. he activate programs and referential constraints are not converted Outfield format Specifies the format of the journal entries written to the output file TYPE3 Converted journal entries are formatted to include the minimum information that can be specified Field Data Format Specify the format of the output file Number Numeric length of the field OUTFILFMT The field length of the entry specific data field in the output file is determined by the value specified on the out file format prompt CALC The system calculates the maximum length of the entry specific data field to accommodate the longest entry specific data of all journal entries in the specified receiver range Allocated Length Specify the length of the field Number Specify a character number between the ranges 1 to 8000 FLDLEN The allocated length is the same as the maximum length of the field if CALC is specified for the maximum field length and the maximum length calculated by the system is smaller than the allocated length you specify the allocated length is set to the maximum field length FileScope Tools 4 User Manual Chapter 5 Data Area User Space and Data Queue 5 1 Edit Data Area To enter the Edit Data Area Screen press 41 from the FS Tools main menu screen Edit Data Area EDTDTAARA Type choices press Enter Data area x Name genericx LDA GDA Library Name LIBL xCURLIB Bottom F3 Exit F4 Prompt
22. ist Enter the name of the LIBRARY that you want the file to be set to FileScope Tools 4 User Manual Omit un needed records This screen requests that you delete the records that you don t want to be restored This is done by your file editor Restore Records This will restore all remaining records to the original file and put them back into their original place After completing the required information and pressing enter you will see a WARNING screen If you press NO then the records will not be updated back to the RRN Pressing Y will reposition the records back in the RRN FileScope Tools 4 User Manual Chapter 4 Journal Contents This command allows you to work with converted journal entries contained in one or more receivers into a form suitable for external representation If the database file exits records may either be replaced or added to the current data in the indicated file member The system creates the specified database file member if they do not exist Database files created by the system have a standard format A WARNING message is sent and the records are truncated if any of the entries are longer than the specified maximum record length of the output files The contents of selected entries in the journal receivers may be converted for output It is also possible to selectively limit the entries that are displayed If no journal entries satisfy the selection or limitation criteria an escape message is sen
23. lowing command DSPSYSVAL QSRLNBR The Machine type model The System serial number and the product release is entered on the License Agreements when ordering your product FileScope Tools 4 User Manual The Main Menu FileScope Tools is simple to use If you have ever worked with a spread sheet and do not mind pressing the HELP key every once in a while then you can get started right away However you may want to read through this User Guide before actually working with FileScope Tools If you have not already done so you must install your FileScope Tools CD or Tape and enter your authorization code Quick Start This quick start section has been designed to help you to start using FileScope Tools as quickly and efficiently as possible You will see the product in action when using the sample file that is shipped together with the product This process assumes that you have already installed FileScope Tools and keyed in a valid authorization code If you have not yet installed the product refer to the separate Installation chapter in this document Displaying the FileScope Tools menu In order to start using FileScope Tools issue the STRFST command You will subsequently see the FileScope Tools main menu FSTMENU FileScope Tools Menu System 44K124 Select one of the following File information Journal 1 Work with file information 51 Work with Journal Contents PC file format 11 Copy from PC format CPYF
24. ls 4 User Manual 5 3 Display User Space To display a user space select option 43 from the main menu Display User Space DSPUSRSPC Type choices press Enter User space Name genericx ALL Library Name LIBL CURLIB Format Bottom F3 Exit F4 Prompt F5 Refresh F12 Cancel F13 How to use this display F24 More keys User Space Select the user space to display ALL All user spaces will be displayed Name Enter the name of the user space to display generic Select from a list by assigning the first letter of the user space name Library Select the location of the user list that you wish to display LIBL All libraries in the job s library are searched until the first match is found CURLIB The current library for the job is used to locate the user space Name Enter the name of the library where the user space is located Format Specify the format of the space to display CHAR Character FileScope Tools 4 User Manual After selecting your criteria press Enter If you did not enter a name you will be given a list of user spaces to choose from Display User Space DSPUSRSPC Type choices press Enter User Space sv ja ea a s ALL Name generic ALL Library oa 4 Gets SP Goal NM qtemp Name LIBL CURLIB Format User Space in QTEMP ALL Type option press Enter 1 Select Opt Name FSFLDLST FSRCDLST Bottom F3J Exit F12 Cancel To choose the user space place a
25. nnnnnnnnnnnnnnnennnn 5 1 1 Working with File Information Full Screen Display 0nn0nneeeeeeeeeea 5 IA Fe OPS ae 6 1 3 Display File with editor of your choice uanrnnnnrnnnvennnrnnnnrnnnvrnnnrnnnnennnnn 7 1 4 Single Record Display Lua snmnmntmnvmdemhumngjkipekvenset 10 1 5 Reorder FEKS EE 11 1 6 Internal and Calculated Fields rrrnnnnrnnnrrnrnnrrrrrnrrrrrnnnnrrnnnnrrnnnnernnn 12 E Ee EE 16 TE apene 17 Chapter 2 Copy from PC Format rsernnvrnnvnnnvnnnvnnnnnnvnnnvnnnnnnnnnnnnnnnnnnvnnnnnnnnr 18 Chapter 3 Deleted Records rs rnavnnnnnnnvnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnennnnnnnnr 19 3 1 REEVE R cords ege nate soatanceconabetaagadansaceianaleseateets 19 Chapter 4 Journal ContentS rssvnssvnnnnnnvnnnvnnnvnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnennnennnnr 21 Chapter 5 Data Area User Space and Data Queue rssrrrnvrnnnvnunnvnnvnnnnnnnn 28 5 1 Edit Data ME EE 28 e Ee EE 30 5 03 Display USer SpaCe au ES 31 5 4 Display Edit Data Queue rrnnnrrnnnrrnvrrnvvrrnvnrrnvrrnnvrrnnnrrnversnnrrsnnrrnvernnn 33 Chapter 6 Previous Commands RTV Related Products and EU E 34 6 1 All Previous CommandS vaare eee 34 6 2 FileScope File Edtor 35 63 Elie 35 Appendbr A Backup iiiscsccicsetcccsvacstncandscsiucsestisvencstcusevadtensncdunctsisueaduedessatvncuness 37 Gi Ce ierg ei 37 Appendix B Performance Tips rnrnnnvnnnnnnvnnnvnnnvnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnennne 38 Ap
26. out a time separator Without a time separator specify a string of 4 or 6 digits hhmm or hhmmss where hh hours mm minutes and ss seconds With a time separator specify a string of f or 8 digits where the time separator specified for your job is used to separate the hours minutes and seconds If you enter this command from the command line the string must be enclosed in apostrophes If time separator other than the separator specified for your job is used this command will fail FileScope Tools 4 User Manual Work with Journal Contents WRKJIRNC Type choices press Enter Ending date and time Ending date Ses 6 Gen lt I Date Ending time 4 5 he se a Time Number of journal entries ALL Number ALL Command to use i sv e be xEDIT xEDIT DSP Additional params for command NONE Prompt File Editor command NO YES NO Journal codes Journal code value ALL ALL Ay 65 Fy dy Li M 0 Journal code selection ALLSLT for more values Job names ects ae we e ALL Name ALL USO roer DE ee et ne Name Number EE DET 000000 999999 More F3 Exit F4 Prompt F5 Refresh F12 Cancel F13 How to use this display F24 More keys Ending Date and Time Specifies the creation date and time of the last journal entry being converted for external representation Ending date MM DD YYYY The ending date of the first journal entry occurring at or before the specified ending on the en
27. pendix C Technical Description rsernnvrnnvnnnvnnnvnnnnnnvnnnvnnnvnnnnnnnnnnnnnnennne Appendix D Product defaults Welcome to FileScope Tools What is FileScope Tools FileScope Tools is a set pf enhancement tools which Provides ease of use in several aspects for programmers Provides better support for partial and non existing support in operating systems FileScope Tools Highlights With FileScope Tools it is possible to Work with Journal contents Retrieve deleted records Undelete Records Edit data areas Quick review of all previous commands Work within File information display edit file with any editor of your choice How FileScope Tools Can Help You Extended Functionality Create analysis reports sub files etc Provide missing commands such as Edit Data Areas Enabling options that are not available from the operating system for example retrieve undelete records when the journal has not been defined Increase productivity support development and testing Getting Started Installation Installation on an AS 400 computer from TAPE CD Be sure that no one is working on the products you want to install use the WRKOBJLCK command on library SMZ2 of the product like WRKOBJLCK SMZ2 LIB f you are upgrading from CISC to Power PC RISC processor first save the product libraries SMZ2 SMZ2DTA restore them on the RISC machine and proceed with th
28. position the cursor on the record you wish to view the first record in the file will be viewed o 14 records Show file SMZ1 DEMDPF contents DEMOPF Control N T Top B Bottom N Nxt P Prv nnn K Key Fmt ITEMAS ist Fld 1 n Name O n Fal Vpt NEW Type choices press Enter Field key eaaa a er ee ee dt TERT RRN T Relative record number ITEMNO 1 HPOOO4A ITEM SDESCH DESCRIPTION TRUNCATED VEND 2 ITEM VENDH QTYOH r QTY ON HAND QTY00 e QTY ON ORDER PRICE i ITEM PRICE PREDAT ay PRICE DATE YY MM PRCCHG E 9 PRICE CHANGE IN SALESH G SALES MAN DESCR DESCRIPTION CSL501 e LST QUARTER SALES CSLS02 2ND QUARTER SALES CSL503 P 3RD QUARTER SALES CSLS04 4TH QUARTER SALES F3 Exit F8 Fld Pos Atr Fi2 Cancel F13 Service Fi4 Reorder F21 No Hex F22 Cmd F6 Mode FileScope Tools 4 User Manual 1 5 Reorder Fields The Reorder Fields option enables you to customize the screen display and report shape This includes choosing which fields are displayed and the order in which they are displayed This is accomplished through changing the number of spaces between fields modifying titles and column headings 14 records Key Order Field Spaces Column heading 1 00 RRN 1 ITEMNO SDESCR 2 i VENDH QTYOH QTY00 PRICE PRCDAT PRCCHG SALESH DESCH CSLS01 CSLS02 C8L803 C8L804 F6 Un Fold F18 Bottom Show file SM21 DEMOPF contents
29. r computer the regular procedure is Select Network Neighbourhood Select the AS 400 Select the TMP directory to see the file Clicking over the file usually turns on the MS Excel which works directly on the file To perform this operation press option 11 from the FileScope Tools main menu FileScope Tools 4 User Manual Chapter 3 Deleted Records There are two options to work with when you have records that are marked for deletion The first option allows you to retrieve records and store them in a separate file The second option allows you to retrieve and restore them back into their original file 3 1 Retrieve Records Selecting option 21 Undelete Records Wizard FSTMENU FileScope Tools Menu Undelete Records Wizard Select File Backup Retrieve to outfile Omit un needed records Restore records Cancel Previous Finish F3 Exit F4 Prompt F9 Retrieve Fi2 Cancel F13 Information Assistant F16 AS 400 main menu There are five steps involved in the Un Delete process You will need to follow all of the steps in order for the un delete process to work Select File Enter the name of the File Library and Member These are required fields Backup After entering the file information you will need to specify your back up information Retrieve to outfield Enter the name of the file or one will be automatically created and assigned To override a file that was already created before press F4 and select from you l
30. rary ee DEMOTMP Type ww we ee xCHAR 2000 DEMO DATA AREA 0123456789abcdefghijjklmnopgrstuvwxyzABCDEFGHIJKLMN OPRSTUVWXYZ tt tt t CCCC CCU Press Enter to continue F3 Exit F12 Cancel As you can see from the above screen you have full command of the editing procedure You can enter text in both upper and lower case To save the new information press Enter Pressing F3 of F12 will exit the screen and return you to the FS Tools Main Menu FileScope Tools 4 User Manual 5 2 Edit User Space To edit the User Space select option 42 from the main menu Edit User Space EDTUSRSPC Type choices press Enter User space Name generic ALL Library Name LIBL CURLIB Format Botto F3 Exit F4 Prompt F5 Refresh Fi2 Cancel F13 How to use this display F24 More keys User Space Select the user space to edit ALL All user spaces will be edited Name Enter the name of the user space to edit generic Select from a list by assigning the first letter of the user space name Library Select the location of the user list that you wish to edit LIDL All libraries in the job s library are searched until the first match is found CURLIB The current library for the job is used to locate the user space Name Enter the name of the library where the user space is located Format Specify the format of the space to edit CHAR Character FileScope Too
31. s on ENTER Type Y to specify that the user can exit lists panels with the ENTER key N to Specify that the user cannot exit lists panels with the ENTER key FileScope Tools 4 User Manual File Editor Select the File Editor you wish to use File Editor Name amp libraries Enter the name of the file editor Libraries to add Enter the libraries to add to your library lists NONE means that no libraries are added Main Menu Enter the command used to call the File Editor Program Display Command Enter the command used display your files Edit Command Enter the command used to edit your files Work with Views command Enter the command used for Working with Viewpoints Release ID The current version of the product Authority Code Press F22 to enter your authority code FileScope Tools 4 User Manual Appendix A Backup The product libraries should be regularly backed up Product libraries As soon as the permanent Authorization Code has been entered and at regular intervals it is highly recommended that you make a fresh backup of the FileScope Tools library SMZ2 For example to backup the FileScope Tools libraries to diskette Insert a backup diskette in the diskette drive Enter SAVLIB SMZ2 VOL MOUNTED DEV DKT01 FileScope Tools 4 User Manual Appendix B Performance Tips The resources used by FileScope Tools are similar to those of PDM Programming Development Manager
32. set F18 Change Defaults F21 System command F23 More options Select the file you wish to work with by entering the following information on the screen File Enter the name of the file or to see all files type ALL or to see all files with a specific letter type Generic Library Enter the name of the library Position Enter the letter to start viewing files from in the library FileScope Tools 4 User Manual 1 2 File Options Display Display and records in either single or split mode Edit Make changes to records in either single or split mode Journal contents Display Journal Contents Attributes Display File attributes Members Display Member Information Formats Display File Formats Relations Display Database Relations Select Omit Select or Omit fields Keys Display File Keys Fields Display Field List FileScope Tools 4 User Manual 1 3 Display File with editor of your choice Selecting option 1 to display the selected file or if you wish to change the file you may do so from the SHWFC if using FileScope as your file editor screen Show file contents SHWFC Type choices press Enter File Name gt DEMOPF Name PRY SELECT 5 Library SM 1 Name LIBL Member name FIRST Name FIRST SELECT si Show by Key Sequence YES YES NO ViewPoint name xDFT Name DFT NEW SELECT Run ViewPoint Sort Subset pa 8 YES YES NO Allow new file vpt selection Y
33. t indicating that fact Gaps may exist in the sequence numbers of the converted entries These occur because some of the journal entries represent internal system information These entries will not be converted Restrictions The file specified for the database output file must not be journeyed to the same journal Note Do not precede an entry with an asterisk unless the entry is a special value that is shown on the display or in the help information with an asterisk FileScope Tools 4 User Manual Work with Journal Contents WRKJRNC Type choices press Enter File Name xLIBL Member name xFIRST xFIRST Data layout xFLD RCD Journal x CURRENT x CURRENT Library xLIBL xCURLIB Range of journal receivers Starting journal receiver x CURRENT gt CURRENT CURCHAIN Library Ending journal receiver Library XLIBL CURLIB gt CURRENT LIBL CURLIB Starting date and time Starting date Starting time More F3 Exit F4 Prompt F5 Refresh F10 Additional parameters F12 Cancel F13 How to use this display F24 More keys File Name Specify the name of the library of the physical database file whose journal entries are being converted Name Specify the name of the physical journeyed filed Library Specify the library name where the file is located LIBL All libraries in the job s library list are searched until the first match is found Member Name Specify the name of the file member whose en
34. try is being converted for output FIRST Journal entries in the first member in the file are converted for output Data Layout The way data is displayed FLD Display the information in the field RCS Display the information in record format Journal Specifies the journal from which the journal entries are retrieved for conversion and output This is a required parameter CURRENT Use current journal log Library Enter the library where the journal is located LIBL All libraries in the job list are searched until the first match is found CURLIB The current library for the job is used to locate the journal If no library is specified as the current library for the job QGPL is used FileScope Tools 4 User Manual Range of Journal Receivers Specify a range of journals to start and end the output Starting Journal Receiver Specify the name of the starting journal CURRENT The current receiver that is currently attached when starting to convert journal entries is used CURCHAIN The journal receiver chain that includes the journal receiver that is currently attached when starting to convert journal entries is used This receiver chain does not cross a break in the chain If there is a break in the chain the receiver range is from the most recent break in the chain through the receiver that is attached when starting to convert the journal entries Library The name where the journal receiver is located LIBL
35. ue1 amp test amp value2 amp true amp false Example IF amp PRICE GE200 1 0 The IFAND function returns a value based on the result of an AND relationship between two tests Format IFAND amp value1 amp test1 amp value2 amp value3 amp value3 amp test2 amp value4 amp true amp false Example IFAND amp PRICE GS200 amp QTY LT 500 1 0 The IFOR function returns a value bases on the result of an OR relationship between two tests Format IFOR amp value1 amp test1 amp value2 amp value3 amp test2 amp value4 amp true amp false Example IFOR amp VEND EQ 50 amp VENDCLASS EQ T YES MO FileScope Tools 4 User Manual 1 6 Service Screen By entering F13 from the data screen access is made to the service screen 14 records Show file SM21 DEMOPF contents Mbr DEMOPF DEMO ITEM MASTER FILE Select one of the following Fmt ITEMAS Vpt NEW SUBSET Structured style 31 36 files support SUBSET Advanced style SUBSET Free style 51 File information SORT key Deactivate SUBSET SORT 61 Multi session manager Remove SUBSET SORT OPNORYF Statistics 71 Multi file manager Join EXPORT OPNQRYF statement T 2 3 4 D fs 8 H 81 Report Generator 91 File Conversion Y27K EURO Print multiple records Print single record Print Record Structure Selection __ F3 Exit F12 Cancel F22 Command The service screen offers access to services provided by the product including Subset Print
36. your current file editor and FileScope Tools This allows for easy access between the two programs without the need to close either the program or re type commands If you are using a different file editor than FileScope then you will need to configure FileScope Tools for that editor This can be done in the Maintenance are of FileScope Tools 6 3 Maintenance The maintenance area of FileScope Tools allows you to fine tune the way FileScope Tools will work for you Define FS Tools global defaults 20 07 00 13 26 37 General Enable accented letters Y Yes N No Right to left system Y Yes N No DBCS system N Y Yes N No Exit list on Enter Y Yes N No File Editor Substitution amp L lib amp F file File editor name amp libraries FileScope Libraries to add NONE NONE Main Menu command SIRFS Display command SHUFC amp L 8F Edit command CHGFC amp L 8F Work with Views command WRKFSYPT SE 80 Release ID 61 0 99 11 24 230 Authority Code 100008348222 44K1246 510 2118 F3 Exit F12 Cancel F22 Authority Code General Set the general defaults of how FS Tools works with operating environment Enable accented letters Allow for European characters a Select Y to accept these characters Right to left system Allow for Hebrew niw Select Y for Right to Left support DBCS System Supports Double Byte Character Set found in Japanese and Chinese programming code Exit list
Download Pdf Manuals
Related Search