Home

OPEN SYSTEMS® Accounting Software Software Development

1. Select Print Diskette Labels from the System File Maintenance menu The function screen appears Bi 0sAs To cai Dat Pet Help Lakeal ID Lira 1 Lin Lire Lira 4 Lint 5 Lite amp Format Se Biake be bisks Verzion JA edd Lebtal Deta SL MDS Print Piaketts Labels CEAS iccounta Becmivable VER VETPET G 8 PRIGLIKHAL COP Tt RORETMG OPT FROQUCTION COFT CELE DOPE Labela Ja Labals Field Label ID utpa devica Ficinta Descriptions Enter the ID of the label that you want to add or modify Software Development Utilities User s Manual BCR avies Fiils Hing 2 21 Print Diskette Labels System File Maintenance 2 22 Field Copy From Line 1 6 Format Disks Size Offset Set 1 5 Version QA Round Label Date Print Command bar Output device P rinter F ile S creen E nd Descriptions If the label ID you entered is not on file you are prompted for an ID of a label you want to copy Enter the lines of text you want on the diskette label You can use the print time substitutions displayed at the bottom of the screen DAT FMT RND SET and VER They are substituted at print time with the entered label date diskette format QA test round label set description e g Original Copy Working Copy and version Enter the diskette format DOS or TAR Enter the number of diskettes for each media size for
2. Software Development Utilities User s Manual Add Change Reserved Words Use the Add Change Reserved Words function to add or update the file or reserved SQL words This file is verified when you add a field name to a file Starting the function Select Add Change Reserved Words from the Data Dictionary menu The function screen appears B ozas tina Add Charya Perarvud Borda Reserved Bord bite BESTE L pe Loe SL DATE r Verification FPreerr lt Pgin gt to proceed Field Descriptions Reserved Word Enter the reserved word that will be used to validate all fields Description Enter a description for the reserved word Software Development Utilities User s Manual 6 37 Add Change Reserved Words Data Dictionary Check your entries If you find mistakes move the cursor to the fields you want to change or use the Abandon F5 command to start again from the beginning of the screen When everything is correct use the Proceed PgDn command to save the record Then create update another data dictionary or use the Exit F7 command to return to the menu 6 38 Software Development Utilities User s Manual Audit Field Names for Reserved Words Use the Audit Field Names for Reserved Words function to validate an application for reserved words or check all applications Starting the function Select Audit Field Names for Reserved Words from the Data Dictionary menu The function screen appears isa To
3. i ETLE ARI Lasert Pelete leer Diil Gave REBEL Prim Biacuze Ikip Software Development Utilities User s Manual 3 25 Audit Program Remarks Software Audit When you select eXecute on the filelist entry screen the following prompt appears Field Descriptions Output device Printer Enter P to print the Audit Program Remarks report T to Terminal File End display it on the terminal screen F to file it or E to exit to the menu Audit Program Remarks report Cross reference of C P4 PROGIN INACI Page 1 xxk Line references 102 0102 REM IF FILES_OPEN THEN GOTO 0500 End of Report 3 26 Software Development Utilities User s Manual Audit Template Usage Use the Audit Template Usage function to produce a report showing possible invalid string template variables in application programs The program looks for string template references and verifies them against the OSTPL files Use the filelist entry screen to enter the list of programs you want to audit Starting the function Select Audit Template Usage from the Software Audit menu The function screen appears EIAS Tou Be Satins Eat Pit Hen dudit Template Uragua Til llat Sntey EALEISS i ATIS AR ESETT D elate Clia ET bave BE Laad Prim Biacuze Teip Software Development Utilities User s Manual 3 27 Audit Template Usage Software Audit 3 28 When you select eXecute on the filelist entry screen the following prompt
4. 10 CITE city c 15 STETE Stace z z ZIR OODE Zip Coda it cOUMTET Coke comin y Cole STENT iptent Loa i CORTACT Canimi G za FROHE AREA COGE Thone kras Coda z 3 LOCAL PIHE Bic Lorel Fhorsa Ghosber 7 PAX AFEA CODE Tae irea Code i Pix LOCAL PURER fon Looal Mumber s jt Liae He MODLI of OFL Entar adic kppead Urita Goro Command bar Definitions Enter edit Move the prompt gt to the line you want to edit and press Enter Append Press A to add a field Write Press W to write the changes to the selected filename If everything is correct use the Exit F7 command to return to the Data Dictionary menu Software Development Utilities User s Manual 6 17 Fields Data Dictionary Fields Line ltem Entry screen When you elect to edit or append a field the Edit Field screen or the Append Field screen appears Firids Hicricoszy 1 Fila Size 105 Fils Wares acd Comcomac Fila Sate Size i025 Edit Poeid Pisida Haste 3 fon Ticld IF STORER E Hage caption Cogtomec ID Field Type Character umacic Typs Werleble Langch TEJ Pisld Tareidnacor in Field Length a rray Elawants L EU Heee CUATONIR_ID Varlabie O34 Template CPST Field Descriptions Field ID Enter the ID you want to use for the field These words are checked against a reserved word file A warning appears if you enter a reserved word A reserved word is a key word from a third party SQL language that cannot be used f
5. Abandon F5 command When your entry is correct use the Proceed PgDn command to save the record Then enter another extension or use the Exit F7 command to return to the menu Software Development Utilities User s Manual Copy File s to Dictionary Use the Copy File s to Dictionary function to copy file index and field definitions from one BASIS Data Dictionary to another Starting the function Select Copy File s to Dictionary from the Data Dictionary menu The function screen appears E iza tou caine CS Fii bjp T Sopp Filaj to Ficticmary Fro FPiotiorary i To DISt Loar F EF Copy 1 ALl ApplLiGetida File Specitea File I7 Hase Dictionacy Teclas r Verification Feest lt Pgtn gt to proceed Field Descriptions From Dictionary Enter the source dictionary extension you want to copy file information from To Dictionary Enter the destination dictionary extension you want to copy file information to Software Development Utilities User s Manual 6 11 Copy File s to Dictionary Data Dictionary 6 12 Field Descriptions Copy If you want to copy all application files enter 1 If you want to copy specific application files enter 2 If you want to copy the base dictionary tables enter 3 Application ID If you entered 1 enter the ID of the application you want to copy file information from All files fields and indexes defined with this application ID will be copied to the desti
6. Be ging ES Pot Help T Judit Field ame foc Permerwud Borda Dict loanarey Lee Applicabicg ID AP Fila Hema From me otek arice CPhciztec p F evier F ila 3 ccesn Bj za Field Descriptions Dictionary The current data dictionary selection is displayed Application ID Enter the ID of the application you want to create files for or leave this field blank to verify all files for reserved words File Name From Thru Enter the range of filenames you want to verify reserved words for or press Enter at From Thru to select all files Software Development Utilities User s Manual 6 39 Audit Field Names for Reserved Words Data Dictionary Command bar Definitions Output device P rinter Press P to print the file layouts R to preview the layouts F p R eview File S creen to file them S to display them on the terminal screen or E E nd to exit to the menu Audit Field Names for Reserved Words List sample 12 19 1999 Builders Supply Page 12 39 PM Audit Field Names for Reserved Words File ID Field Name Description of Reserved Word DESC DESC DESC DESC DESC DESC TIME DESC MI DESC TRAN DESC DESC DESC DESC DESC TRAN TRAN TRAN DESC DESC End of Report 6 40 Software Development Utilities User s Manual Reserved Word List The Reserved Words List contains all the words that are reserved SQL words Starting the function Select Rese
7. E to exit to the menu Option Linkage List report 12 11 1999 Builders Supply Page 1 Option Linkage List Accounts Receivable S O0O U RCE DESTINATION APPLICATION SWITCH SEQUENCE APPLICATION SWITCH PREFIX NUMBER NUMBER PREFIX NUMBER IN 03 00 AR 03 IN 03 01 AR 03 IN 04 00 AR 04 IN 16 00 AR 25 End of Report 2 12 Software Development Utilities User s Manual Define Mkeyed Files You can use the Define Mkeyed Files utility to define redefine and store single or multikeyed Mkeyed file definitions and to create files based on these definitions Starting the function Select Define Mkeyed Files from the System File Maintenance menu The function screen appears Bsa To sing ot Pint Help Da ira Akeyed Files Eile 1D ARGUE Lopy LIEUE FOL Hemirds Desorigeion JA Costower File Rescrd Sis Tea Ree SS AS Sens Daed 16 gz F EULI 1 C2228 10 4 1 1 8 P Sati de ie i FEIE IGIENE TEJ 4 5 234 6 1 1 6 BEER SIL DE LEG E ce eld ee T G1 284 2 4 3 51212 1 1 4 1c 11 ij 13 14 14 Enterwedit Copy Movu Trap cReste Ieoc Brite Field Descriptions File ID Enter the ID of the file you want to create or update Description Enter a description for the file you are working with of Records If the file is dynamic leave this field blank If the file is not dynamic enter the maximum number of records the file needs Software Development Utilities User s Manual 2 13 Define
8. Information System File Maintenance Field File Name Create Flag Description Header Descriptions Enter the name of the file you want to work with If the file is company specific enter a lowercase x to indicate the placement of the company ID When you enter the filename the system looks for a file with this name in the current company The file information is then updated and displayed using the existing file as a template If no file exists use the Define Mkeyed Files function to create the file Then select that file through this function the key definition information will be updated If you want this data file to be created during the Create Data Files function in Resource Manager enter a number 1 9 If this file should not be created enter 0 If this file exists the file type bytes per record active keys and key definitions appear Enter a description of the data file This description will appear in the Data File Information List and in the inquiry windows This field cannot be accessed unless the file is an indexed file Enter the name of the header record Check your entries If you find mistakes move the cursor to the fields you want to change or use the Abandon F5 command to start again from the beginning of the screen When everything is correct use the Proceed PgDn command to save the record Then enter another file or use the Exit F7 command to return to the menu 2 6 S
9. Mkeyed Files System File Maintenance Field Record Size Command bar Enter Edit Copy Move Swap cReate Desc Write Descriptions Enter the maximum number of bytes you will need for one record in the file Definitions Press Enter to enter or edit the key definitions for the current key number Press C to copy the key definitions for the specified key number to the current key number Press M to move the contents of the current key definitions to a new key number Press S to swap the contents of the current key definitions with another key number Press R to create a file in the current company with the specified key definitions Press D to move the cursor to the Description field in the header Press W to write the key definitions to SDFILES When you re finished use the Exit F7 command to return to the menu 2 14 Software Development Utilities User s Manual Create xxCNVT File Use the Create xxCNVT File utility to create an installation file for each application The file will contain a record for each data file that exists for the specified application code During installation the application specific file is merged into the OSCNVT file This file is accessed when a function needs to verify the version number Starting the function Select Create xxCNVT File from the System File Maintenance menu The function screen appears E As Too Fiep at Pent Hap Cramte x
10. SETTRACE and other debugging verbs In addition this audit will look for GOTOs or GOSUBs that go to nonexistent line numbers After you select the output device use the filelist entry screen see page 1 7 to enter the list of files you want to audit A report that shows the violations is then printed Analyze the list determine which items are problems and repair the programs See the list below for code violations Do not use these verbs Some of them are used by special programs in the SD Utilities and the Resource Manager but they are limited to system structure setup and program maintenance functions Normal accounting processing does not need any of them BEGIN DISABLE EXECUTE RESET SETOPTS BYE DUMP MERGE RMDIR SETTIME CHDIR ENABLE PREFIX SAVE SETTRACE CLEAR ESCAPE RELEASE SETDAY START COPY ESCOFF SETERR STOP DELETE ESCON RENUM SETESC All programs must have an error trapping section If the program allows user input it should have the GENERROR routine If the program has no user input it should have the GENLOCK routine Failure to follow these standards may mean that the application does not work in multiuser operation Software Development Utilities User s Manual 3 11 Audit Programs Software Audit Starting the function Select Audit Programs from the Software Audit menu The following prompt appears Bosas tina BE ceiege DE Pent Hel Cutpot device Pointec Tacrirel Fila Ered Command bar Definiti
11. Utilities User s Manual 6 23 Indexes Data Dictionary Command bar Definitions Enter edit Move the prompt gt to the line you want to edit and press Enter Append Enter A to add an index Change view Enter C to see the keys in the file definition syntax Write Enter W to write the changes to the selected filename If everything is correct use the Exit F7 command to return to the menu If you made changes you are prompted to save the changes before you exit 6 24 Software Development Utilities User s Manual Data Dictionary Indexes Indexes Line Item entry screen When you elect to edit or append an index the Edit Index screen or the Append Index screen appears E iaai mini Lndenaa I Edit Limes inis o Fay Minbar G Beg Fiela bestr bpl bon VRE Fld Pos Len DSS Unig Pis O04 SORITCAER ITD Customer TE E i i ano W Fam Field Descriptions Index ID If you are adding an index enter an ID to identify the key If you are editing an index the index ID of the selected key is displayed Seq The sequence number is assigned for each segment of the key When you append a segment the sequence number is displayed Field Enter the field name you want to use in the segment or leave the field blank if the segment consists of more than one field If you enter a field name the description type field position and length appear Software Development Utilities User s Manual 6 25 Indexes Field D
12. appears Field Descriptions Output device Printer Terminal File End the menu Audit Template Usage report Enter P to print the Audit Template Usage report T to display it on the terminal screen F to file it or E to exit to Cross reference of C P4 PROGIN INACI xxx x Missing Template Field Names INOQT 1UQ1 4550 INVE DESCR 1570 xxx Missing Template Names INGET 420 510 520 1240 1250 1290 1370 INGET 1380 End of Report Software Development Utilities User s Manual Replacement Programs Overview Replacement Programs Replacement Programs List Software Development Utilities User s Manual 4 3 4 5 4 7 4 1 Overview Use the functions on the Replacement Programs menu to set up and maintain a database of programs shared among applications For example in standard OSAS Accounts Receivable the program ARAGE is overwritten by another version of ARAGE when Time Billing is installed Tracking these programs is important in application development When you select Replacement Programs from the Development Utilities menu this menu appears E iaai tini giing E fimi ijp Oligas 19993 cippiiny H Sil AR B in feni Dave lopmant Mtilitiss _ Replacement Programa Repleterent Petras Repiagement Progra List T a ESTERS CR EU ey BOE Use the Replacement Programs function to enter the base programs that are modified by a vertical application or a cus
13. by executable code Use the Audit Template Usage function to produce a report showing possible invalid string template variables in application programs Software Development Utilities User s Manual Print CRCs The Print CRCs function calculates the CRC Cyclic Redundancy Check numbers for all the files in a volume You can use this function to create output files to be used later in the Compare CRCs function The Print CRCs report generates a unique hexadecimal checksum for each file The CRC number is used as a fingerprint for version control Any change in a file the addition or deletion of a character or substituting a comma for a semicolon will change the CRC number You will generally use the Print CRCs report in conjunction with the Compare CRCs function By producing the Print CRCs report and storing it in a file you can do bulk comparisons of media and let the system highlight the differences Starting the function Select Print CRCs from the Software Audit menu The function screen appears E Ai Tini aie CS Pet Bel T Frint OFca Appligsrt iga ID IR Yarsion amp 4 00 at LT Disi Bice GS 1 20 Bifzecbhorcy Hemet SE LSOOCRS BRS 112 Bo Guipet dowice ing Software Development Utilities User s Manual 3 5 Print CRCs Software Audit 3 6 Field Application ID Version Command bar QA Round Disk Size Directory Name Output device P rinter Desc
14. everything is correct use the Proceed PgDn command to save the record Then enter another replacement program or use the Exit F7 command to return to the menu Software Development Utilities User s Manual Replacement Programs List The Replacement Programs List shows information stored in the SDPRMOD DAT file on modifying applications and replaced programs Starting the function Select Replacement Programs List from the Replacement Programs menu A selection screen appears E Ai Tini ding DS Pet hjp F Feglecement Frogcars List Pick Vermion From Thre ALT Plog Agp Frai Thre Progar Meme From The Frist By i Vereion 2 Aoditving ips 3 Peogren Here a Dutput device CPpeiztec p Fj evier Fpile 3 cresn Bj a Field Descriptions Pick Version From Thru Enter the range of version numbers whose information you want in the report Pick Modifying App From Enter the range of modifying applications whose Thru information you want in the report Pick Program Name From Enter the range of program names whose information you Thru want in the report Software Development Utilities User s Manual 4 7 Replacement Programs List Replacement Programs 4 8 Field Descriptions Print By Select the item by which you want to organize the report Command bar Definitions Output device P rinter Press P to print the Replacement Programs List F to file it F ile S cre
15. the current application Enter the size of the media such as 1 2M for 5 1 4 inch disks and 1 44M for 3 1 2 inch disks Enter the print offset that determines the position to begin printing on the labels Enter the description for each label you want to print Up to five copies of each label will be printed depending on whether you enter a description for each set Enter the version number of the application Enter the quality assurance round if the media is still in testing Enter the date the media was created Enter 1 to print 5 1 4 inch media labels or 2 to print 3 1 2 inch media labels Definitions Select P to print the diskette labels F to file them S to display them on the terminal screen or E to exit to the menu Software Development Utilities User s Manual Edit Data File Contents Use the Edit Data File Contents function to add or change records for files defined as string templates through Data Dictionaries Starting the function Select Edit Data File Contents from the System File Maintenance menu The function screen appears Bizas too aie CS Pet Ejip Edit Tate Fila Contacts Filz Pane Eey Eny Marber a Poe daion bi Field Talus 123456 7TE90 Lae PRIS SS STE LTL Lire Ho al i ES EE Field Descriptions File Name Enter the name of the file whose contents you want to view The contents of the first record appear including the value stored in the key number se
16. the Tables function to build the system tables To enter and store diskette label information and to allow printing of five sets of labels at once use the Print Diskette Labels function To display edit delete or add records in a data file use the Edit Data File Contents function This function displays each field in a data file and the contents of the field Software Development Utilities User s Manual Data File Information Use the Data File Information function to update the xxDATA yyy file xx represents the application ID and yyy represents the version for the application The xxDATA yyy file contains data file information for file creation and conversion Starting the function Select Data File Information from the System File Maintenance menu The function screen appears Eiaa Ton Geis Dat Pent Help dppliesacien ID Version File Heme Create F leg Fila Type Lagictel k p Flee Husker of Feoords Eey Pafinitions besriprior Heer m Vecificacica Field Application ID Version Software Development Utilities User s Bete Fale Informatica AR T T ALPES Ua 1 PRoes pEr Hemari igrive Keya AR caanoe File L Feest lt Pgtn gt to proceed Descriptions Enter the ID of the application you want to work with Enter the version number of the application to update file information There is a separate xxDATA yyy file for each version yyy of an application xx Manual 2 5 Data File
17. tini cei DE Pint jip Convert dice XXVIMD File to 4 304 cppliceticae AR r Verificaticz Freaa FT to erit Field Descriptions Application Enter the ID of the application you want to convert If the window file is already at the 4 5x level a message appears to tell you that the file does not need to be converted Check your entry If you want to change it move the cursor to the field or use the Abandon F5 command Software Development Utilities User s Manual 5 5 Convert 4 xx xxWIND File to 4 5x System File Conversion When your entry is correct use the Proceed PgDn command to save the record Then convert another application or use the Exit F7 command to return to the menu 5 6 Software Development Utilities User s Manual Convert 4 5x xxWIND File to 5 0x This utility converts 4 5x and 4 6x window definition files to the 5 1x format Starting the function Select Convert 4 5x xxWIND File to 5 0x from the System File Conversion menu The function screen appears B ias too oy ain CS Fit Hep Comar d twe Baxeel Film to 5 006 Teyirey to Opan Ber Field Descriptions Application ID Enter the ID of the application you want to convert If the window file is already at the 5 0x level a message appears to tell you that the file does not need to be converted Check your entry If you want to change it move the cursor to the field or use the Abandon F5 command Software Develop
18. type with changes enter Y if not enter N 6 20 Software Development Utilities User s Manual Data Dictionary Fields Field Descriptions Field Length If you want to update the field length with changes enter Y if not enter N RW Name If you want to update the RW name with changes enter Y if not enter N Notes If you want to update the notes with changes enter Y if not enter N Check your entries If you find mistakes move the cursor to the fields you want to change If you are prompted for each field the next field will appear if you are done the prompt will return to the filename Software Development Utilities User s Manual 6 21 Indexes Use the Indexes utility to define the keys used in OSAS Mkeyed data files Starting the function Select Indexes from the Data Dictionary menu The function screen appears eA TA caine DS Pt hp r Induna Dicti Hary FLL FLIE Sige File Hara incU oft Dice EHUN Rey DETHALGISH 0 CHATOHIR_ID 1 PEP COnME CUSTOER_ IT PJ PLISTRIESTE Oat eO WS Pose Lb 1 COATES HEAE COSTORES ID COITORER_CLISSscusSTORER_ ID 5 SALES PEF_ID lec Tone ID 44210 AoA TOER Te 7T JPATE COITYHCISTONER_ID Kap Ho j 00001 of 00O Entec edit Append Change view Feite Field Descriptions Dictionary The current data dictionary selection is displayed File Name Enter the filename you want to work with The file size and soft size appear Software Development
19. 51BBS JOACC 2 Prg H MAINT 51NEW 51J30 PROGJO C MSOFFICE WINWORD J JOACCEM PUB 9 Prg H MAINT 51NEW 51J0 PROGJO C MSOFFICE WINWORD J JOACJ 1 Prg H MAINT 51NEW 51JO PROGJO C MSOFFICE WINWORD J JOACJ1 4 Prg H MAINT 51NEW 51JO PROGJO C MSOFFICE WINWORD J JOACJCON 3 Prg H MAINT 51NEW 51JO PROGJO C MSOFFICE WINWORD J JOACJLN1 PUB 6 Prg H MAINT 51NEW 51JO PROGJO C MSOFFICE WINWORD J JOACJVEW PUB 1 Prg H MAINT 51NEW 51JO PROGJO C MSOFFICE WINWORD J JOACT 0 Prg H MAINT 51NEW 51JO PROGJO C MSOFFICE WINWORD J JOACTFM PUB 9 Prg H MAINT 51NEW 51JO PROGJO C MSOFFICE WINWORD J JOADJ 9 Prg H MAINT 51NEW 51JO PROGJO C MSOFFICE WINWORD J JOADJ1 8 Prg H MAINT 51NEW 51JO PROGJO C MSOFFICE WINWORD J JOCJP 2 Prg H MAINT 51NEW 51JO PROGJO C MSOFFICE WINWORD J JOCJT 2 Prg H MAINT 51NEW 51JO PROGJO C MSOFFICE WINWORD J JOCMNT PUB 1 Prg H MAINT 51NEW 51J0 PROGJO C MSOFFICE WINWORD J 3 8 Software Development Utilities User s Manual Compare Programs Use the Compare Programs function to compare the changes between two programs If you select more than one program for comparison you will be asked for the directory to search Only the programs that exist in both directories will be compared The file list management utility is used to create the list of programs to be compared Starting the function Select Compare Programs from the Software Audit menu T
20. A yyy file is updated with the resulting FID and FIN information Starting the function Select Create File s from Data Dictionary from the Data Dictionary menu The function screen appears Bozas too Geige Eat Pent Help ceeste Files icona fete Dictionary Dicticaary Applicaeilon I0 AF Version Mober 6 00 Ceealet i ill dtplinardon Files Specific Fila File Kors r Verification Field Descriptions Dictionary The current data dictionary selection is displayed Application ID Enter the ID of the application you want to create files for Software Development Utilities User s Manual 6 35 Create File s from Data Dictionary Data Dictionary 6 36 Field Descriptions Version Number Enter the version number of the data file you want to create This number will update the xxDATA yyy file for application xx and version yyy Create If you want to create all application files press 1 If you want to create a specific file press 2 File Name If you elected to create a file enter the name of the file you want to create Check your entries If you find mistakes move the cursor to the fields you want to change or use the Abandon F5 command to start again from the beginning of the screen When everything is correct use the Proceed PgDn command to save the record Then create update another data dictionary or use the Exit F7 command to return to the menu
21. CHNT File ApPLLCALIJA Doe AB VEER Loe Sa 10 Fils Hee kACO ra po be lere m VeritLoerio8 Press lt Pgtn gt to proceed with mauve Field Descriptions Application Code Enter the ID of the application you want to work with Software Development Utilities User s Manual 2 15 Create xxCNVT File System File Maintenance 2 16 Field Descriptions Version Press Enter to accept the most recent version that is installed or enter a different version number There is a separate xxDATA yyy file for each version of an application yyy Enter the version of the application that you want to update the file information for File Name Enter the name of the file you want to add to the xxDATA yyy file Check your entries If you find mistakes move the cursor to the fields you want to change or use the Abandon F5 command to start again from the beginning of the screen When everything is correct use the Proceed PgDn command to save the record Then enter another file or use the Exit F7 command to return to the menu Software Development Utilities User s Manual Create xxCNVT HDR file Use the Create xxCNVT HDR File utility to create a conversion header file containing all the conversion steps for this application Starting the function Select Create xxCNVT HDR File from the System File Maintenance menu The function screen appears Bizas tina ating DS Pt hp Cresta xxOMWT HOR File ipplicerion TD i
22. F Terent Fereion 3 bo SSO a oe pe Bove filsa po this comersicon acep 4 0 Y i211 Y a5 T 5 0 a 5 1 Hi ES y r Verification Pome lt Pgtn gt to proceed Field Descriptions Application ID Enter the ID of the application you want to work with Version Enter the version number of the application to update file information There is a separate xxDATA yyy file for each version yyy of an application xx Software Development Utilities User s Manual 2 17 Create xxCNVT HDR file System File Maintenance 2 18 Conversion Steps Converting your data from older versions of OSAS to 5 20 is a step by step process When converting files from older versions to 5 20 the conversion process moves the data to subdirectories at each step By entering Y or N in the move files field the xxCNVT HRD file directs the conversion process By entering Y in the move files field the data is placed into the appropriate subdirectory To not copy the data to the subdirectory enter N Always enter Y in the final directory In the example data is being converted from version 4 00 to 5 20 The program creates the appropriate number of subdirectories converts the 4 0 data and places it in the 4 1 subdirectory The 4 1 data is then converted and placed into the 4 5 subdirectory and finally converted and placed into the final destination directory Software Development Utilities User s Manual Tables Use the Tables functi
23. L COLUMN SQL COMMIT SQL COMMITTED SQL COMPUTE SQL CONFIRM SQL CONNECT SQL CONNECTION SQL CONSTRAINT SQL CONSTRAINTS SQL CONTINUE SQL CONTROLROW SQL CONVERT Software Development Utilities User s Manual Data Dictionary
24. M ITEM ITEM ITEM INLP INPP INPS INAI INBN INCJ INCS INCT INHI INHS INKY INLD INLH INLP INLS INLT INQL INQT INRQ INSH INSN INTL INTR INUM INUP INVE INVI INXT Discrepency in field type or length Adjustment Amount Adjustment Amount Adjustment Amount Item Item Item Item Item Item Item Item Item Item Item Item Item Item Item Item Item Item Item Item Item Item Item Item Item End of report Page 9999 Format Notes ID ID ID ID ID ID ID ID ID ID ID ID ID ID ID ID ID ID ID ID ID ID ID ID ID N N N c C C C c G C G C c c c C E C c c G G C c 14 INUP 14 INUP 14 INUP 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 25 20 20 20 20 20 20 20 20 Press P to print the file layouts R to preview the layouts F to file them S to display them on the terminal screen or E to exit to the menu Software Development Utilities User s Manual Create Update Template File Use the Create Update Template File function to create or update the string template files OSTPL or xxTPL xx replaces the application ID Starting the function Select Create Update Template File from the Data Dictionary menu The function screen appears Bizas tini gai at Pint jip Cremte Opiate Tanp lata File Dictionary Applicat Lon AF File Ware From Thru Opdete kpplicetica Destination Pirertoryi C OL pron
25. OPEN SYSTEMS Accounting Software Software Development Utilities User s Manual PN 2810 SD60 1995 1997 1999 by Open Systems Holdings Corp All rights reserved No part of this manual may be reproduced by any means without the written permission of Open Systems Holdings Corp OPEN SYSTEMS is a registered trademark and OSAS Resource Manager Resource Manager for Windows and Report Writer are trademarks of Open Systems Holdings Corp BB is a trademark and PRO S5 and Visual PRO S are registered trademarks of BASIS International Ltd Novell and NetWare are registered trademarks of Novell Inc Microsoft Windows Windows 95 Windows NT and MS DOS are either trademarks or registered trademarks of Microsoft Corporation Adobe and Acrobat are registered trademarks of Adobe Systems Inc TrueType is a registered trademark of Apple Computer Inc Open Systems Accounting Software for UNIX uses PKUNZIP utilities from Ascent Solutions Inc 9009 Springboro Pike Miamisburg OH 45342 Phone 937 847 2374 Internet www asizip com Printed in U S A This manual is recyclable October 1999 Document No 2810 SD60 This document has been prepared to conform to the current release version of OPEN SYSTEMS Accounting Software Because of our extensive development efforts and our desire to further improve and enhance the software inconsistencies may exist between the software and the documentation in some instances Call your customer support r
26. OSAPPL and xxDATA yyvy files Enter Y to search for additional application programs in the Resource Manager directory path or enter N to select only the application directory If you select N you are prompted for the output device If you entered Y to search the RM path you are prompted for the path The directory path of Resource Manager is displayed from OSAPPL the application information file Press Enter to accept the default or enter a different directory path Definitions Enter P to print the Audit Program Data File Names report F to file it S to display it on the terminal screen or E to exit to the menu Audit Programs Data File Names report 06 13 1999 Audit Program Data File Names Page T 1 13 PM JO Job Cost Rnd 16 File Prefix Program Name JOCD c p4 progJO0 JOCDR JOCD c p4 progJO0 JOCDR1 JODE c p4 progJ0 JODEL JODE c p4 progJO0 JODELC End of Report Software Development Utilities User s Manual Audit Program Remarks Use the Audit Program Remarks function to produce a report showing possible extraneous remarks left in application programs Specifically this program looks for REM statements followed by executable code Use the filelist entry screen to enter the list of programs you want to audit Starting the function Select Audit Program Remarks from the Software Audit menu The function screen appears E Ai To BEEE ating DS Pt bjp Audit Frogoeo Beceerko TLEILaL 2ntey THErisS i
27. SCAT C 2 STAT C 1 ITYP C 1 BUOM C 5 TAXC C 2 PRID C 6 UNIT C 5 C PROD C 12 UD01 C 12 UD02 C 12 UD03 C 12 UD04 C 12 UD05 C 12 UD06 C 12 UD07 C 12 UD08 C 12 UD09 C 12 UD10 C 12 UD11 C 12 UD12 C 12 UD13 C 12 UD14 C 12 UD15 C 12 UD16 C 12 ITMWT N 14 I 6 5 LOTS N 1 KITS N 1 REORD N 1 RSV1 N 1 RSV2 N 1 RSV3 C 1 ISVA C 1 ISVN 2 N 1 0 ab 1 RW Topic No 500 IKNUMSegment sDescription 320 tem ID 339 Description 220 tem ID 32 Sales Category 320 tem ID 26 Price ID 320 tem ID aes Product Line tem ID tem Type Product Line tem ID tem Status tem ID User Defined Field 7 segments Inventory Version 6 00Page IN 3 Section 1 INVExxx IN IN Items Software Development Utilities User s Manual 6 29 File Layouts Data Dictionary tems File Name INVExxx IN Record Size 341 384 File Type Mkeyed Dynamic Number of keys 13 Field No TemplateDescriptionFormatNote ITEM_ID Item ID C20 DESCRIPTIONDescription C35 SALES_CATEGSales Category C2 ITEM_STATUSItem Status C1A Active D Discontinued S Superceded O Obsolete ITEM_TYPE Item Type Cll No 2 Yes BASE_UOM Base Unit of Measure c5 TAX_CLASS Tax Class 200 99 PRICE_ID Price ID C6 DEFAULT_UOMefault Unit of Measure c5 PRODUCT_LINProduct Line USER_FIELD_User Defined Field 01 USER_FIELD_User Define
28. a File Names Audit Program Remarks Audit Template Usage Software Development Utilities User s Manual 3 3 3 5 3 7 3 9 3 11 3 15 3 17 3 19 3 21 3 23 3 25 3 27 3 1 Overview Use the functions on the Software Audit menu to check programs for violations of OSAS standards and for common programming errors such as unused line labels and invalid string template names When you select Software Audit from the Development Utilities menu this menu appears E iaai tini giing E fmi ijp ijdd 1999 impany H Sil AE Sep fave lopmant Militis J Sotteare bedir Asin Prize CROCS Doare Cha Compare Frogr emm WORSE PES aa ko it weF TILES TET coast Be Varsisn Level AIE Bigmaitire Lines kolit Lire Labels kudiz Frograr Date File Haras ku Pragan Bemrko At Templare Cee T PEN ERS A Une Soe Use the Print CRCs functions to print and calculate CRC Cyclic Redundancy Check numbers for all the files in a volume or round This information should be sent to a file in order to run a compare from one version to another Use the Compare CRCs function to print the differences between the CRCs calculated for each volume To compare CRCs enter the names of the output files from the CRC reports that you want to include in the compare Only the names of programs with differences are printed in the Compare CRCs report Software Development Utilities User s Manual 3 3 Overview 3 4 So
29. ant a report to include information only about vendor ACE001 enter ACEOO1 at both From and Thru If you want the report to include information about only vendors that start with CO enter CO at From and COZZZZ at Thru Each field where you enter information on a report function screen usually restricts the overall output of the report For example if you leave the Vendor ID From and Thru fields blank the report will contain information about all the vendors But if you enter invoice 100 in the Invoice Number From and Thru fields and invoice 100 is assigned only to vendor ACE001 the report includes information only about vendor ACE001 Output Device Report function screens offer four output options printer file screen and end e When you need a hard copy of a report press P and either accept the printer that appears or enter the code for the printer you want to use 1 8 Software Development Utilities User s Manual Introduction Conventions If applicable press S if you want the report to be in standard size print or C if you want it to be in compressed print If you want to stop printing after it has begun press Ctrl Break e If you want to save the report as a data file for example to include it ina word processed report in CR LF format press F The data path for the workstation including the default drive appears if it is specified in the Defaults function Enter the filename and file extension using no more t
30. d Field 02 Inventory Version 6 00Page IN 1 Table of Contents End of Report 6 30 Software Development Utilities User s Manual Field File Cross Reference List Use the Field File Cross Reference List function to produce a printout by field name across files Use the list to verify the consistency of field names in related files Starting the function Select Field File Cross Reference List from the Data Dictionary menu A selection screen appears EIAS Tou ising Eat Pint Hen f Fial Tile Croar Fafecermwa List Dictionary Fieid ID Fron Thru Fil same Fron Tiru ee by i Figld Hem 2 File Hex Jutpuk device Pheimtec piRlevder Fhile Spccemn Myo Field Descriptions Dictionary The current data dictionary selection is displayed Field ID From Thru Enter the range of field IDs you want to print Filename From Thru Enter the range of filenames you want to print Sort By Press 1 to sort by field name press 2 to sort by file name Software Development Utilities User s Manual 6 31 Field File Cross Reference List Data Dictionary 6 32 Command bar Output device P rinter p R eview File S creen E nd Field File Cross Reference List sample 08 24 99 Field File Definitions Field File Cross Reference List Description ADJA ADJA ADJA ITEM ITEM ITEM ITEM ITEM ITEM ITEM ITEM ITEM ITEM ITEM ITEM ITEM ITEM ITEM ITEM ITEM ITEM ITEM ITEM ITEM ITE
31. e Maintenance from the Development Utilities menu this menu appears B SAs To giing E fini bjp OL gt 1999 hima H tice FE Fain Mri Dewalopeaent Weilitias Syster File Asintenence Data File Informar iona ption Linkage Bath File ADOM Lon Lise ption Linkage Liar gamma Dafines Hkeped Files VOSS Ee SECA File Create cechT HER File Tab lem PEGBE DLSKEthe Labels Edit Dara File Comrence wi Ee Ee TERS Buin iy BODE Use the Data File Information function to maintain the xxDATA yyy file for an application Use the Option Linkage function to maintain the xxSWCH file if an application has an option switch in the OPTxxx record of the xxTB file that should be updated when a switch in another application is changed called a link To produce a list of data files by version number for a range of applications print the Data File Information List Software Development Utilities User s Manual 2 3 Overview 2 4 System File Maintenance To produce a list of option links for one or more xxSWCH files for a range of applications print the Option Linkage List Use the Define Mkeyed Files function to define redefine and store single or multikeyed Mkeyed file definitions and to create files based on these definitions Use the Create xxCNVT File utility to add a record for each data file in an application along with the version number This will be merged into the OSCNVT system file during installation Use
32. e file If the file is not dynamic enter the maximum number of records in the file If the file is dynamic press Enter to accept the default 0 If the file is single keyed enter the key size for the file Enter the FILE ALL element the file is usually opened on If the file has an associated Report Writer topic number enter that topic number Enter the long filename for the file Use xxx to designate the file as a company specific file Enter the application ID the file belongs to Check your entries If you find mistakes move the cursor to the fields you want to change or use the Abandon F5 command to start again from the beginning of the screen When everything is correct use the Proceed PgDn command to save the record or use the Exit F7 command to abort the line item entry area Software Development Utilities User s Manual 6 15 Fields Use the Fields function to define the fields in the OSAS data files String templates and the GENERAL Report Writer s data dictionary files are built from this data Starting the function Select Fields from the Data Dictionary menu The function screen appears Ficide Hicticoery l Fila Siza 105 Fils Hass dace Comcomec Tils oft Sir toes fisia Hart Peor bpl bos THRE bea Hotes AUSTERO Cushomec IF ei IT CUSTOUREF_ HEME Cumpomare Hama E ia abrang LIRE L idirsam Lime i E Ia DPS RAS LINE idirsaa Lime amp id Pars Link ibinta Line amp 6
33. ed the menu appears Software Development Utilities User s Manual 6 7 Build Shadow Dictionary Data Dictionary 6 8 If you have previously created a Shadow Dictionary the following message appears Shadow dictionary already exists Do you want to re create it Enter Y to re create the Shadow Dictionary Enter N and then the Exit F7 command to return to the menu Software Development Utilities User s Manual Create Data Dictionary Use the Create Data Dictionary function to create a set of data dictionary files The files can have any 3 character extension for identification purposes In order for the data dictionary files to work with the ODBC drivers the dictionary files must have the extension 1 However if you are creating installable media you must create data dictionary files for each application These files are merged into the 1 files and OSTPL during installation Starting the function Select Create Data Dictionary from the Data Dictionary menu The function screen appears Eloa Toon etree EP Piu Hole Software Development Utilities User s Manual 6 9 Create Data Dictionary Data Dictionary 6 10 Field Descriptions Dictionary Extension Enter the extension of the data dictionary items you want to create These files are built from the base data dictionary definitions in the OSI files Check your entry If you want to change it move the cursor to the field or use the
34. el Fils Layouts bictianacy Lae ApPplicabionm IO Af Fila oma From TRE ui Bpelicetion Dauecriptica Berdiints Receivable Yersin 01 Peint File Layouts Using i Teap laces 2 Verighlen 1 fotpuk Jarice CPpeiztec p Fj evier Fpile 3 cresn iM 2 Field Descriptions Dictionary The current data dictionary selection is displayed Application ID Enter the ID of the application you want to print file layouts for If you want to print all application file layouts leave this field blank Filename From Thru Enter the range of filenames you want to print Software Development Utilities User s Manual 6 27 File Layouts Data Dictionary 6 28 Field Application Description Command bar Print File Layouts Using Output device P rinter p R eview File S creen E nd Descriptions The description associated with the application ID you entered is displayed Press Enter to accept it or enter a different ID Definitions If you want to print file layouts using templates definitions press 1 If you want to print the layouts with standard variable definitions press 2 Press P to print the file layouts R to preview the layouts F to file them S to display them on the terminal screen or E to exit to the menu Software Development Utilities User s Manual Data Dictionary File Layouts File Layout sample INVEXXX IN IN Items Channel Index 2 Template DIM INVES ITEM C 20 DESC C 35
35. en E nd S to display it on the terminal screen or E to exit to the menu Replacement Programs List report 12 08 1999 Page 1 4 22 PM Replacement Programs List Program App Ver Comment ARACC Qs 4 53 ARACC1 Qs 4 53 ARACC2 Qs 4 53 ARACC3 Qs 4 53 ARACCFM PUB Qs 4 53 ARACPC Qs 4 53 ARACPCFM PUB QS 4 53 ARDATA MRG QS 4 53 ARHELP MRG Qs 4 53 ARPNC Qs 4 53 ARPNC1 Qs 4 53 ARPPT QS 4 53 ARPPT1 Qs 4 53 End of Report Software Development Utilities User s Manual System File Conversion Overview Convert 4 xx xxWIND File to 4 5x Convert 4 5x xxWIND File to 5 0x Convert 4 5x RWxxxD File to 5 0x Convert 4 5x RWxxxl File to 5 0x Convert 4 5x xxHELP File to 5 0x Software Development Utilities User s Manual 5 3 5 5 5 7 5 9 5 11 5 13 5 1 Overview Use the functions on the System File Conversion menu to upgrade your application system files from a past version of OPEN SYSTEMS Accounting Software to a more recent version These functions are unchanged from version 5 0 When you select System File Conversion from the Development Utilities menu this menu appears 2 AS Tiii ging D Pini Bein Olidis 1999 cippany H Sil AF Be hii Peye lopenr Militias Syrtem File Conression Bain conrece 4 2 xxWIND Fila co Txi 4 4 VOMEEL to5kt HEENN File tO 4 4 Conmvect Tx KeFIHO File to 0x 4 EDN Comvece 5x Riess File to 5 02 Commect 4 324 exeBELP File t
36. ename is missing or different all occurrences of the file are printed Before running the Compare CRCs function you must run the Print CRCs report for each volume sending the output from each volume to a file with a unique filename Use the BASIS standard filelist entry screen to enter the names of the output files from the Print CRCs reports that you want to include in the compare Starting the function Select Compare CRCs from the Software Audit menu The function screen appears Bizas rina gate E fint bjp Compare CFCS Appliosrt ioa To AA Varzion amp ann JA Bo irks aoa Reso rk Cuipot dewice Ficinte piFleview Fiile Iih ng Software Development Utilities User s Manual 3 7 Compare CRCs Software Audit Field Descriptions Application ID Enter the ID of the application you want to work with Version Enter the version of the application you are going to compare QA Rounds Enter the quality assurance round for this comparison Re sort If you want to re sort the programs enter Y If you want to leave the programs in the existing order enter N Command bar Definitions Output device P rinter Enter P to print the Compare CRCs report F to file it or E P ile E nd to exit to the menu Compare CRCs report 12 08 1999 Compare CRCs Page 1 4 08 PM APPL JO VER 5 11 Rounds 1 Filename CRC Size Type Source Directory amp CRC file Filename Type Directory C MSOFFICE WINWORD JO
37. enu this menu appears E DAS To ming DS Pet hjp OL iis 1999 Rimpane H SiLly AE Agin Ben Deta Dicticnary Edit COMFIG TPA Cramte Dete Dictionary Build Shea Diet boner Cope Filja co ioriomary Filas Filda Irisean Fila Leyoots Ficids File Crome Beferemee List Create piece Terplace File Create Filaia from Data Gictionacy eee Changa Reserved Words Ade Field Hamsa for Reserved morda Fauarcyved Words List Pio w N j Use the Create Data Dictionary function to create a set of data dictionary files from the template OSI files Use the Build Shadow Dictionary function to create a Shadow Dictionary to aid in data manipulation Use this function only if you use a revision 1 x ODBC driver Use the Copy File s to Dictionary function to copy file index and field definitions from one BASIS Data Dictionary to another Software Development Utilities User s Manual 6 3 Overview 6 4 Data Dictionary Use the Files function to set up and maintain information about the data files used in OSAS programs Use the Fields function to define the fields in the OSAS data files This information is used to create string templates and build data dictionary files for the ODBC Kit application Use the Indexes function to define the keys used in OSAS Mkeyed data files Use the File Layouts function to produce a hard copy of the files in the BASIS Data Dictionary Use the Field File Cross Reference List f
38. epresentative if you encounter an inconsistency Open Systems Holding Corp 1157 Valley Park Drive Suite 105 Shakopee Minnesota 55379 General Telephone 612 403 5700 General Fax 612 496 2495 Support Telephone 800 582 5000 Support Fax 612 403 5870 Internet Address www osas com Contents Introduction Introduction 1 3 Conventions 1 7 System File Maintenance Overview 2 3 Data File Information 2 5 Option Linkage 2 7 Data File Information List 2 9 Option Linkage List 2 11 Define Mkeyed Files 2 13 Create xxCNVT File 2 15 Create xxCNVT HDR file 2 17 Tables 2 19 Print Diskette Labels 2 21 Edit Data File Contents 2 23 Software Audit Overview 3 3 Print CRCs 3 5 Compare CRCs 3 7 Compare Programs 3 9 Audit Programs 3 11 Audit xxFiles TXT 3 15 Audit BBx Version Level 3 17 Audit Signature Lines 3 19 Audit Line Labels 3 21 Audit Program Data File Names 3 23 Audit Program Remarks 3 25 Audit Template Usage 3 27 Software Development Utilities User s Replacement Programs Overview 4 3 Replacement Programs 4 5 Replacement Programs List 4 7 System File Conversion Overview 5 3 Convert 4 xx xx WIND File to 4 5x 5 5 Convert 4 5x xxWIND File to 5 0x 5 7 Convert 4 5x RWxxxD File to 5 0x 5 9 Convert 4 5x RWxxxI File to 5 0x 5 11 Convert 4 5x xxHELP File to 5 0x 5 13 Data Dictionary Overview 6 3 Edit CONFIG TPM 6 5 Build Shadow Dictionary 6 7 Create Data Dictionary 6 9 Copy File s to Dictionar
39. escription Type Fld Pos Len Dsc Uniq Bus Command bar Enter edit Append Description Data Dictionary Descriptions If you entered a field name the description appears from the Field Definitions file If this is a multi field segment enter the description for the segment If the field type is character C appears if it s numeric N appears If you entered a field name the field number where this field is located in the file is displayed if not enter the field number If you entered a field name the starting position of the field is displayed if not enter the starting position of the field in the string you are entering Enter the total length of the field If the field is a descending sort enter Y if not enter N If the field is a unique field enter Y if not enter N If the field is a business math type and to be sorted as such enter Y if not enter N Definitions Move the prompt gt to the line you want to edit and press Enter Enter A to add an index Enter D to edit the index ID description If everything is correct use the Exit F7 command to return to the main Index screen 6 26 Software Development Utilities User s Manual File Layouts Use the File Layouts function to print a copy of the BASIS Data Dictionary files Starting the function Select File Layouts from the Data Dictionary menu The function screen appears Bizas to caine Cot Pent b
40. ftware Audit Use the Compare Programs utility to compare one or more programs and print the program changes This utility is a modified version of the _compare utility from BASIS International Ltd Use the Audit Programs utility to scan programs for potential programming problems which include leaving in ESCAPE SETTRACE and other debugging verbs In addition this audit will look for GOTOs or GOSUBs that go to nonexistent line numbers The Audit xxFILES TXT function performs a cross reference check of the files in the xxFILES TXT file and the files on distribution media Use the Audit BBx Version Level function to check the last level of BBx that each program in the selected directory drive was last saved The Audit Signature Lines function compares program lines against a text file containing the lines you want to validate The primary intent of this utility is to verify that signature lines are correct before running a global update Use the Audit Line Labels function to produce a report showing unused and missing line labels in programs Use the Audit Program Data File Names function to produce a report showing possible conflicts in program and file naming for example the program ARINVO could conflict with the ARINxxx file for company V0 Use the Audit Program Remarks function to produce a report showing possible extraneous remarks left in application programs Specifically this program looks for REM statements followed
41. han 35 characters overall e To view the report on the screen press S If the workstation default for compressed characters is inactive you can select standard mode or compressed mode See your terminal documentation and the section on the termcap file in the I O Reference Guide If the message End of Page appears at the bottom of the report screen you can press Enter to generate the next page of the report If the message End of Report appears at the bottom of the report screen you can press Enter to exit to the menu you selected the report from e Ifyou need to change some selections before you produce the report press E and then press Enter To end the function and return to the menu without producing the report select E and then use the Exit F7 command Software Development Utilities User s Manual 1 9 System File Maintenance Overview Data File Information Option Linkage Data File Information List Option Linkage List Define Mkeyed Files Create xxCNVT File Create xxCNVT HDR file Tables Print Diskette Labels Edit Data File Contents Software Development Utilities User s Manual 2 3 2 5 2 7 2 9 2 11 2 13 2 15 2 17 2 19 2 21 2 23 2 1 Overview Use the functions on the System File Maintenance menu to set up and maintain OSAS system files and files required for application installation You can also print lists of these files and labels for installable diskettes When you select System Fil
42. he function screen appears E 0sa5 Tini iof ating Eat Pmt Ben Progra Tompece Til llat Sntey lt EARLESS i ATIS A ESETT D l te Clia ET bave BSE Laad Prim Biacuze Teip Software Development Utilities User s Manual 3 9 Compare Programs Software Audit 3 10 When you select eXecute on the filelist entry screen the following prompt appears Field Descriptions Program to compare Enter the program name to compare the program in the file against list against If you entered more than one program name in your file list the message Directory to compare against would appear You are then prompted for the output device Command bar Definitions Output device Printer Enter P to print the Compare Programs report T to display Terminal File End it on the terminal screen F to file it or E to exit to the menu Compare Programs report Compare C 511GR J05110RG JOADI to C 511GR PROGJO JOADI Date December 11 1999 Time 05 16 PM change 0010 REM 0 JOADJ 09 05 95 JOB PHASE ADJUSTMENTS to 0010 REM 0 JOADJ 11 27 95 JOB PHASE ADJUSTMENTS S add 0012 REM PTS 8314 add 2235 IF ADJ P THEN LET ADJQ PTDOQTY FI IF ADJ Y THEN LE T ADJQ YTDOTY FI IF ADJ J THEN LET ADJQ JTDOQTY Software Development Utilities User s Manual Audit Programs The Audit Programs function scans programs for potential programming problems which include leaving in ESCAPE
43. lected and a description and the value for each field in the file Key The value of the key for the current record is displayed Software Development Utilities User s Manual 2 23 Edit Data File Contents Field Key Number Precision Command bar Enter edit Add pRecision Key knUm Goto Delete Next Previous Write System File Maintenance Descriptions Key number 0 is displayed To change to a different key number use the knUm command on the command bar To update precision for numeric fields without a user defined mask use the pRecision command on the command bar Definitions Move the prompt gt to the line you want to edit and press Enter Press A to add a record to the file Press R to change the precision on numeric fields without a user defined mask Press K to select the key of the next record you want to access Press U to change the key number you want to search the file on and update the key that is displayed Press G to go to a specific field in the file selected Press D to delete the current record Press N to display the next record Press P to display the previous record Press W to write the changes to the current record Software Development Utilities User s Manual Software Audit Overview Print CRCs Compare CRCs Compare Programs Audit Programs Audit xxFiles TXT Audit BBx Version Level Audit Signature Lines Audit Line Labels Audit Program Dat
44. lelist before you use them You can also use a previously defined filelist The filelist can be saved at any time in the filelist editor A filelist is a list of programs or data files upon which you want to perform an operation The utilities that require a filelist CALL _flist upon invocation See the PRO 5 Utilities Manual for more information about this utility To exit the filelist editor use the eXecute option or the Tab key Here is a sample of the filelist editor used in the Audit Program Remarks function ding E Eii Help it Foogrem Penarka 1 dei Insert Jelete Clemet Edit Bave Pesslve Les Software Development Utilities User s Manual 1 7 Conventions Introduction Wildcards follow UNIX operating system wildcard rules To search all programs in the progAP directory enter lt progAP AP p gt If AP is used only programs with an extension would be selected The p includes only program files in the search Reports To produce a report you must specify the amount of information you want in the report e To produce a report that includes all the available information leave the From Thru fields on the report function screen blank For example if you want information about all the vendors to be in a report leave the Vendor ID From and Thru fields blank e To limit the amount of information in the report enter the range of information in the From Thru fields For example if you w
45. ment Utilities User s Manual 5 7 Convert 4 5x xxWIND File to 5 0x System File Conversion When your entry is correct use the Proceed PgDn command to save the record Then enter another application ID or use the Exit F7 command to return to the menu 5 8 Software Development Utilities User s Manual Convert 4 5x RWxxxD File to 5 0x This utility converts 4 5x and 4 6x RWxxxD files to the 5 0x format The RWxxxD files are the Data Dictionary files that contain the data names for an application They include the field names for that application cross references to interfaced applications and user defined data names Starting the function Select Convert 4 5x RWxxxD File to 5 0x from the System File Conversion menu The function screen appears Bizas too caine DS Pt hjp r Comar d tee Bixee File to 5 006 Pach Oa aT r Verification Fraza FT to exit Enter the name of the directory that contains the files you want to convert You cannot convert files in the directory you are converting to Check your entry If you want to change it move the cursor to the field or use the Abandon F5 command Software Development Utilities User s Manual 5 9 Convert 4 5x RWxxxD File to 5 0x System File Conversion When your entry is correct use the Proceed PgDn command to save the record Then enter another path or use the Exit F7 command to return to the menu 5 10 Software Development Utilities User s Ma
46. multiple keys INAIx 1 Mkeyed Dynamic 128 Inventory Alternate Items None Key 1 4 1 20 1 1 20 Key 2 1 1 20 6 1 1 2 1 6 4 1 20 Key 3 6 1 1 2 1 6 4 1 20 1 1 20 Key 4 1 1 20 6 1 1 2 1 6 7 1 7 4 1 20 INAPPL TXT 0 String IN Application Information None INBNx 1 Mkeyed Dynamic 128 Inventory Item Bins None Key 1 1 1 20 2 1 6 3 1 6 Key 2 2 1 6 1 1 20 3 1 6 Key 3 2 1 6 3 1 6 1 1 20 INCAx 1 Mkeyed Dynamic 64 Inventory Categories None Key 1 1 1 2 Key 2i 2 1 25 1 1 2 INCBx 1 Mkeyed Dynamic 384 Physical Count Batches None Key 1 1 1 6 Key 2 3 1 4 2 1 12 1 1 6 End of report 2 10 Software Development Utilities User s Manual Option Linkage List The Option Linkage List shows the switch information for one or more xxSWCH files Starting the function Select Option Linkage List from the System File Maintenance menu A selection screen appears EIAS Tini BEE ming DS Pt hp Option Linkege Lint Pick Applicetica Foo Thru fotpuk cacrice d Ti pF evier F ile B5 erenn Bj a Field Descriptions Pick Application ID From Enter the range of application IDs you want in the list Thru Software Development Utilities User s Manual 2 11 Option Linkage List System File Maintenance Command bar Definitions Output device P rinter Enter P to print the Option Linkage List F to file it S to F ile S creen E nd display it on the terminal screen or
47. n for conversion programs You can also print lists from system files and diskette labels Software Development Utilities User s Manual 1 3 Introduction Introduction Use the functions on the Software Audit menu to check BBx programs for violations of OSAS standards and for common programming errors such as unused line labels and invalid string template names Use the functions on the Replacement Programs menu to set up and maintain a database of programs shared between applications Tracking these programs is important in application development Use the functions on the System File Conversion menu to upgrade your application system files from past versions of OSAS to current versions Use the functions on the Data Dictionary menu to create and maintain the BASIS Data Dictionary files used in OSAS 5 1x The process of defining a BASIS Data Dictionary is divided into three parts file field and index definitions The OSAS system keeps only certain drives enabled Some of these utilities enable new drives and may not disable the drive before returning to the menu Also included in the utilities are GENLIB xx files for each version of OSAS from 4 0x to 5 1x and several modified BBx supplemental utilities GENLIB contains the general routines for use with the BASIS library manager which is used to update programs with the current general routines discussed in the Software Development Standards manual MMRG A Conversion Assi
48. n you want to work with disk Enter the disk or drive that contains the media you want to verify Software Development Utilities User s Manual 3 15 Audit xxFiles TXT Software Audit Command bar Definitions Output device Printer Enter P to print the Audit xxFILES TXT report T to Terminal File End display it on the terminal screen F to file it or E to exit to the menu 3 16 Software Development Utilities User s Manual Audit BBx Version Level Use the Audit BBx Version Level function to check the last level of BBx that each program in the selected directory drive was last saved Starting the function Select Audit BBx Version Level from the Software Audit menu This function screen appears Bisai tina Geir DE Pent Help Budit PEx Version Level Appliosrt iga To AF Varmion amp 400 JA Bio ieee os Disi Aime Ooh 1 28 Bifeeborcy Heme SE LBEOIAL 604M FEAR Quipet diowice ina Field Descriptions Application ID Enter the ID of the application you want to work with Version Enter the version number of the application you want to work with QA Round Enter the quality assurance round number of the application Software Development Utilities User s Manual 3 17 Audit BBx Version Level Software Audit Field Disk Size Directory Name Command bar Output device P rinter Fjile E nd Audit BBx Version Level report Descriptions The default DOS 1 2M is displayed Press En
49. nation dictionary files File Name To Name If you selected 2 enter the ID of the filename you want to copy then enter the destination filename Check your entries If you find mistakes move the cursor to the fields you want to change or use the Abandon F5 command to start again from the beginning of the screen When everything is correct use the Proceed PgDn command to save the record Then copy another dictionary or use the Exit F7 command to return to the menu Software Development Utilities User s Manual Files Use the Files function to set up and maintain information about the data files used in OSAS programs Starting the function Select Files from the Data Dictionary menu The function screen appears iere Edt Pinu Hele Files Pictionary 4 PERE LE on Ud at BeGLAn Peps Rey fades Tile Birtcibution Cede EReped 120 r 1z Todam File Tacna Codes Recor IFapri 126 g Iz Vir India sad Oo e ft whew Tne ed o t SRS FILE li g ii 132 Le Li Checks File Checks Becord ERe ped 172 5 oO faecke File Imroice Reeord Feri 172 r oa Cheka File Comerol Record IKe ti Eps o Oo whew Tide ed o Lee lint ped u Lk Lif Vier Inde eed oO Le oO Faqgqrirition Control File ERa pes is a oa Fageieicdon Terminal Facocd 3 EReped iG o a Feqeleicion Coarroal Reoord Eksymi i Le WLee IBE ed oO Le Li Liat Ho MORO cf CODE A Enver adit ippand Goto Command bar Definitions Enter edit Move the promp
50. ntaining 4 5x and 5 1x signature lines are provided with the utilities The filelist management utility see chapter 1 section 2 is used to create the list of files that are checked against the default text files Starting the function Select Audit Signature Lines from the Software Audit menu The function screen appears Bar Eh Get Hele elmeta Emly Software Development Utilities User s Manual 3 19 Audit Signature Lines Software Audit When you select eXecute on the filelist entry screen the following prompts appear Field Descriptions Output device Printer Select P to print the Audit Signature Lines report T to Terminal File End display it on the terminal screen F to file it or E to exit to the menu Display discrepancies only Enter Y to display only the signature lines that contain discrepancies or enter N to display all discrepancies Compare File Enter the compare file that will be used to check the current file list Enter GENSIG51 TXT for version 5 1x or enter GENSIG45 TXT for version 4 5x After you press Enter the function is executed Audit Signature Lines report C PROGJO JOCMNT PUB 6000 REM 0 Modified GENINPUT 6000 6190 9300 LET Y S GOTO 8452 3 20 Software Development Utilities User s Manual Audit Line Labels The Audit Line Labels function produces a report showing unused and missing line labels in programs Use the filelist entry screen
51. nual Convert 4 5x RWxxxl File to 5 0x This utility converts 4 5x and 4 6x RWxxxI files to the 5 0x format The RWxxxI files are the Permanent Report Instruction files that contain the report instructions you created and saved for each topic Starting the function Select Convert 4 5x RWxxxI File to 5 0x from the System File Conversion menu The function screen appears BEE E Ai tini ming DS Pt kjip Comar 4 3r PUrenI File to 5 006 Tcyirg to Opan Ber Enter the name of the directory that contains the files you want to convert You cannot convert files in the directory you are converting to Check your entry If you want to change it move the cursor to the field or use the Abandon F5 command Software Development Utilities User s Manual Convert 4 5x RWxxxl File to 5 0x System File Conversion When your entry is correct use the Proceed PgDn command to save the record Then enter another path or use the Exit F7 command to return to the menu 5 12 Software Development Utilities User s Manual Convert 4 5x xxHELP File to 5 0x This utility converts help files from 4 5x and 4 6x to 5 0x Each application contains a help file The information is stored in the xxHELP file xx is the application ID Starting the function Select Convert 4 5x xxHELP File to 5 0x from the System File Conversion menu The function screen appears EIAS Tou Be aes Pat Pimi Hap r Comert 9 504 xxHELF Film to 3 0
52. o 0 ss PEN ESTES P A iny OME Use the Convert 4 xx xx WIND File to 4 5x function to convert 4 0x and 4 1x window definitions to a 4 5x format Use the Convert 4 5x xxWIND File to 5 0x function to convert 4 5x and 4 6x window definitions to a 5 0x format Software Development Utilities User s Manual 5 3 Overview 5 4 System File Conversion Use the Convert 4 5x RWxxxD File to 5 0x function to convert 4 5x and 4 6x RWxxxD files to a 5 0x format The RWxxxD files are the Data Dictionary files that contain the data names for an application They include the field names for that application cross references to interfaced applications and user defined data names Use the Convert 4 5x RWxxxI File to 5 0x function to convert 4 5x and 4 6x RWxxxI files to a 5 0x format The RWxxxI files are the Permanent Report Instruction files that contain the report instructions you created and saved for each topic Use the Convert 4 5x xxHELP File to 5 0x function to convert help files from 4 5x and 4 6x to 5 0x Each application contains a help file The information is stored in the xxHELP file xx is the application ID Software Development Utilities User s Manual Convert 4 xx xxWIND File to 4 5x This utility converts 4 0x and 4 1x window definition files to the 4 5x format Starting the function Select Convert 4 xx xxWIND File to 4 5x from the System File Conversion menu The function screen appears Bizas
53. oftware Development Utilities User s Manual Option Linkage The Option Linkage function maintains xxSWCH files The optional xxSWCH file is necessary if the application has a switch in the OPTxxx record of the xxTB file that should be updated when a switch in another application is changed called a link Starting the function Select Option Linkage from the System File Maintenance menu The function screen appears EIAS tini ig Eat Pit pjp T Option Linkage pplication Juwitsh File AR Bpiuree wpplicehicon PREG La IH Source Switch Huntar o7 Sequesqe Mhmber i DESE Gna Lon Application Perit Al Dart insticn Jwitch Humber 07 r Verification Pomme lt Pgin gt amp o proceed Field Descriptions Application Switch File Enter the application ID of the switch file you want to work with Source Application Prefix Enter the application ID that will control the switch you are entering into the switch file Software Development Utilities User s Manual 2 7 Option Linkage System File Maintenance 2 8 Field Descriptions Source Switch Number Enter the source switch number from the source switch file you are creating an entry for Sequence Number Enter the sequence number for the switch Destination Application Enter the destination application ID that the switch will Prefix control Destination Switch Enter the switch number for the destination that the switch Number will control Check your entries If yo
54. ommand to start again from the beginning of the screen Software Development Utilities User s Manual 6 19 Fields Data Dictionary When everything is correct use the Proceed PgDn command to save the record or use the Exit F7 command to abort the line item entry area Update Fields screen After you approve the field information the other files are scanned for matching field names If data changes have been made the Update Fields screen appears to update other files with the changed data E AAS To caine DE Pent pap r Field Ditti Hary FLL FLLE ire 1099 File Wara inc Costar File Safe Dice 102s Edit Fimld PLeld Aine 000I Field ID Description Customer Ib Upe Fields Update fields auncmacioaliy or prompt for mech fields Prompt FLela Type Hump io Type Desorige ion Hi Uecieble Langek Tigld Type TES Field Terminsto Fiela bengeb TES Be Else TEs Fisld Langti Hota gt droay Elements BU Hers CUSTOMER IH Veciakle COG Template COST Field Descriptions Update fields Enter P if you want a prompt to appear before each field is automatically or prompt updated Enter A if you want all fields to be updated for each field automatically If you enter P each field name will appear on the Update Fields screen Description If you want to update the description with changes enter Y if not enter N Field Type If you want to update the field
55. on to maintain these system tables The OUTPUT table store the margins for the File Descriptions The SDEXTyyy table stores the current data dictionary for terminal yyy OUTPUT table When you enter the table ID the rest of the OUTPUT table appears E SAS To mig DS Pat bb SOTE Tatli CO JITANT DESSTISE LO Eput Tables Tor File Laer Husker af Oola 2 Colum CLengek 12 Tyr EL EIJ Takk ing Top Maryin Left Bercgin r Verification Peers lt Pgtn gt to proceed OUTPUT table Field Descriptions Desc The descriptions in the table are displayed Software Development Utilities User s Manual Tables System File Maintenance Field Descriptions Setting On the first line enter the width for the top margin On the second line enter the width for the left margin The SDEXTyyy table When you enter the table ID the rest of the SDEXTyyy table appears Rosas To faire DE Pont Hain STE Tanie Cl EPESTE Gestript Lon LEEPER DLObioeery Eemension Tor M Hugker af Gols i Colen Lengrk 12 Tyr 4 Externrion r Verification Feest lt Pgtn gt to proceed Field Descriptions Extension The extension of the current data dictionary for terminal Tyyy is displayed 2 20 Software Development Utilities User s Manual Print Diskette Labels Use the Print Diskette Labels function to enter and store diskette label information You might have to change the label program to achieve proper label alignment Starting the function
56. ons Output device Printer Enter P to print the Audit Programs report T to display it Terminal File End on the terminal screen F to file it or E to exit to the menu After you select the output device the filelist screen appears When you select eXecute on the filelist entry screen the output is generated 3 12 Software Development Utilities User s Manual Software Audit Audit Programs Audit Programs report 2210 READ FILE 16 KNUM 3 KEY CC0 FILL 14 DOM NEXT_CODE ERR GENERROR 6100 CALL GENINPUT PUB ERR GENERROR Z9 Y X0 X1 X2 X3X X INFO WINDID SELVAL COMPID PROGID FILE ALL YDISABLE PGM 2 FLD_HLP 8305 LET GENOPEN_MSG YSAVE YDISABLE YDISABLE XSJPUD Y 8320 LET YDISABLE YSAVE YSAVE RETURN 8410 CALL GENERROR PUB X9 X8 ERR TCB 5 07 Y TCB 10 X1 1 8452 LET SPREC TCB 14 RESET PRECISION SPREC SETERR GENERROR PROGJO JOACC done 8 anomalies Software Development Utilities User s Manual 3 13 Audit xxFiles TXT The Audit xxFILES TXT function performs a cross reference check of the files in the xxFILES TXT file and on distribution media Starting the function Select Audit xxFILES TXT from the Software Audit menu The following prompts appear Boas tow BEE Saige Eat Pit Hen kudt xeFILES TXT anter applicacion Ib AR disk Field Descriptions enter application ID Enter the ID of the applicatio
57. or field names Description Enter a description for the field 6 18 Software Development Utilities User s Manual Data Dictionary Fields Field Field Type Numeric Type Variable Length Field Terminator Field Length Array Elements RW Name Variable Notes Descriptions Enter one of the following letters for the types of fields available Character Numeric Unsigned Interger Signed Interger IEEE Float BCD Float Business Math C Float C Double KPO BR EAM If the numeric is a Boolean enter B If the numeric is a date enter J If the numeric is any other type enter O If the field type is non numeric skip this field If the field is of variable length and requires a field terminator enter Y if not enter N Enter the decimal code that is used to represent a field terminator in your file All OSAS standard files use a decimal 10 as a terminator Enter the length of the field in bytes If this field is an array enter the number of array elements All arrays are one based so if the array has two elements enter 2 Enter the name to be used in the GENERAL Report Writer Enter the variable ID used to represent this field If this application uses string templates leave this field blank Enter any descriptive notes you want to appear on the file layouts Check your entries If you find mistakes move the cursor to the fields you want to change or use the Abandon F5 c
58. r Ve rificaticm Press PgDn to proceed Field Descriptions Dictionary The current data dictionary selection is displayed Application Enter the application ID that you want to create templates with File Name From Thru Enter the range of filenames you want to create templates for or press Enter at From Thru to select all files Software Development Utilities User s Manual 6 33 Create Update Template File Data Dictionary 6 34 Field Descriptions Update If you want to update an application specific file enter A If you want to update the OSTPL file enter O Destination Directory Enter the directory where the template file exists If the template file does not exist in the specified path this function will create the path for you Check your entries If you find mistakes move the cursor to the fields you want to change or use the Abandon F5 command to start again from the beginning of the screen When everything is correct use the Proceed PgDn command to save the record Then create update another data dictionary or use the Exit F7 command to return to the menu Software Development Utilities User s Manual Create File s from Data Dictionary Use the Create File s from Data Dictionary function to create data files for an application based on the criteria in the BASIS Data Dictionary If the file already exists a prompt appears to overwrite it After each file is created the xxDAT
59. r4 Application 1P Al r Verificaticz Peest lt Pg0n gt to proceed Field Descriptions Application ID Enter the ID of the application you want to convert Check your entry If you want to change it move the cursor to the field or use the Abandon F5 command Software Development Utilities User s Manual 5 13 Convert 4 5x xxHELP File to 5 0x System File Conversion When your entry is correct use the Proceed PgDn command to save the record Then enter another application ID or use the Exit F7 command to return to the menu 5 14 Software Development Utilities User s Manual Data Dictionary Overview Edit CONFIG TPM Build Shadow Dictionary Create Data Dictionary Copy File s to Dictionary Files Fields Indexes File Layouts Field File Cross Reference List Create Update Template File Create File s from Data Dictionary Add Change Reserved Words Audit Field Names for Reserved Words Reserved Word List Software Development Utilities User s Manual 6 3 6 5 6 7 6 9 6 11 6 13 6 17 6 23 6 27 6 31 6 33 6 35 6 37 6 39 6 41 6 1 Overview Use the functions on the Data Dictionary menu to create and maintain the BASIS Data Dictionary files used in OSAS version 5 1x and above The process of defining a BASIS Data Dictionary is divided into three parts file field and index definitions for each file used by OSAS When you select Data Dictionary from the Development Utilities m
60. rates space No References Found QUIT neces attenerasaile apesorevouer dg TOO E No References Found XATB ae MEE olen eitous Bus tsorerarniehare e tice No References Found Software Development Utilities User s Manual Audit Program Data File Names Use the Audit Program Data File Names function to produce a report showing possible conflicts in program and file naming for example program ARINVO could conflict with the ARINxxx file for company V0 Starting the function Select Audit Program Data File Names from the Software Audit menu The function screen appears E Ai Tini ain CS Fint Help T ket Frograrn Data Fide Farar spplicee ion iR Application Path OPP OBAS pE og Varsica Humtar z200 Search EH Path ma BA Fati CE DBAS pE og Pe Futput arice Fir iz erc p F evier F ila 3 creas iM a Field Descriptions Application Enter the ID of the application you want to work with Application Path The directory path of the application is displayed from OSAPPL the application information file Press Enter to accept the default or enter a different directory path Software Development Utilities User s Manual 3 23 Audit Program Data File Names Software Audit 3 24 Field Version Number Search RM Path RM Path Command bar Output device P rinter F ile S creen E nd Descriptions The version number of the application that is displayed is based on the
61. riptions Enter the ID of the application you want to work with and store in the Print CRCs report Enter the version of the application you want to store in the Print CRCs report Definitions Enter the quality assurance round number of the application The default DOS 1 2M is displayed Press Enter to accept it or enter a different format and disk size Enter the directory or drive name that contains the files to be included in the report Enter P to print the Print CRCs report F to file it or E to P ile E nd exit to the menu Print CRCs report 12 08 1999 Print CRCs Page 1 1 22 PM APPL JO VER 5 11 RND 1 DOS 1 2M Filename CRC Size Type Directory JOAPPL TXT C6CE 37 Str C 511GR J05110RG JOFILES TXT 24B2 189 Str C 511GR JO5110RG JOLABEL TXT 9213 133 Str C 511GR JO5110RG JOACC 6294 5 932 Prg C 511GR JO5110RG JOACCFM PUB C466 5 939 Prg C 511GR JO05110RG JOACJ 96F8 10 391 Prg C 511GR JO5110RG JOACI1 9940 22 008 Prg C 511GR JO5110RG JOACJCON 9C4C 15 592 Prg C 511GR JO5110RG JOACJLN1 PUB F74A 8 056 Prg C 511GR JO5110RG JOACIVEW PUB D69E 3 841 Prg C 511GR JO5110RG JOACT 182D 5 000 Prg C 511GR JO5110RG Software Development Utilities User s Manual Compare CRCs The Compare CRCs function prints the differences between the CRCs calculated for each volume Only the names of programs with differences are printed in the Compare CRCs report If even one version of the same fil
62. rved Words List from the Data Dictionary menu The function screen appears B mAs mini oe D Pit Bain Berecved Borda Lirt Fesecred Word Frou TRE fotgul arice CPheimtec p F evier Fpile 3 creas Bj on Field Descriptions Reserved Word From Thru Enter the range of reserved words you want to print or press Enter at From Thru to select all reserved words Software Development Utilities User s Manual 6 41 Reserved Word List Command bar Output device P rinter p R eview File S creen E nd definitions Press P to print the file layouts R to preview the layouts F to file them S to display them on the terminal screen or E to exit to the menu Reserved Words List follows sample 12 19 1999 Builders Supply 12 41 PM 6 42 Reserved Word ABSOLUTE ACTION ADD ALL ALLOCATE ALTER AND ANY BY CASCADE CASCADED CASE CAST CATALOG CHARACTER CHARACTER_LENGTH CHAR_LENGTH CHECK CHECKPOINT CLOSE CLUSTERED COALESCE COLLATE COLLATION COLUMN COMMIT COMMITTED COMPUTE CONFIRM CONNECT CONNECTION CONSTRAINT CONSTRAINTS CONTINUE CONTROLROW CONVERT Reserved Words List Description SQL ABSOLUTE SQL ACTION SQL ADD SQL ALL SQL ALLOCATE SQL ALTER SQL AND SQL ANY SQL BY SQL CASCADE SQL CASCADED SQL CASE SQL CAST SQL CATALOG SQL CHARACTER SQL CHARACTER_LENGTH SQL CHAR_LENGTH SQL CHECK SQL CHECKPOINT SQL CLOSE SQL CLUSTERED SQL COALESCE SQL COLLATE SQL COLLATION SQ
63. see page 1 7 to enter the list of programs that you want to audit Starting the function Select Audit Line Labels from the Software Audit menu This function screen appears Boas Tow BE Sains FS Pnt Help kerdst Lira Labels Til llat Sntey EARLESS i ATILE AHI ESETT Delete CIE Bir dare RSE Laal Primt Biase Jelp Software Development Utilities User s Manual 3 21 Audit Line Labels Software Audit 3 22 When you select eXecute on the filelist entry screen the following prompts appear Field Descriptions Output device Printer Select P to print the Audit Line Labels report T to display Terminal File End it on the terminal screen F to file it or E to exit to the menu Include IOLists Enter Y to include IOLists with the list of references or enter N to exclude IOLists from the report Each program in an application typically lists all the files for that application even though a file may not be used in the current program To reduce the amount of detail in the report you may want to exclude IOLists After you press Enter the function begins to execute Audit Line Labels report Cross reference of progjo joacc Page 1 GOT CODE yeaa aN AEE SANEA REAA No References Found JOBSEXK aerO ATE T REEERE eke asta No References Found JODEXXX cavlstensrstgatecihve die tea ante Ea No References Found WOH TRKK SEER EAEE E ate No References Found TOT ERK r aa p sree a e
64. stance Program 1 4 The MMRG program is included in the application program directory but cannot be run from the Development Utilities menu This program is useful for converting version 3 2 programs to the 4 00 level MMRG operates on a program loaded into the BBx workspace The operations are related to conversion of OSAS 3 2 to 4 00 Software Development Utilities User s Manual Introduction Introduction You can copy MMRG along with the text files 3800 7900 and SCROLL to the directory of the application being converted Make modifications to MMRG that will make your job easier Here is a summary of the tasks that MMRG performs SETERR SETESC SETERR GENERROR is inserted if GENERROR is merged SETESC 9350 SETERR GENERROR is inserted if GENLOCK is merged Copyrights Enter Y at the copyright prompt to move the author line to line 11 REM 0 COPYRIGHT 15 25 is inserted at line 15 Output Selection Enter Y at the output selection prompt to merge file 3800 Box Routine Enter Y at the box routine prompt to merge file 7900 Scroll Routine Enter Y at the scroll routine prompt to merge file SCROLL GL Interface Enter Y at the GL interface prompt to insert the CALL GLJRNL PUB statement MMRG prompts for a line number for the CALL statement Software Development Utilities User s Manual 1 5 Conventions Using the BASIS Filelist Generator Several of the Software Audit functions require you to create a fi
65. t gt to the line you want to edit and press Enter Append Press A to add a file Goto Press G to go to a specific file If everything is correct use the Exit F7 command to return to the menu Software Development Utilities User s Manual 6 13 Files Data Dictionary Files Line Item Entry screen When you elect to edit or append a file the Edit File screen or the Append File screen appears B oas Tom ging DE Pt Hap Filas Dicticaary i1 Edit Fole Filz Mar Fey APCE Distignary o Ky APCD_2 l uz APCD_PEGT_ OO File Ware APD i APCD TERN j APCH 1 View Periniti n Mo oO i APEH Type HReved a APCH_S Record beng Lia oO oO APCH CHE_REC Ho of Mecceda i i i KECH CTRL RE Eey Sige LE APCH_INY_ REC o o APTA File Indes 1 Q Q APCH_i Be Topic Caza 0 0 APCH_2 Long File eee APCD Oo oO APCE_CTRL_RE ODBC Fath DATA APC CID D o Application IDO AF of O i Field Descriptions File Name Enter the name of the file you are working with Do not include the company ID in the filename Description Enter a description for the file Type Enter one the following letters for the file type I Indexed L Serial P Program D Directory K Keyed M MKeyed S String 6 14 Software Development Utilities User s Manual Data Dictionary Files Field Record Length No of Records Key Size File Index RW Topic Long File Name Application ID Descriptions Enter the size for a record in th
66. ter to accept it or enter a different format and disk size Enter the directory or drive name that contains the files to be included in the report Definitions Enter P to print the Audit BBx Version Level report F to file it or E to exit to the menu 12 08 1999 JOPUC JOPUC1 JOACC JOACCEM PUB JOACI JOACI1 JOACICON JOACJLN1 PUB JOACIVEW PUB JOACT JOACTEM PUB JOADI JOPRJC JOPRJC1 JOPRVC JOPRVC1 JOPSM JOPSM1 Audit BBx Version Level VER 5 11 04 04 04 04 04 04 04 04 04 04 04 04 04 APPL JO Level Size 10 391 22 204 15 593 8 056 3 841 5 000 4 449 20 979 5 401 4 118 7 749 6 406 6 854 6 343 Prg Prg Prg Prg Prg Prg Prg Prg Prg Prg DOS 1 2M Type Directory End of Report OQ OA TO GO OAs OO OQ ANG OF GQ a GR PROGJ GR PROGJ GR PROGJ GR PROGJ GR PROGJ GR PROGJ GR PROGJ GR PROGJ GR PROGJ GR PROGJ GR PROGJ GR PROGJ GR PROGJ GR PROGJ GR PROGJ GR PROGJ GR PROGJ GR PROGJ RND 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 1 3 18 Software Development Utilities User s Manual Audit Signature Lines The Audit Signature Lines function compares program lines against a text file containing the lines you want to validate The primary intent of this utility is to verify that signature lines are correct before running a global update Default text files GENSIG45 TXT and GENSIGS1 TXT co
67. tom modification This information is stored in the SDPRMOD DAT file The Replacement Programs List shows information stored in the SDPRMOD DAT file on modifying applications and replaced programs Software Development Utilities User s Manual 4 3 Replacement Programs Use the Replacement Programs function to enter the base programs that are modified by a vertical application or a custom modification This information is stored in the SDPRMOD DAT file This file contains all the programs replaced by Open Systems applications Starting the function Select Replacement Programs from the Replacement Programs menu The function screen appears Bizas tina giing pE fii hjp Faplearant Frogomes Version He a Sab Program Replaced ARSC REP lace lag Application Lh Commo r Verification FPreerr lt Pgtn gt to proceed Field Descriptions Version No Enter the version number of the application Program Replaced Enter the base program replaced by the replacing application Software Development Utilities User s Manual 4 5 Replacement Programs Replacement Programs 4 6 Field Descriptions Replacing Application ID Enter the ID of the application that has replaced a based program Comment Enter a comment for the replacement Check your entries If you find mistakes move the cursor to the fields you want to change or use the Abandon F5 command to start again from the beginning of the screen When
68. tware Development Utilities User s Manual 6 5 Edit CONFIG TPM Data Dictionary 6 6 Field Name DATA SYSFIL CID Command Enter edit Append Line Write Change CONFIG TPM Names Description Enter the file path to the company data Enter a at the end of the directory path Enter the file path to the OSAS system files Enter a at the end of the directory path Enter the company ID for the database configuration file Description Move the prompt gt to the line to edit and press Enter Press A to add a line Press W to save your changes Press C to save your changes to a new configuration file When you finish your entries use the Exit F7 command to return to the menu Software Development Utilities User s Manual Build Shadow Dictionary Versions of the OSAS ODBC Kit before 6 05 used a revision 1 x ODBC driver which made use of a shadow dictionary Beginning with the ODBC Kit version 6 05 OSAS uses a revision 2 x driver which does not use the shadow dictionary Use this function only if you use the revision 1 x ODBC driver Starting the function The Build Shadow Dictionary screen appears ECET Before you create your dictionary check the Fast Connect and No Shadow Dictionary Consistency Check in the Advanced Settings of any data source setup that uses this ODBC driver Use the Proceed PgDn command to create the Shadow Dictionary After the Shadow Dictionary is creat
69. u find mistakes move the cursor to the fields you want to change or use the Abandon F5 command to start again from the beginning of the screen When everything is correct use the Proceed PgDn command to save the record Then enter another file or use the Exit F7 command to return to the menu Software Development Utilities User s Manual Data File Information List The Data File Information List shows the data files that are defined in the xxDATA yyy files Starting the function Select Data File Information List from the System File Maintenance menu A selection screen appears Bosas tini gmina Pot Pint bjp T Data File Information Liat Fick ipplicstion From T hrii FYarsion 4 20 Futput arice CPpciziec p Fj evier F ile 3 crann i za Field Descriptions Pick Application From Enter the range of applications you want in the list Thru Version Number Enter the version number of the data files you want to view Software Development Utilities User s Manual 2 9 Data File Information List System File Maintenance Command bar Definitions Output device P rinter Enter P to print the Data File Information List F to file it S F ile S creen E nd to display it on the terminal screen or E to exit to the menu Data File Information List report 05 30 1999 Page 1 Data File Information List Version 6 00 Inventory File Name Create Type Key Records Size Description Header Definitions for
70. unction to produce a printout of all the data dictionary items by field name Use the list to verify the consistency of field names in related files Use the Create Update Template File function to create or update the string template files OSTPL or xxTPL xx represents the application ID Use the Create File s from Data Dictionary function to create a data file or all data files for an application based on the criteria in the BASIS Data Dictionary Use the Add Change Reserved Words function to add or update the file of reserved SQL words This file is verified when you add a field name to a file Use the Audit Field Names for Reserved Words function to validate an application for reserved words or to check all applications Use Reserved Words List to print all the words that are reserved SQL words Software Development Utilities User s Manual Edit CONFIG TPM Use this function to create or edit your dictionary configuration file Starting the function Select Edit CONFIG TPM from the Data Dictionary menu The function screen appears Field Name Description Path and Name of Enter the file path and name of the database configuration file CONFIG TPM File you want to work with Enter a at the end of the directory path If you enter a new path or database configuration file name a skeleton file is built DICTIONARY Enter the file path to the data dictionary files Enter a at the end of the directory path Sof
71. y 6 11 Files 6 13 Fields 6 17 Indexes 6 23 File Layouts 6 27 Field File Cross Reference List 6 31 Create Update Template File 6 33 Create File s from Data Dictionary 6 35 Add Change Reserved Words 6 37 Audit Field Names for Reserved Words 6 39 Reserved Word List 6 41 Introduction Introduction Conventions Software Development Utilities User s Manual Introduction The following chapters describe the Software Development Utilities delivered with the Advanced Developer Tool Kit The utilities are installed through Resource Manager like any other application Software Development Utilities a collection of programs written by Open Systems staff programmers is used in developing and testing OSAS products To use these utilities you must have a complete set of the BBx Supplemental Utilities installed on your development system When you choose Development Utilities from the Main Menu this menu appears E SAs To geing Cat Pent Hp Dija Laas Liman H 1101 PFE nain Beni Iava lopmant Uti bit ie Syara File Aaiscenane Software Audit Pep latent FrEe ame Spaces Pile Gomereice Iuta Diztionsry hn PEN SESTERS H Aoun iny SOC TEAE E Use the functions on the System File Maintenance menu to update the system files that are required in installable OSAS applications You can create and maintain information about data files set option linkages in old OSAS versions and maintain application version informatio

OPEN SYSTEMS® Accounting Software Software Development

Contents

Download Pdf Manuals

Related Search

Related Contents

OPEN SYSTEMS&reg; Accounting Software Software Development

Contents

Download Pdf Manuals

Related Search

Related Contents

OPEN SYSTEMS® Accounting Software Software Development