Home

DBUnifier User`s Manual

1. S on Page 68 File name File Library Member name Query Selection Expression The File Name prompt field specifies the database file to be accessed by the DBUnifier Processor By using the default value DEFAULT the file that was specified when the application was defined is used The File Library Name prompt field qualifies the library where the file will be accessed Special value LIBL tells the processor to search all the libraries in the job s library list until the first match is found Special value CURLIB checks the current library for the job to locate the file to process The Member Name prompt field specifies the member name of the file you would like to process The default value for this field 1s FIRST which denotes to the DBUnifier Processor to use the first member in the file defined The Query Selection Expression prompt field specifies the selection values used to determine the records that are available to the DBUnifier Processor The default value ALL selects all records in the database file to process Start DBUnifier Processor STRDBUAPP command Command Keys Command Keys F3 Exit F4 Prompt F5 Refresh F9 AII Parameters F11 Keywords F12 Cancel F13 How to use this display F14 Command String F15 Error Messages F16 Complete Command F24 More Keys Description of Command Key The Exit command key exits from the
2. OOsA E U Page 39 E a elll A Define Extended Field Attributes Command Keys Command Keys Description of Command Key F1 Help Help information has not yet been made available This command key is for future use F3 Exit The Exit command key exits from the Define Extended Field Attributes display F4 Prompt The Prompt command key shows the list of possible values that can be assigned to the field F5 Refresh The Refresh command key clears the screen and resets the display to its initial values F10 Command The Command command key displays a command entry line Which allows you to executed OS 400 commands F12 Cancel The Cancel command key exits the user from the Define Extended Field Attributes display F24 More Keys The More Keys command key displays other command keys that are available Page 40 Defining Prompt Program for Field The Define Prompt Program for Field display allows you the ability to assign a User Defined prompt program or a DBUnifier Application that will be processed when the F4 Prompt command key is pressed on the cursor location of a field The return value replaces the existing screen value of the field Define Prompt Program For Field display i DBlinifier version 4 2 Define Prompt Program For Field Type choic Sequence Number a 110 Field Name
3. Page 17 E REC PE M e LLL SL Choosing a File To choose a file move the cursor to the File prompt and type the name of a file If you want to choose a file from a list of file names you can press F4 with the cursor at the File prompt The Select File display is shown and on this display you can choose a file for you application Choosing a Library Because the file you want to select may be in a different library you can specify a different library name generic library name or special library name for the file selection e Ifyou type a generic library name or special library name in this prompt and press the Enter key that library group is searched for the file named in the File prompt e If you type a generic library name or a special library name and then press the F4 with the cursor in this prompt the specified list of library names are shown on the Select Library display When you select the library you want from the list and press the Enter key you will return to this display with the selected name filled in Choosing a Member similarly if you want to choose from a list of members move the cursor to that prompt and press F4 to see the associated display and select the member name you want to be used with that file Then when you return to the Specify File Selection display that name is shown in the prompt If you did not select a member name DBUnifier resolves the special default value DBUnifier will supply the first f
4. STATE Type A Length 2 Field Heading State Province A gd a Enter DBUnifier Application or User Defined Program for Field Prompting Prompt pe 2 s Wo a DBUAPP KMONE DBUAPP or PGM Application Mame os Al EU Name F4 for Fl Help EISE ah ud KLIGL Name LIBL Return Field STATE Mame F4 for Fz4zMore Gl Copyright ProData Computer Services Inc Define Prompt Program for Field Prompt Fields Field Prompt Type Application Name Library Return Field Description of Prompt Field The Prompt Type allows any one of the following NONE No prompting occurs for this field DBUAPP A DBUnifier Application is specified for prompting on this field PGM A User Define Program is specified for prompting on this field Application Name defines the DBUnifier Application that is processed for the selection of a replacement value for the screen field being prompted To choose from a list of DBUnifier Applications position the cursor on the Application Name prompt field and press the F4 Prompt command key Library denotes the library where the DBUnifier Application resides or the Library where the User Defined Prompt Program exists that will be used for field prompting The Return Field specifies the field value within the DBUnifier Application that is to be returned and replace the value of the field on the screen To choose from a list of fields defined in the DBUnifier Application position
5. DBUnitfier ProData Computer Services Inc 2809 S 160 St Ste 401 Omaha NE 68130 Telephone 402 697 7575 Tollfree 800 228 6318 Web http www prodatacomputer com Email Sales sales prodatacomputer com Email Tech Support help prodatacomputer com Contents e UE op T sen cecsssunshaue Sud cossessauiaesstecoatesancsavsieteastelacessiecoavavandsausiuncelwalelasaeetecssteveseobuncterces I SOFTWARE LICENSE AGREEMENT 1 ccccsscsssccesccsccsscccscccccccccescccsccccccsccescccccscccssccscscsccescoscsecces V BEBEORE XOUSEAR T iot etezee esse piden asses 1 VETS IOVS ue JUCLOUSE Stu crea ceu acres es ccs T E LE hocce a BLE LED ute io Sees cpa a BRITA oL CLE c DE Tcp 1 PBO EAPO ONS ccu tenait a Eun aO Maii d inu Semin l INSTALLING SAVING AND DELETING DBUNIFTER cccssccsccssssscccccsscccccccscccccccesssccccceeecees 2 DVS TTD GLC Em 2 SAVING TD ONL CP 3 POV CTU DB ON EE ices pcs aaa ws cee aah mao anes anes mee mag in ia asa teeta Agee ase 4 WORK WITH DBUNIFIER APPLICATIONS WREKDBUAPDP sssssssssssssssssssssssssssssssssssssccssssses 5 Work with DB Unifier Application ODIIOTS ui duet ett e Re e Ete tate bale eetbtde fe t aesti aeu da 5 Work with DBUnifier Application Command Keys ccccccccccc cece cece eme emen eene 6 Working with a List of DB UNi fier Applications ud D ee tb ea e Ria RU Ed e pA cures 6 DCI COINS CIN IOI ie ates nw tendis ta uod utut pu
6. Detail Processor STRDBUDTL command Prompt Fields eeeeeeseeses 72 Start DBUnifier Detail Processor STRDBUDTL command Command Keys eeeeeeeeeeeee 73 Run DBUnifier Detail Processor RUNDBUDTL command ssssssss e eke e cece cece eect eee ees 74 Run DBUnifier Detail Processor RUNDBUDTL command Prompt Fields sssssss 74 Run DBUnifier Detail Processor RUNDBUDTL command Command Keys sss 73 OUERY SELECTION EXPRESSION saiora eaa e ea a aaa a 76 P2177 271168 0 2220 10 ARE NOU INESSE 76 DME QI IIS HOLD Seas hse d pain E 76 REIGHONGIODCKALONS erou hess tiet tan nesters setasaaaesaatiow EE eanisie aOR 76 TIO QVCO OCT U I Scu MIR aa n M DUM Seino MIENNE IM aos 76 BU TIC TONS isc MEC C PP 76 B iltin UCL ONS C OOBLH OU ci 3 sins sic Sr desto ed aneeshatti ea 78 25171128 Y ANCONS CONNU A Bnet Er pp 79 Buli Func ONS CONTIUCO T c 80 Bulk BET ITE TOI 20131171277 EET 81 INTEGRATING A DBUNIFIER APPLICATION IN TO YOUR APPLICATIONS 83 DBUnifier Processor DBF1000 Parameter Group sssssss mmm 83 DBUnifier Processor DBF1000 Parameter Descriptions eesssssss eene 83 DEFINING AUDIT LOGGING FOR DBUNIFIER APPLICATIONS ee eee eee eee eee een eaaet 85 Define AUC LOS Information Prompt Fleldss insectes aic ie RU ee names eap e sch edel UP Duties 85 Define
7. Separates connections Test The Test prompt field allows the following comparison tests EQ Equal NE Not equal GT Greater than LT Less than GE Greater than or equal LE Less than or equal LIKE Like pattern NLIKE Not like pattern Value The Value prompt field allows the entry of a Field Numeric Value or Character string that is wrapped in single quotes This is the value that is used in the comparison with the associated field Page 43 a a EES Define Relational Operators Command Keys Command Keys _ Description of Command Key F1l Help Help information has not yet been made available This command key 1s for future use F3 Exit The Exit command key exits from the Define Relational Operators display F4 Prompt The Prompt command key shows the list of possible values that can be assigned to the field F5 Refresh The Refresh command key clears the screen and resets the display to its initial values F8 Define Error The Define Error Message command key displays the Define Error Message Text screen Message F10 Command The Command command key displays a command entry line Which allows you to executed OS 400 commands F12 Cancel The Cancel command key exits the user from the Define Relational Operators display F24 More Keys The More Keys command key displays other command keys that are available Using More Than One Comparison Test When you use more than one comparison you need to tell DBUnifier how to connect t
8. TBL and returns a string that is the value of the first argument translated by using the contents of the table The returned value is a string with the same length as the first argument VoXLATE Accepts two or more character string arguments and returns a string that 1s the bit wise XOR logical exclusive or of the arguments This function takes the first argument string XOR s it with the next string and then continues to XOR each successive argument with the previous result If an XOR argument is encountered that is longer than the previous result the previous result is padded with blanks before the XOR operation If any of the arguments is variable length the maximum length is used as the length of the argument The final result is a string of type HEX with the same length as the longest argument Accepts a date time argument and returns the year part of the value The date time argument can be a date or timestamp field a date duration or timestamp duration field or literal or a numeric field or literal The returned value is of type BIN4 YEAR Page 81 Page 82 Integrating a DBUnifier Application In to Your Applications The DBUnifier Processor DBF1000 can be called directly from high level languages such as RPG ILE RPG 400 RPG and COBOL This allows the ability to integrate DBUnifier Application into your existing applications and processes There are examples of calling the DBUnifier Processor provided in fi
9. 1s pressed within the field cursor location The DBUnifier maintenance program displays this list of values in a selection window There can be up to 64 values defined for this list Define List of Values display DBUnifier version 4 2 Define List of Yalues 11 09 04 T2 Wa 32 Type choices sequence Number Field Name STE Tupe A Field Heading S State Province Frampt Screen Title Entorce Validation si ae KYES h0 Type List of Description More Fl Help EE Tres Jefine Error Message Fe4 More Keys CO Copyright PraData Computer Services Inc 2004 Define List of Values Prompt Fields Field Description of Prompt Field Prompt Screen The Prompt Screen Title prompt field allows the entry of the window title that will display when the List of Title Values prompt screen is displayed Enforce The Enforce Validation prompt field allows the entry of either Y ES or NO When YES is specified Validation validation for the input field being process is enforced by comparing it to the list of values defined When NO is specified list validation is not enforced Value The Value prompt field allows the entry of a Character string the character string does not need to be wrapped in apostrophes When the Enforce Validation prompt field is Y ES the value in the input field must be equal to one of the values defined within the list Description The Description prompt field allows th
10. A ENNIE 7 Select FalexXCommaud KEYS nido b oos bte el bebe lonas edo itat ance losiac de D ote eitis 53 COO IECIT DEO euet Se ote hee tte a eh Sees cna a f tle coca LAO elc o ie Le fete 54 Delect LIDA EP POMPE TE TOS aaepe ect cee treme nbi Motard acta terme Doct ea tdeo ab cies 54 NITE ANE T ao E PE 55 COOSA n Ie Ide eats is aI a tO AN ALIM lS DEED ELM IL DA oe LOL al te 56 Select ela TEOmpt Pleldsie ds Mustlitiiesii siue ieu die diste lc M tsa 56 Delectdtrem Command eyes eoe se ito Ut EE ae ented Ranks Lok ait te an ea 57 DISPEAY SCREEN DA VOUT 2 uiiititoeitesseelidt cepe ive nee adie hs eek 58 Display Screen Layout Command Keys acted ioa ire bob late eh d e uam v adu E eda nase 58 DEFINE EXIT PROGRA VIS a a a Soa eeu i aaa 59 Define Exit Probrams Prompt FACIL AS se ceils heaters be eo AEE TEE hea avis lal ots lala ED ath 59 Define Exit Programs Command Keys siam tate ite ab diuidi dedi ibas eee ae 60 SOm DIE EXT TVOS AMS s tente pte t ettet reb Eie estote iste tes festes tten e tertio enel EN e oe e ner Poire hes 60 SAVING A DBUNIFIER APPLICA TION ee eee ee eee eee eee eee teneo esee theses sees eeseeesse ese se ses se esse oeees 61 Exit this Application Prompt Fields aiii Eo EUER n 61 EXU this Application C omman a dysie edocet tesa p Ete ee auetoritate d tat ossia deut 62 COPYING A DBUNIFIER APPLICATION e eee eeeeeee eee e o eese ese seeesseesee sese sese sese se sese ose esse eese seeeos 63 Copy DB Unifi
11. F1 Help Help information has not yet been made available This command key 1s for future use F3 Exit The Exit command key exits from the Copy DBUnifier Application display F5 Refresh The Refresh command key clears the screen and resets the display to its initial values F12 Cancel The Cancel command key exits the user from the Copy DBUnifier Application display Page 65 Printing DBUnifier Applications Definition You can print the DBUnifier Application Definition The printout tells you what information is used to process the application When you select option 6 Print on the Work with DBUnifier Applications display and press the Enter key the application definition is printed immediately i Work with DBUnifier Applications display DB nifier version 4 2 Work with DBUnifier Applications 11 09 04 16 12 06 LID 242 Bee 4 X LIBL Mame LIBL F4 Subset lx KALL Name generic Position ta starting characters ptions and ODBUnifier Application press Enter Change J GCopy hn Display b Print 4 Run Application Library Text EM AMFLE OBUNIFIER An Example DbBlinifier Application EM LIST OBUNIFIER Example Selection List Of Presidents OUTPUT OBUNIFIER Example Prompt t Output Queue SAMPLE OBUNIFIER STATE DBUNIFIER State File Maintenance STATECODE DBLUNIFIER ist of State Go Fl Help F3 Exit F4 Prompt Tres F24 Mor C Copyright PraData Computer Services Inc 2004 The following page shows an example of
12. Field Usage is defined Edit Codes can be assigned to numeric values and Extended field Attributes are maintained from this screen _ Define Screen Field Details display DBl nifier version 4 2 11 08 04 fie Sorg Type sequence number far the up to 500 fields to appear in the application press Enter Field Text ULTFLAG EE NAME Name ALT NAME Alternate TITLE Title COMPANY RHDDRI ADDR HDDR3 Address CITY LITE Eo STATE State Province COUNTRY Country 2 POS AL Code H I3 la I I lH lH H H hH hH H IH tu Ii l a Im EI 10 Mare r2d More Keys PD D b DIDb D a a Ss AD Define Screen Field Details Prompt Fields Field Description of Prompt Fields Seq 0 9999 You select a field by specifying a sequence number from 0 to 9999 in front of each field you want to select Use the numbers in ascending sequence You can delete a field from displaying by removing the number you specified in front of it To change the sequence of the selected fields just change the numbers Text The default Field Label Text is retrieved from field text that is defined by the external file description The text is the label that will be displayed when DBUnifier is executed and the Detail portion of the screen is processed Usage Usage determines whether input is allowed into this field when being displayed The default usage is O utput Only To allow input into this field change the usage pro
13. Master File Maintenance Type options press Enter Delete Flag Record Key Name po ee Alternate Name Title ae Company Name AF thhnht EhEEhENEEhEEhbtt a Ac cl ress 1 Ee Geo a wae G Oe a ee ee ee a Address HZ zx 2 4 oe Paes E OO a aa a ey a Address Bo EF ew w E ao Fee City a Me Stater Province Countr U ao o a n o ooo ee Postel Code 46e 4o WU i KKRKKRERKK Phone Number Eu Fax Number More Fl help User Define Message Line Display Screen Layout Command Keys Command Keys _ Description of Command Key F1l Help Help information has not yet been made available This command key is for future use F3 Exit The Exit command key exits from the Display Screen Layout display F5 Refresh The Refresh command key clears the screen and resets the display to its initial values F12 Cancel The Cancel command key exits the user from the Display Screen Layout display Page 58 Define Exit Programs The Define Exit Programs display allows you to define User Exit programs that will be executed at special exit points when a DBUnifier Application is being processed Exit points are provided Before Data is Displayed on the detail portion execution process and Before the Record is Updated when records are being maintained Define Exit Programs display DBUnifier version 4 2 Define Exit Programs Type choices Program to call before data is displayed Program amp wo
14. Start DBUnifier Application Processor command display The Prompt command key shows the list of possible values that can be assigned to the field The Refresh command key clears the screen and resets the display to its initial values The All Parameters command key show entry field for all parameters including those not selected by entries on previous parameters and those commonly used The Keywords command key toggles between the version of the prompt display that shows possible choices and the version that show parameter keywords The Cancel command key exits the user from the Start DBUnifier Processor command display The How to use this display command key shows help for the prompt display The Command String command key shows the resulting command as it would run with the parameter values currently entered The Error Messages command key shows all error message that pertain to the command being entered The Complete Command command key indicates all values needed have been entered and requests the system to run the command without showing additional displays The More Keys command key displays other command keys that are available Page 69 Run DBUnifier Processor RUNDBUAPP command The following is the Run DBUnifier Processor RUNDBUAPP command that can be access in CLP Control Language Programs Run DBUnifier Processor display I EE EM E rur r CRUNDBUAPP Type choices Labe
15. WU a als Name F for eee Paris E KLIBL Mame LIBL Program to call before record is updated Propram G a we Sse i NORE Name F4 for Libra S a Q Hu oa KLIBL Mame LIBL Define Exit Programs Prompt Fields Field Description of Prompt Field Program To Call The Program to Call Before Data is Displayed prompt field defines the User Defined Exit program that is to be Before Data is executed prior to the record field information being displayed on the detailed portion of the DBUnifier Displayed Application that is being processed To choose from a list of PGM program objects position the cursor on the Program prompt field and press the F4 Prompt command key Library Library denotes the library where the PGM program object resides To choose from a list of libraries position the cursor on the Library prompt field and press the F4 Prompt command key Program to Call The Program to Call Before Record is Updated prompt field defines the User Defined Exit program that is to be Before Record is executed prior to the record being updated when the DBUnifier Application is processed To choose from a list Updated of PGM program objects position the cursor on the Program prompt field and press the F4 Prompt command key Library Library denotes the library where the PGM program object resides To choose from a list of libraries position the cursor on the Library prompt field and press the F4 Prompt command key Page 59 Defi
16. a character or hexadecimal field containing 0 ZONE the external form of a time or a time literal The returned value is of type TIME TIMESTP Accepts one or two date time arguments and returns a timestamp USER Returns the user profile name of the job in which the query is running Used to identify a list of allowed values for a field or expression VALUES must be specified as the right side of a relation whose operator VALUES is equal The allowed value arguments must be character string or numeric literals to match the type of the field or expression specified as the left side of the relation Accepts a numeric argument and returns the variance of its argument for the VoV AR group of records defined by the GRPFLD parameter The argument must be a field name or an expression not a literal Used to specify a pattern that performs a wildcard scan of the character or hexadecimal field or string expression except for expressions made up of a single character string literal that must be specified as the left side of the relation WLDCRD must be specified as the right side of a relation whose operator is equal The pattern string argument must be a character string DBCS or graphic literal to match the left side of the relation The wild characters argument is an optional parameter that specifies what wildcard characters are used in the pattern string WLDCRD Accepts a character string argument and the name of a table object
17. additional displays The More Keys command key displays other command keys that are available Page 73 Run DBUnifier Detail Processor RUNDBUDTL command The following is the Run DBUnifier Detail Processor RUNDBUDTL command that can be access in CLP Control Language Programs Run DBUnifier Detail Processor display Label Member Relative Type choices Application name Library Execution File Mame Library name mode name name EQ kt Record Number Return Key Pressed Comment eee ee ar e a EE Run DBUnifier Detail RUNDBUDTLI xl IBL XIMOUTHBY KDEFAULT LIBL KFIRST Name Mame CURLIB LIBL KINQUIRY UPODATE FULL Mame DEFAULT Name GURLIG Name FIRST Number Character LIBL Value 0 L m n 0 L Bottom f F5 Refresh BEIM Fl3 Hou to use this display Run DBUnifier Detail Processor RUNDBUDTL command Prompt Fields Field Application name Application Library name Execution mode File name File Library Description of Prompt Field The Application Name prompt field specifies the DBUnifier Application name to be processed The Library Name prompt field qualifies the library from which the DBUnifier Processor will access the application definition Special value LIBL tells the processor to search all the libraries in the job s library lis
18. adds to the database records File name The File Name prompt field specifies the database file to be accessed by the DBUnifier Processor By using the default value DEFAULT the file that was specified when the application was defined is used File Library The File Library Name prompt field qualifies the library where the file will be accessed Special value LIBL Member name tells the processor to search all the libraries in the job s library list until the first match is found Special value CURLIB checks the current library for the job to locate the file to process The Member Name prompt field specifies the member name of the file you would like to process The default value for this field 1s FIRST which denotes to the DBUnifier Processor to use the first member in the file defined Page 70 Query Selection Expression Relative Record Number Data Returned The Query Selection Expression prompt field specifies the selection values used to determine the records that are available to the DBUnifier Processor The default value ALL selects all records in the database file to process The Relative Record Number of the record from the file being processed that was selected from the DBUnifier Processors Multi Record Display screen The return variable is a 10 0 digit integer For RPG amp RPG 400 the return variable can be defined as a BINA field The Data Returned is data in the record from the file being process that was selec
19. have located the field you want type a 1 in the Opt option field next to the field name press the Enter key to return to the Define Database Validation display The field you selected will be returned to the Field prompt field Page 56 Select Field Command Keys Command Keys F1l Help F3 Exit F4 Prompt F5 Refresh F10 Command F12 Cancel F24 More Keys Description of Command Key Help information has not yet been made available This command key 1s for future use The Exit command key exits from the Select Field display The Prompt command key shows the list of possible values that can be assigned to the field The Refresh command key clears the screen and resets the display to its initial values The Command command key displays a command entry line Which allows you to executed OS 400 commands The Cancel command key exits the user from the Select Field display The More Keys command key displays other command keys that are available Page 57 Display Screen Layout The Display Screen Layout display shows you an example of how the fields and labels will be presented on the detail portion of the DBUnifier Application The window label display screen title window footer fields and labels are presented as they will appear when the DBUnifier Application is being processed Use the page up and page down keys to display multiple pages Display Screen Layout display An Example DBUnifier Applicaton Presidents
20. in The following is a sample of the Select Library display u Select Library display DBUnifier version 4 2 Select Libraru 11 09 04 15 45 23 Puseitinh fn 24 5 i xL IBL on and Library Library LIBL CURLIEB USRLIBL ALLUSR ALL CGULIEB DFULIE HOSULIEB LIBRARY HSDHLIB More Fi Help Seb fres 12 Cancel F24 More Keys C Copyright ProData Computer Services Inc 2004 Select Library Prompt Fields Field Description of Prompt Field Position To The Position To prompt field is used to move position the list of library names so that it starts with a particular name Opt The Opt prompt field selects the library you would like returned to the calling program Once you have located the library or group of libraries you want type a in the Opt option field next to the library name press the Enter key to return to the Define Database Validation display The library you selected will be returned to the Library prompt field Page 54 Select Library Command Keys Command Keys _ Description of Command Key F1l Help Help information has not yet been made available This command key 1s for future use F3 Exit The Exit command key exits from the Select Library display F4 Prompt The Prompt command key shows the list of possible values that can be assigned to the field F5 Refresh The Refresh command key clears the screen and resets the display to its initial values F10 Command The Comman
21. of an application name in the Position to prompt and then press the Enter key to show the desired subset list of application names Selecting a Library The library name indicates where you want to store a new application or where an existing application is already stored To look at or use a different library or list of libraries from which you can choose do either of the following Type the name of the library a generic library name or a special library name in the Library prompt and press the Enter key A list of all the applications in that library or group of libraries for which you have the authority to use is shown If there are multiple libraries the applications are listed in alphabetical order within each library The libraries themselves are shown in alphabetical order if ALL ALLUSR or a generic library name is specified If you specify LIBL or ALLUSR the libraries are shown in the order that they are listed in the library list Move the cursor to the Library prompt and either leave the prompt blank or type a generic name or a special library name the press F4 to list the libraries A list of the libraries that you are authorized to use is shown Page 6 DBUnifier Application Processor Functionality This chapter describes the functionality of the DBUnifier Application Processor The application processor accesses a DBUnifier Application and allows you to view and maintain information from a database file Functionality is de
22. of the definition options needed to define your application The only definition step that you are required to select is Specify File Selections You do not have to select all of these definition steps use only those that you need Most of these steps do not have to be done in specify order although the order shown is recommended when you need to use most of them Each step you select is a separate process that shows you one or more displays as you need them Define DBUnifier Applications display DBUnifier version 4 2 Define DBlinitier Application 11709 0904 Teria ApoLicatioma u S EXAMPLE POTION Sza s n GRECALE Library WE DBUNIFIER Detinne result fields Define initial multi record display specify screen options Define screen field details Define exit programs Bottom Fl Help FasEXI fres Figi Command Entry Fed More Keys C Copyright ProData Computer Services Inc 2004 The Define DBUnifier Application display is the primary display from which you start define your application Making your Choices To select the options that you want to use from those listed in the DBUnifier Definition Option column type a 1 in the Opt option column beside each of those options then press the Enter key The displays for the options you select are then shown one after the other so you can create those parts of the application Following are brief descriptions of each of the definition steps Specify file selections This optio
23. or DBUnifier Application and Define multiple validity checks for a field Define Extended Field Attributes display DBUnifier version 4 2 Type choic sequence Number 6 piel Meme ol x X 8m 3 DLTFLAG Field Heading Allow Par ee Y Initial Valise n Define Prompt Program Validty Checks Fl help S Es 1 F4 Prompt C Copyright ProData Computer Services Inc 2004 Define Extended Field Attributes Prompt Fields Field Description of Prompt Field Allow Lowercase Allow Lowercase denotes whether to allow lowercase input into the field when usage is input Uppercase input is forced when the value is N o Initial Value Initial Value determines the default value that is assigned to the field when an Insert action is requested from the DBUnifier Application processor Define Prompt Specifying a Y es in the Define Prompt Program shows the Define Prompt Program for Field display You are Program able to denote an associated Prompt Program or DBUnifier Application that will be invoked when the F4 key is pressed on the field cursor location Validity Checks Validity Checks prompt field performs the following action Relational Operators Define Relational Operators display is shown 2 Range Define Range display is shown 3 List of Values Define List of Values display is shown 4 Database Validation Define Database Validation display is shown
24. result field by entering a name in the Field column on the Define Result Fields display You cannot specify the name of a field that exists in your selected file the list in the lower part of the display shows you these field names To page through the field list position the cursor in the list part of the display and use the Page Up and Page Down keys You specify the length and number of decimal positions for a numeric result field by filling in the Len and Dec prompts on this display The expression entered 1s used as the column label Field Text for the result field Page 22 Result Field Name Since DBUnifier result field names are similar to database field names create them according to the following rules e Start the name with an alphabetic character A through Z or and use no more than 9 alphanumeric characters A through Z 0 through 9 or _ for the remaining characters Do not use blanks within the name e Do not use any names from the list on the lower part of the display or the names of other result fields Expressions An expression is a representation of a value with field names constants functions or keyword appearing alone or in combination with operators It can be either a numeric character date time or timestamp expression e A numeric expression assigns numbers or performs an operation calculation on them Numeric expressions can contain the following operators Addition Subtracti
25. the cursor on the Return Field prompt file and press the F4 Prompt command key Page 41 Program Name Return Offset Return Length Program Name defines the User Defined Prompt Program that is called for the selection of a replacement value for the screen field being processed To choose from a list of program objects position the cursor on the Program Name prompt field and press the F4 Prompt command key Return Offset defines the Offset Buffer Position of the value that is being returned from the User Defined Prompt Program Which is used to replaces the value of the field on the screen Return Length defines the length of the value starting with the Offset Buffer Position that is being returned from the User Defined Prompt Program Which is used to replace the value of the field on the screen Define Prompt Program for Field Command Keys Command Keys F1l Help F3 Exit F4 Prompt F5 Refresh F10 Command F12 Cancel F15 Import F24 More Keys Description of Command Key Help information has not yet been made available This command key is for future use The Exit command key exits from the Define Prompt Program For Field display The Prompt command key shows the list of possible values that can be assigned to the field The Refresh command key clears the screen and resets the display to its initial values The Command command key displays a command entry line Which allows you to executed OS 400 commands The Cance
26. to the calling program This option is available in all execution modes 2 Change Change displays the Record Detail portion screen of the application processor If there are fields that have been defined as input capable those values are changeable This option is only available when the application processor is invoked with UPDATE FULL or NODELETE execution modes 4 Delete Deletes displays the Confirm Deletion of Record display After you verify this is the correct entry you would like deleted Press the Enter key to confirm deletion of the record If a User Defined Exit program has been defined for the Program to call before record is updated exit point this program will be executed prior to the deleting of the record This option 1s only available when the application processor is invoked with FULL execution mode Page 7 5 Display Display displays the Record Detail portion screen of the application processor The fields selected for display are shown If there are no fields selected in the Define Screen Field Details display this option 1s will not be made available otherwise this option 1s available in all execution modes Initial Multi Record Display Subfile Command Keys Command Keys F1l Help F3 Exit F5 Refresh F6 Set Key Position F9 Insert Record F12 Cancel F15 Define Search F16 Perform Search F24 More Keys Description of Command Key Help information has not yet been made available This comma
27. was not found in STATEPF file Please corre ct and retry the operations End o f Re poar E 999 Page 67 Running a DBUnifier Application Running a DBUnifier Application consists of telling the DBUnifier Processor to use the Application definition to access the data you want to process There are multiple ways to run an application You can select option 9 Run from the Work with DBUnifier Applications display Use the Start DBUnifier Processor STRDBUAPP command Use the Run DBUnifier Processor RUNDBUAPP command within a CLP Control Language Program call the DBUnifier Processor directly from high level languages such as RPG ILE RPG 400 RPG or COBOL Use the Start DBUnifier Detail Processor STRDBUDTL command Use the Run DBUnifier Detail Processor RUNDBUDTL command within a CLP Control Language Program or call the DBUnifier Detail Processor directly from high level languages Start DBUnifier Processor STRDBUAPP command The following is the Start DBUnifier Processor STRDBUAPP command that can be access directly or by selecting option 9 Run from the Work with DBUnifier Applications display Start DB Unifier Processor display Start DBUnitier Processor rocessor 5 TROBUA FF 1 Type choices ESS Application name gt QRAAMPLE PET Library Name Ec DBIINIFIER Name CURLIB LIBL Execution MODE lt lt s BE D
28. Audit Log Information Command Keys sssssssssssssseeeeeeeeee ne nnne nennen nenne rhe n nenne senes 86 IV Software License Agreement This software system consists of computer software and documentation It contains trade secrets and confidential information which are proprietary to ProData Computer Services Inc ProData Its use or disclosure in whole or in part without the express written permission of ProData is prohibited This software system is also an unpublished work protected under the copyright laws of the United States of America If this work becomes published the following notice shall apply Copyright 1993 ProData Computer Services Inc All Rights Reserved O O O Before You Start DBUnifier was developed to assist programmers and power users with the ability to create interactive applications from DB2 400 database information You are able to create Selection Lists F4 Lists Processes Work with Subfile Processes Inquiry Applications and File Maintenance Applications with Field level validations Versions amp Releases DBUnifier is available on the iSeries for operation system V4R2 and above Be sure you have the correct versions for your machine before you start DBUnifier Applications You use DBUnifier to view and maintain information from database files The file that DBUnifier uses to process that information and how the information is to be displayed and validated is stored in a DBUnifier Application A
29. DBUnifier Application is an object with type USRSPC and it contains all the details that DBUnifier needs to process the file in the way you specify To create a DBUnifier Application you follow a sequence of displays that guide you through the process of defining and saving an application Once you have defined your application you can execute it to produce the desired results Page Installing Saving and Deleting DBUnifier Installing DBUnifier Use the Load Run LODRUN command to perform an initial install of DBUnifier Follow the two step installation process l Sign on the iSeries 400 system as security officer QSECOFR 2 Install the DBUnifier library with the Load Run command Type LODRUN and press the F4 to prompt the following options Note Replace OPTO1 with the name of the device containing the distribution media for DBUnifier Lond and Run Command display load and un CLODRUN Heroi Name TAP DKT OPT Bottom F4 Prompt Fo Hefresh Lance l Fi3 How to use this display keys Page 2 Saving DBUnifier Use the Save Library SAVLIB command to save DBUnifier Follow the three step save process 1 Sign on the iSeries AS 400 system as security officer QSECOFR 2 Use the Initialize Tape INZTAP command to initialize a tape to hold saved version of DBUnifier 3 Save the DBUnifier with the SAVLIB Command Ty
30. P Uo CR Cen Te CE Can CS ae ha ee a ee Te DDD DD a a a Lil D m More Fl Help Sesso Flb5b Edit Code Tres Fe4 More Keus CO Copyright PraData Computer Services Inc 2004 Define Initial Multi Record Display Subfile Prompt Fields Seq Description of Prompt Field 0 9999 You select a field by specifying a sequence number from 0 to 9999 in front of each field you want to select Use the numbers in ascending sequence You can delete a field from displaying by removing the number you specified in front of it To change the sequence of the selected fields just change the numbers Page 28 Define Initial Multi Record Display Subfile Command Keys Command Keys F1l Help F3 Exit F5 Refresh F10 Command F12 Cancel F16 Edit Codes F18 Files F24 More Keys Description of Command Key Help information has not yet been made available This command key is for future use The Exit command key exits from the Define Initial Multi Record Display The Refresh command key clears the screen and resets the display to its initial values The Command command key displays a command entry line Which allows you to executed OS 400 commands The Cancel command key exits the user from the Define Initial Multi Record Display The Edit Codes command key allows you to assign an edit code for numeric values The Files command key shows the Display File Selections display The More Keys command key displays other command keys t
31. UO MUS SEULL RINUULR T o KUFURE s SFULL File Name e on aer k adea C KDEFAULT Mame DEFAULT LISP ari name AS 2 E Tl LIBL Mame CURLIG LIBL Member mame 2 2 ew ew we we a a FIRST Mame FIRST Query select expression ALL Bottom F3 Exit F4 Prompt fres 12 Cancel Fis How to use this display Fe4 More keys Ik _ Start DBUnifier Processor STRDBUAPP command Prompt Fields Field Description of Prompt Field Application The Application Name prompt field specifies the DBUnifier Application name to be processed name Application The Library Name prompt field qualifies the library from which the DBUnifier Processor will access the Library name application definition Special value LIBL tells the processor to search all the libraries in the job s library list until the first match is found Special value CURLIB checks the current library for the job to locate the application definition Execution mode The Execution Mode prompt field tell the DBUnifier Processor the mode the application is to be processed The possible modes are INQUIRY for inquiry mode only FUPDATE which allows changes to be made to the database records FULL which allows changes inserts adds and deletions to the database records and NODELETE which allows changes and inserts adds to the database records
32. Uo eo cvv ener eco Tees 14 Startine DBUniher Application Definitionen eds tede n ur e e ey Red erben His eie tede ee odia 14 Selecting Definition Steps When Defining a DBUnifier Application esses 15 SPECIFYING AND SELECTING A EILEE ckie tees eve E Eee ee 17 SPECIO TALE SCLC CMON RT P A a A 17 CHOOSING OQ IB teas ecu te gies Buide ee ue Mee ELE 16 COOSA OY s Ba aa he rat Nueces aie DULL LA cnc RA aa Ne at 18 Coon nE OM 21571012 ERE 18 SClECUNO 19 SOLEDAD SR eadeni ENE Duet mE b IE MM M a e E E A 21 DEFINING RESULT EIELDS uo uiae co dE heheheh eens thle Deo bo ad eot COE 22 Creatine Resths Fields Geddes ber biel siasencl a Gerade Letra dae Sedi Lee Cer tend ssstusla tebe setae umts 22 kest Piela Name cenna Sess hse ae ea Be cet a a a tat ae Ta 23 PVD CSS TOUS E E VO OEE N O E O 23 NUME IC TE ODFOSSIONS oen raton Piaceinats sedated EE ned sgh each re E ruben ate Shaciceahh eed oh Uo M E nedagduh Modi ta EE 24 Character EXDPEOSSIQS ee Nah a ik ae Sas Na Ga sae ae co AM Iur MEL Mend Gn 24 Character PUNCH ONS lilo en ae I 25 Date Time and Timestamp EXpressions sis ee ii ease ait he Ada eae Ai eae ae 23 REMOVING RESUS TITOLAS vers OEME 27 DisplayineTilesSeleeted sie E A AN 2 DEFINING INITIAL MULTI RECORD DISPLAY SUBFILE eere eere eere 28 Define Initial Multi Record Display Subfile Prompt Fields 2 ccc ccc cece cece 28 Define Initial Multi Record Display Sub
33. ames you can press F4 with the cursor at the File prompt The Select File display is shown and on this display you can choose a file for you application The following is a sample of the Select File display Nu Select File display s DBlinifier version 4 2 11 69 04 15 46 51 LIDCOPH Z 2G oov Soh LIBL Jame LIBL F4 for list SUDSBI o 3 X of 2 AIMIEEE Jame generic POSLI DON TO 03 xou 3i ing characters Tupe option and File press Upt File Library a STHRHERE DBIUNIFIER Code Fhusical Fil Code Fhusical Fil Code Fhysical Fil sl ALEPEr MINE Ss ALERE WEBSTER DO m rmn ID m m Bott ori Fi Help xj fres l2 Cancel F24 More keys Conor o PraData Computer Services Inc 2004 Select File Prompt Fields Field Description of Prompt Field Library The Library prompt field is used to see the files that exist in a different library or group of libraries Subset The Subset prompt field is used to see a subset of the files that exist in the library or library group specified Position To The Position To prompt field is used to move position the list of file names so that it starts with a particular name Opt The Opt prompt field selects the file you would like returned to the calling program Once you have located the file you want type a 1 in the Opt option field next to the file name press the Enter key to return to the Define Database Validation display The file you selected will be returned to the File p
34. argument can be a date or timestamp field a character or hexadecimal field containing the external form of a date a date literal or a numeric field or literal value 1n the range 1 3 652 059 The returned value is of type DATE Accepts a date time argument and returns the day part of the value The date time argument can be a date or timestamp field a date duration or timestamp duration field or literal or a numeric field or literal The returned value is of type BIN4 VoDATE VoDAY Accepts a date time argument and returns an integer representation of the date The date time argument can be a date or timestamp field a character or hexadecimal field containing the external form of a date or a date literal The returned value is of type BIN4 DAYS Accepts a numeric argument and returns a character representation of its numeric value not including the sign or a decimal point The result is tagged with the CCSID of the current job For example DIGITS 1 5 returns the character string 15 DIGITS Accepts an integer argument and returns a labeled duration of days The DURDAY integer argument for this function can be a numeric expression a field or a literal Accepts an integer argument and returns a labeled duration of hours The DURHOUR integer argument for this function can be a numeric expression a field or a literal Accepts an integer argument and returns a labeled duration of microseconds DURMICSEC The i
35. ations definition Displaying File Selected The Display File Selections display appears when you press F18 Files for a display where F18 1s listed on the bottom of the display The Display File Selections display shows the file that you selected for use in the application The information on this display is for your information only it cannot be changed here a Display File Selections display DBUnifier version 4 2 Display File Selections continue File Library Member Format EARMPLELF LIBL KF IR ST EARMPLETtZ Fi help Raa bE F4 Prompt F5 Retresh C Copyright ProData Computer Services Inc 2004 Pressing Enter F3 Exit or F12 Cancel will return you to the previous display 11 05 04 Page 27 Defining Initial Multi Record Display Subfile The Define Initial Multi Record Display allows you to select and sequence the fields that you want to display on the Initial Mult Record Display Subfile and the sequence you want the fields to appear You are also able to add edit codes to numeric fields for displaying Define Initial Multi Record display DBlinifier version 4 2 Define Initial Multi Record Display 11 085 04 10 15 14 Type appear in the application press Enter Field Text Tu KEW Record Key NAME Name TITLE Title NEWFIELD substr name 1 10 DLTFLAG HL TNRME Alternate Mame COMPANY Company Name ADDR ADDRe2 AUORS Address CITY City STATE state Province COUNTRY Country m P
36. can be assigned to the field F5 Refresh The Refresh command key clears the screen and resets the display to its initial values F8 Define Error The Define Error Message command key displays the Define Error Message Text screen Message F10 Command The Command command key displays a command entry line Which allows you to executed OS 400 commands F12 Cancel The Cancel command key exits the user from the Define Range display F24 More Keys The More Keys command key displays other command keys that are available Using More Than One Range Test When you use more than one range test DBUnifier will treat each test independent of the other range tests Fields as Range Values If you use a field as a value that is in the Value column on the display the field can be any field that has been previously defined in the DBUnifier Application Also the fields being compared do not have to be the same length and numeric fields do not have to have the same number of decimal positions Character Constants as Range Values A character constant is simply characters enclosed in apostrophes The apostrophes are important because DBUnifier assumes that any group of character not enclosed by apostrophes is a field name The characters in the constant can be any combination of letters numbers or special characters such as that might be found in the tested field You must use apostrophes around a character constant even if it contai
37. d command key displays a command entry line Which allows you to executed OS 400 commands F12 Cancel The Cancel command key exits the user from the Select Library display F24 More Keys The More Keys command key displays other command keys that are available Page 55 Choosing a Field To choose a field that will be used for validation by the input field move the cursor to the Field prompt and type the name of the field If you want to choose a field from a list of fields that are in the specified file you can press F4 with the cursor at the Field prompt The Select Field display is shown and on this display you can choose a field for use as validation of the input field The following 1s a sample of the Select Field display Select Field display OBUnifier version 4 2 File 1 STATEPF Librar 4 cw r4 LIEL Type options press Enter Oot Field OLTFLG STATE DESC TARATE ax ACOUSR Added By User rt rt m D D ct oct mp et cH DD iam rt Tm Lum Em m T a Lu ct T iscriptiaon en cn c3 4 m oo Tl m D ID I I m m ADOP GM AUDODAT ADOT IM Add Program Add Date Add Time D 3 TI IP D LSTUSR Last Update User Fl Help X ELE F4 Prompt CJ Copyright PraData Computer Services Inc 2004 Select Field Prompt Fields Field Description of Prompt Field Opt The Opt prompt field selects the field you would like returned to the calling program Once you
38. d returns the minute part of the value The date time argument can be a time or timestamp field a time duration or timestamp duration either field or literal or a numeric field or literal The returned value is of type BIN4 MINUTE Accepts a date time argument and returns the month part of the value The date time argument can be a date or timestamp field a date duration or timestamp duration field or literal or a numeric field or literal The returned value is of type BIN4 MONTH Accepts a list of two or more arguments and returns the first non null value from the list The items in the argument list can be fields or literal values of any type The type of the returned value is that of the item selected from the list NONNULL Accepts a character or hexadecimal string argument and returns a string that NOT is the bit wise NOT logical not of the argument The returned value is a string of type HEX with the same length as the argument Page 79 Built in Functions continued Accepts no arguments It is used to select or omit records based on whether or 0 ANULL not a field in the record contains a null value Accepts two or more character string arguments and returns a string that 1s the bit wise OR logical inclusive or of the arguments This function takes the first argument string OR s it with the next string and then continues to OR each successive argument with the previous result If an argument is e
39. e available Page 31 Specify Screen Options Select Screen Size The Select Screen Size display allows you to select the size of the Multi Record Display screen By pressing the F13 Select Screen Size command key from the Specify Screen Options display the following window will appear showing you the current screen size that has been assigned and allow you to select a different screen size Select Screen Size display DBlinifier version 4 2 specify Screen Uptions 11 08 04 11 34 15 Tupe ap 1 Se 6 Lo i go ico il wu wwlo O oo 1 Upt E E B B Or LLI LO MI Lo i om Lh NM MH MN mM o tm am n m Mi Md Mi Fe MESES 1 un Fi Help sition Fi Cancel Fl5 Deti Bott om Foh Refres Fiv Cancel Fl Help C opyright Probata Computer Services Inc Select Screen Size Options Options Description of Option 1 Select Bottom Fe4 More Keys 4004 Select a screen size for the Initial Multi Record Display By typing a 1 by the screen size and pressing the Enter key the first entry selected will define which screen size to display Select Screen Size Command Keys Command Keys Description of Command Key F3 Exit The Exit command key exits from the Select Screen Size display F5 Refresh The Refresh command key clears the screen and resets the display to its initial values F12 Cancel The Cancel command key exits the user from the Select Screen Size display Page 32 Spec
40. e default Field Label Text is retrieved from field text that is defined by the external file description The text is the label that will be displayed when DBUnifier is executed and the Detail portion of the screen is processed Page 36 Page 37 Define Screen Layout Command Keys Command Keys F1l Help F3 Exit F4 Extended Attributes F5 Refresh F10 Command F12 Cancel F13 Display Screen Layout F24 More Keys Description of Command Key Help information has not yet been made available This command key is for future use The Exit command key exits from the Define Screen Layout display The Extended Attributes command key shows the Define Extended Field Attributes display The Refresh command key clears the screen and resets the display to its initial values The Command command key displays a command entry line Which allows you to executed OS 400 commands The Cancel command key exits the user from the Define Screen Layout display The Display Screen Layout command key shows a sample of how the detail portion of the DBUnifier Application will appear when being processed The More Keys command key displays other command keys that are available Page 38 Defining Extended Field Attributes The Define Extended Field Attributes display allows you to define whether lowercase characters can be input into a field The initial default value of a field when a new record is being inserted an associated prompt program
41. e entry of a character string that gives a more detailed description of the value used for validation S e P Page 48 i Define List of Values Command Keys Command Keys F1l Help F3 Exit F4 Prompt F5 Refresh F8 Define Error Message F10 Command F11 Center F12 Cancel F15 Import F24 More Keys Description of Command Key Help information has not yet been made available This command key 1s for future use The Exit command key exits from the Define List of Values display The Prompt command key shows the list of possible values that can be assigned to the field The Refresh command key clears the screen and resets the display to its initial values The Define Error Message command key displays the Define Error Message Text screen The Command command key displays a command entry line Which allows you to executed OS 400 commands The Center command key centers the text for the field where the cursor is position when the key is pressed The Cancel command key exits the user from the Define List of Values display The Import command key displays the Import List of Values From DBUnifier Application display screen From that screen you are able to import the List of Values for an existing DBUnifier Application The More Keys command key displays other command k
42. e first record in the file is processed Start DBUnifier Detail Processor STRDBUDTL command Command Keys Command Keys F3 Exit F4 Prompt F5 Refresh F9 AII Parameters F11 Keywords F12 Cancel F13 How to use this display F14 Command String F15 Error Messages F16 Complete Command F24 More Keys Description of Command Key The Exit command key exits from the Start DBUnifier Detail Processor command display The Prompt command key shows the list of possible values that can be assigned to the field The Refresh command key clears the screen and resets the display to its initial values The All Parameters command key show entry field for all parameters including those not selected by entries on previous parameters and those commonly used The Keywords command key toggles between the version of the prompt display that shows possible choices and the version that show parameter keywords The Cancel command key exits the user from the Start DBUnifier Detail Processor command display The How to use this display command key shows help for the prompt display The Command String command key shows the resulting command as it would run with the parameter values currently entered The Error Messages command key shows all error message that pertain to the command being entered The Complete Command command key indicates all values needed have been entered and requests the system to run the command without showing
43. e or more concatenation operations An example usage of concatenation is Value 1 Value 2 Page 24 Character Functions Character expressions can include the character functions SUBSTR DIGITS and VALUE SUBSTR Function The SUBSTR function returns part of a character value The form is SUBSTR value offset length e Value is the name of a character field a character expression or a character constant e Offset is the starting character position within the field or character constant An expression can also be used for the offset e Length is the number of characters that make up the substring An expression can also be used for the length e You must use commas between the substing elements blanks are allowed after the commas e Ifthe Offset and Length values cause the substing to exceed the right end of the field you will receive an error message DIGITS Function The DIGITS function returns a character representation of a number The form is DIGITS expression e The argument must be an integer or decimal value The result of the function is a fixed length character string e The result is a string of digits that represents the absolute value of the argument without regard to its scale The result does not include a sign or a decimal point VALUE Function The VALUE function can be used in any type of expression character numeric date time or timestamp The VALUE function VALUEX x y returns the first argument that
44. e that pertain to the command being entered The Complete Command command key indicates all values needed have been entered and requests the system to run the command without showing additional displays The More Keys command key displays other command keys that are available Page 71 Start DBUnifier Detail Processor STRDBUDTL command The following is the Start DBUnifier Detail Processor STRDBUDTL command that can be access directly Start DBUnifier Detail Processor display Cc UBUnitier Detail STROBUDTL Type choices pec Application name Name Library Execution File Name Library Member name d A Relative Record Number LIBL VEBCL E name made LIBL x IN GUT RY DEFAULT LIBL KFIRST Name CURLIB KINQUIRY UPDATE Mame DEFAULT Name CURLIB Name FIRST Number LIBL name Bottom this display Fl3seHnu c Start DBUnifier Detail Processor STRDBUDTL command Prompt Fields Field Description of Prompt Field Application The Application Name prompt field specifies the DBUnifier Application name to be processed name Application The Library Name prompt field qualifies the library from which the DBUnifier Processor will access the Library name Execution mode application definition Special value LIBL tells the processor to search all the libraries in the job s libra
45. efined and the enter key 1s pressed the application processor searches for a matching entry in the database being processed When a matching record is located the Initial Multi Record Display Subfile is reloaded starting with the matching record The Define Search display is only available when the Query Selection Expression is ALL m Define Search display DBlinifier version 4 2 Define Search Type comparisons Tests EQ WE specify UR to Ble CEA NG RND R Field Field Yalue Field OLTFLAG EET NAME ALT MAME Description Record Key Mame Alternate Name Fl Help Jeu F4 Prompt CO Copyright ProData Computer Define Search Prompt Fields Number Ci ioe St 11 48 45 group HELU or Characters Bottom Dec Length Type A Mara Fe4d More Keys Field Description of Prompt Field Field The Field prompt field allows you to enter the name of the field that is to be tested Use only field names that are in the list in the lower part of the display AND OR The AND OR prompt field allows any one of the following entries AND Continues connections OR Separates connections Test The Test prompt field allows the following comparison tests EQ Equal NE Not equal GT Greater than LT Less than GE Greater than or equal LE Less than or equal CT Contains value NC Does Not Contain value Value The Value prompt field allows the entry of a Field Numeric Val
46. entry of the field that will be used to validate the input field s value Exists The Exists prompt field allows the entry of either YES or NO Specifying YES denotes that the input field s value must exist in the field of the file residing in the library defined Specifying NO denotes that the input field s value must not exist in the field of the file residing in the library defined Page 50 i Define Database Validation Command Keys Command Keys F1l Help F3 Exit F4 Prompt F5 Refresh F8 Define Error Message F10 Command F12 Cancel F24 More Keys Description of Command Key Help information has not yet been made available This command key 1s for future use The Exit command key exits from the Define Database Validation display The Prompt command key shows the list of possible values that can be assigned to the field The Refresh command key clears the screen and resets the display to its initial values The Define Error Message command key displays the Define Error Message Text screen The Command command key displays a command entry line Which allows you to executed OS 400 commands The Cancel command key exits the user from the Define Database Validation display The More Keys command key displays other command keys that are available Page 51 Choosing a File To choose a file more the cursor to the File prompt and type the name of a file If you want to choose from a file from a list of file n
47. er ADDICOIOR PIOMDL T ields icis tutt ves tossed tutt Mi GAARA EOE NORE 63 Copy DBUmfier Applicaton Command Keys area setcuisssc E eae aes Lo Saeed ana es ide 64 DELETING A DBUNIFIER APPLICATION iiiceeetectceseeteevevteseneuswetceeveestexerz eeseua Qoo a ee vest deevesuseseszeeces 65 Confirm Deletion of DBUnifier Application Prompt Fields eese 65 Confirm Deletion of DBUnifier Application Command Keys essen 65 PRINTING DBUNIFIER APPLICATIONS DEFINIT ION ee ee ee ee eee eee eee eee ee e eese ette esee os 66 Example DBUnifier Application Definition REDO t cccccccccccccc cece cece cece cece cece EEE EEE EERE EEE 67 MI RUNNING A DBUNIFIER APPLICATION sssssccsssssssssssscccsssscssssssccesssscssssssccssssscsssessscessscsesccsess 68 Start DBUnifier Processor STRDBUAPP command e bc beer bee en ed ena breuis 68 Start DBUnifier Processor STRDBUAPP command Prompt Fields cccccccccccccccsccscscccssscsssecseeseeeeeeees 68 Start DBUnifier Processor STRDBUAPP command Command Keys eese 69 Run DBUnifier Processor RUNDBUAPP command sssssssssssss eene 70 Run DBUnifier Processor RUNDBUAPP command Prompt Fields sss 70 Run DBUnifier Processor RUNDBUAPP command Command Keys ssssssss 71 Start DBUnifier Detail Processor STRDBUDTL command cccccccccccssssssssssesssecesceeeseeceseeeeeeeeseeeeeess 72 Start DBUnifier
48. er Application is processed in update mode Those fields with whose usage 1s I nput will allow data to be entered After values have been validated the record will be updated The insert and delete record function is not accessible The DBUnifier Application is processed in Full update mode Those fields with whose usage is Dnput will allow data to be entered After values have been validated the record will be updated Record inserts and deletes are allowed The DBUnifier Application is processed in NODELETE mode Those field with whose usage is Dnput will allow data to be entered After values have been validated the record will be updated Record inserts are allowed record deletes are not Page 83 File and Library Name INPUT CHAR 20 The file that will be processed by the DBUnifier Application and the library in which it is located The first 10 characters contain the file name and the second 10 characters contain the library name By using the special value DEFAULT the file that was specified when the application was define is used You can use the following special values for the library name LIBL Searches all the libraries in the job s library list until the first match is found CURLIB Checks the current library for the job to locate the file Member Name INPUT CHAR 10 Defines the member name within the file you choose to process The default value for this field is FIRST which denotes to the DBUnifier Processor
49. erations Accepts a date time argument and date time format and returns the character representation of the argument using the specified format The date time argument can be a date time or timestamp field The returned value is of type CHAR Accepts a numeric argument and returns the cosine of the argument The COS argument must be specified in radians COS and ACOS are inverse operations CHAR Accepts a numeric argument and returns the hyperbolic cosine of the 0 ACOSH argument The argument must be specified in radians Accepts a numeric argument and returns the cotangent of the argument The 0 ACOT argument must be specified in radians Obtains the current date based on a reading of the time of day clock The CURDATE returned value is of type DATE The format and separator are derived from the job attributes Obtains the current time based on a reading of the time of day clock The CURTIME returned value is of type TIME The format and separator are derived from the job attributes Obtains the current timestamp based on a reading of the time of day clock CURTIMESTP The returned value is of type TIMESTP The format and separator will be derived from the job attributes Page 77 Built in Functions continued Obtains the current time zone The returned value is a packed decimal 0 CURTIMEZONE number DEC with 6 digits and 0 precision Accepts a date time argument and returns a date The date time
50. es not pass the defined test the field will be highlighted If an Error Message has been defined using the F8 Define Error Message and the field does not pass the defined test the defined error message will be sent to the display to notify the user of the error a Define Range display OBUnifier version 4 2 Define Range sequence Number UR RO Field Name STALE Type A Length Field Heading State Province V S Ending Field Number Characters Value Field Number Characters More Fl Help F3 Ex1 Tres lefine F24 More Keys CO Copyright PraData Computer Services Inc 2004 Define Range Prompt Fields Field Description of Prompt Field Beginning Value The Beginning Value prompt field allows the entry of a Field Numeric Value or Character string that 1s wrapped in single quotes The value in the input field must be greater than or equal to this value Ending Value The Ending Value prompt field allows the entry of a Field Numeric Value or Character string that is wrapped in single quotes The value in the input field must be less than or equal to this value Page 46 Define Range Command Keys Command Keys _ Description of Command Key F1l Help Help information has not yet been made available This command key is for future use F3 Exit The Exit command key exits from the Define Range display F4 Prompt The Prompt command key shows the list of possible values that
51. eys that are available Page 49 Defining Database Validation for Field Validity Checks The Define Database Validation for Field display allows you to assign validity checking for a field based off the existence or nonexistence of a field value in an externally described database If the field value entered does not pass the defined test the field will be highlighted If an Error Message has been defined using the F8 Define Error Message and the field does not pass the defined test the defined error message will be sent to the display to notify the user of the error Field Name Type Uatabase C Copyright Prolata Computer Services Inc Define Database Validation display DBUnifier version 4 2 Define Database Validation sequence Number Field Heading wulidstioHs Library LIBL LIBL LIBL LIBL LIBL LIBL LIBL STATEPE Type A Length Statler Province press Enter Field STATE File AN Define Database Validation Prompt Fields Bottom F44 More Keys Field Description of Prompt Field Library The Library prompt field allows the entry of a library name of the file being used to validate the input field s value The special library LIBL can also be used to search through the users library list for the specified file File The File prompt field allows the entry of a file that will be used to validate the input field s value Field The Field prompt field allows the
52. file Command Keys ssssssss 29 SPECIFYING SCREEN OPTIONS siccscideGedessicdicicdacessie vecxssdodadessdetesusssodaceisads unco De esee o slvdeauiecorsdeeaseduawssconses 30 Speci y Screen OPLOS PEombbd Telus cotes opcutestuPdebetodtu e onte ib eL E a cts 30 Sbecify Screen Options Command Keys scrise a i aet dese ice ie ie eon leslie oa a Ie Abus as 3l Specify Screen Options Select Screen Size 1o esi vot n need btt eire be ten edocet Dueeuit 32 DOLIECTOSCHEE SIZE OPON estne hs Sach tel esed er tom nope od a dui ci te 32 Delect SN FEEN Size Command JS Cy ce oitese ettet cd bod Moats act sea e cla baat a a 32 Specify Screen Options Define Column Spacing cccccccccccccccsscssssccssscsscccsscccsssccsecesssesaeceseeseeesseeesesseeess 33 Deme Comit DU N o asl euet est eolit tuv ML St MILES LL MMC DAD AL DM DLE heh LIAE BO 33 Select Screen Size Command Reyg visse stedittesdivisiepe elsi ties div siete sd a de aea ead teut 33 DEFINING SCREEN FIELD DETAILS 4ioscecacsoedesessose co e es eee revera obo decease ea Fude ko ed eoe e Soa e aas bons eseebaeoru scs 34 Define Screen field Details Prompt Fields cg EHE CMM IMMER IM LUIS 34 Define Screen Field Details Command KOVS uice coiled odes eem ease seh oue paene ca ae s di p amd ke 35 DEFINING SCREEN EA YOU E sdisiccsct t eeezv teseex ve oed veu ceo v e Feo Eaeee sees ex ee oa aee ec ee eren o o aen eue oe ep oe ae cos eue ee eeos 36 Define Sereen Layout Prompt Fields isst bb Et
53. fy You must enclose the test pattern in apostrophes use two apostrophes where the test pattern itself contains an apostrophe If the test pattern consist of two apostrophes alone it is treated as an empty sting You can use special characters to represent the position in the field that you do not care about e An underscore means skip one character at that position and do not test for that character Each underscore takes the place of one character in the field e A percent sign mean skip as many characters a necessary to get the end of the field or to the next specified character Each 96 takes the place of zero or more characters in the field Thus you need not write a test pattern that is 15 characters long just because the field is 15 characters long Fields as Comparison Values If you use a field as a value that 1s in the Value column on the display the field can be any field that has been previously defined in the DBUnifier Application Also the fields being compared do not have to be the same length and numeric fields do not have to have the same number of decimal positions Character Constants as Comparison Values A character constant 1s simply characters enclosed in apostrophes The apostrophes are important because DBUnifier assumes that any group of character not enclosed by apostrophes is a field name The characters in the constant can be any combination of letters numbers or special characters suc
54. ges BOTH KAPTER BOTH NONE Audit Log File x DBFAST Mame F4 for Brora S a amp j DBIINIFIEHR Name LIBL F4 Prompt F5 Refresh Fi2Z Cancel C Copyright PraData Computer Services Inc 2004 Define Audit Log Information Prompt Fields Field Description of Prompt Field Audit Log The Audit Log Images prompt field allows any one of the following entries Images NONE No audit logging is performed for DBUnifier Applications BOTH Audit logging images are written to the Audit Log File showing the Before and After image of the record that are updated After images are written showing Inserts and Deletes AFTER Audit logging images are written to the Audit Log File showing only the After image of records that are updated After images are also written showing Inserts and Deletes Audit Log File The Audit Log File prompt field allows the entry of a DB2 400 data base file where audit logging information is to be stored To choose from a list of FILE file objects position the cursor on the Audit Log File prompt field and press the F4 Prompt command key The Audit Log File selected must match the File Layout of DBFHST in library DBUnifier Library Library denotes the library where the Audit Log file resides To choose from a list of libraries position the cursor on the Library prompt field and press the F4 Prompt command key Page 85 Define Audit Log Information Command Keys Command Keys F1l Help F3 Ex
55. h as that might be found in the tested field You must use apostrophes around a character constant even if it contains only numbers Remember also the special characters underscore _ and percent have certain meanings when used in a LIKE and NLIKE test If the character constant you specify contains an apostrophe you must enter it as two apostrophes so DBUnifier does not think it has reached the end of the constant DBUnifier counts two apostrophes within a constant as a single apostrophe Numeric Constants as Comparison Values You must not enclose a numeric constant in apostrophes A numeric constant can be from 1 to 31 digits long Also do not include a currency sign to indicate a monetary value or a thousands separator to indicate thousands millions and so on within the numeric constant Date Time Timestamp Constants as Comparison Values A date time or timestamp constant must be enclosed in apostrophes and must be a valid date time or timestamp with the appropriate separators Page 45 Defining Ranges for Field Validity Checks The Define Range display allows you to assign validity checking for a field The input field value must be within the range of the two values greater than or equal to the first value but less than or equal to the second Input data will only be accepted if the value is within the defined range You can specify one range test or as many as 24 tests If the field value entered do
56. hat are available Page 29 Specifying Screen Options The Specify Screen Options display allows you to define the Initial Multi Record Display screen Size Window Label Display Screen Title 2 rows of Column Headings and the Window Footer Initially the screen size will default to a best fit size based on the field s you previously selected in the Define Initial Multi Record Display You can change the screen size by pressing the F13 Select Screen Size command key and selecting one of the available screen sizes Spe i Specify Screen Options display DBlinifier version 4 2 specify Screen Uptians Type options press Enter N Display Details Columa Heading Line 1 Oot Column Headintc B B B Fl Help bou ae F5 Retresh Fh Set Fey Position Fl Cancel FiS Define Search Fib Perform Search Window Footer Bottom Fe4 More Keys cify Screen Options Prompt Fields Field Description of Field Window Label The Window Label allows you to input the Window Label Text for your Initial Multi Record Display Subfile Disp Title This text is also displayed on the Detail Screen of your DBUnifier Application lay Screen The Display Screen Title allows you to input the screen title for your Initial Multi Record Display Subfile This text is also displayed on the Detail Screen of your DBUnifier Application Column Heading The Column Heading fields allow you to input the column headings for the rows of fields
57. hem by typing a connection in the AND OR column The two types of connections are e AND Continue connections e OR Separates connections All of the comparisons that are connected by the AND s must be true for the field value to be accepted by that group of comparisons Comparison Tests You can specify these tests in comparisons e EQ Equal Use this test to determine if the contents of the field and the value are equal e NE Not equal Use this test to determine if the contents of the field and the value are not equal e GT Greater than Use this test to determine if the contents of the field is greater than the value e LT Less than Use this test to determine if the contents of the field 1s less than the value e GE Greater than or equal Use this test to determine if the contents of the field 1s greater than or equal to the value e LE Less than or equal Use this test to determine if the contents of the field is less than or equal to the value e LIKE Like Use this test to determine if the contents of the field has a pattern similar to the value e NLIKE Not like Use this test to determine if the contents of the field has a pattern that is not similar to the value Page 44 Testing for Values that are Similar LIKE NLIKE You use the LIKE test to determine if a field has a pattern that is similar to the test pattern you specify You use the NLIKE test to determine if the field 1s not similar to the test pattern that you speci
58. hes is a field name The characters in the constant can be any combination of letters numbers or special characters such as that might be found in the tested field You must use apostrophes around a character constant even if it contains only numbers Remember also the special characters underscore _ and percent have certain meanings when used in a LIKE and NLIKE test If the character constant you specify contains an apostrophe you must enter it as two apostrophes so DBUnifier does not think it has reached the end of the constant DBUnifier counts two apostrophes within a constant as a single apostrophe Numeric Constants as Comparison Values You must not enclose a numeric constant in apostrophes A numeric constant can be from 1 to 31 digits long Also do not include a currency sign to indicate a monetary value or a thousands separator to indicate thousands millions and so on within the numeric constant Page 12 Detail Record Display The Detail Record Display screen displays the field values and labels that were specified in the Define Screen Field Detail when defining the DBUnifier Application When the DBUnifier Processor is initiated in INQUIRY execution mode field values cannot be changed When it is initiated in UPDATE FULL and NODELETE execution mode the field values that have been defined as Input capable are maintainable This is the same screen that is shown when inserting a record When insert
59. ields e Numeric constants any numbers such as 7 or 20 5 The rules for using numeric constants are The total length can be no more than 31 digits This includes the digits both to the left and right of the decimal point but does not included the decimal point Use the correct decimal separator Do not use a currency symbol like 2500 and do not use thousands separators like 2 500 Character Expressions To define a character result field you need to follow the rules for creating character expressions A character expression for a result field can contain the following alone or in combination e Character field names Names of fields that contain character data e Character constants Characters enclosed in apostrophes such as ProData or This text includes blanks and special characters The rules for using character constants are The character constant must be enclosed in apostrophes Any combination of letters numbers or special characters like can be used ftwo apostrophes are used within a character string the two apostrophes become a single apostrophe in the resulting field Words with lowercase and uppercase letters are used exactly as typed facharacter constant represents a valid date time or timestamp and is used with a date time or timestamp field it is considered a date time or timestamp constant e Concatenation Operation Character expressions can include on
60. ify Screen Options Define Column Spacing The Define Column Spacing display allows you to define the spaces between fields that are selected for the Multi Record Display screen By pressing the F14 Column Spacing command key from the Specify Screen Options display the following window will appear showing you the fields that have been selected and allows you to enter the spaces that will appear to the left most of the field Define Column Spacing display DBlinifier version 4 2 specify Screen Uptions Type information Column Field Spacing Text KEY Record Key MAME Name GITY City z Im ct T Bottom F44 More Keys Bottom Fe4 More keys Define Column Spacing Field Description of Field Column Spacing Enter the number from 0 through 99 to indicate the number of spaces you want to appear in front of that field s column Select Screen Size Command Keys Command Keys _ Description of Command Key F3 Exit The Exit command key exits from the Define Column Spacing display F5 Refresh The Refresh command key clears the screen and resets the display to its initial values F12 Cancel The Cancel command key exits the user from the Define Column Spacing display Page 33 Defining Screen Field Details The Define Screen Field Details allows you to select and sequence the fields that are processed in the detail portion of the DBUnifier Application processor Fields can be selected or omitted Text Labels can be changed
61. ing a record the initial value defined in the Define Extended Field Attributes screen is displayed Use the Page Up and Page Down keys to view multiple pages Validation restrictions that are defined in the Define DBUnifier Application program are enforced for input fields User Defined Field Prompt Programs are executed DBUnifier Applications that are tied to prompt fields can be processed and the List of Values Prompt window can be displayed for input fields The following screen shows a sample Detail Record Display screen Detail Record Display screen Hn Example DBUnifier Applicaton Presidents Master File Maintenance 11 15 04 Lae de 1H Type options press Enter 7 1 GEORGE WASHINGTON WASHINGTONS PRESIDENT 4 MOUNT VERNON ESTATE am 1 i 12 amp amp MUNT YERNUN State Province WA DOUDEFE e Gwe X9 wx od NETED SIBHLES Postal Code Phone Mumber PS T00 200 Fax Number Fd Prompt User Define Message Line Detail Record Display Command Keys Command Keys Description of Command Key F3 Exit The Exit command key exists from the Detail Record Display screen F4 Prompt The Prompt command key searches the DBUnifier Application definition and determines if a User Define Prompt Program or DBUnifier Application has been assigned to the field for prompting Also if a List of Values has been defined a prompt screen will be displayed and allow you to se
62. is chapter describes how you define result fields They need to be defined in you application if the information that you want to present in your application does not exist as a field in your selected file After you have defined a result field you can use them like any other field that exists in your file selection Please note When a User Defined Field value is changed in a DBUnifier application the value will not be reflected in the database record being process User Defined field values are only passed into Exit Programs as a separate data structure which then can be processed Creating Results Fields The Define Result Fields display appears if you typed a 1 next to the Define result fields option on the Define DBUnifier Application display You use the Define Results Fields display to create the User Defined fields you need for your application The following display has some sample fields listed in the bottom part Define Result Fields display OBUnifier version 4 2 Define Result Fields Type application using field names or constants and operators press Enter Operators Z SUBSTR DATES S Field Expression Length More Field Description Dec DLTFLAG KEY Record Key D MAME Name A 3l HL TNRME Alternate Mame Mrs Fl Help m x tres Peel Tu eru Fz2dzMnre Keys C Copyright PraData Computer Services Inc 2004 To define a result field you specify a unique name for the
63. is not null The arguments are evaluated in the order in which type are specified The arguments must be compatible The form is VALUE x y z Date Time and Timestamp Expressions Date time and timestamp data types and values can be assigned to result fields A date time or timestamp expression for a result field can contain the following alone on in combination e Date time or timestamp field names Names of fields that contain date time or timestamp values e Character constants Characters enclosed in apostrophes such as 12 17 1995 The rules for using character constants are The character constant must be enclosed in apostrophes facharacter constant represents a valid date time or timestamp and is used with a date time or timestamp field it is considered a date time or timestamp constant Page 25 e Date time and timestamp functions and Operation One or more of the following functions and arithmetic operations Addition Subtraction CHAR CURRENT DATE DAY DAYS MONTH YEAR TIME HOUR MINUTE SECOND MICROSECOND TIMESTAMP e Durations A length of time represented by a labeled durations date duration time duration or time duration Page 26 Removing Results Fields To remove a result field blank out all references to the field and its definition on the Define Result Fields display You must remove all occurrences of it from the applic
64. it F4 Prompt F5 Refresh F10 Command F12 Cancel F24 More Keys Description of Command Key Help information has not yet been made available This command key is for future use The Exit command key exits from the Define Audit Log Information display The Prompt command key shows the list of possible values that can be assigned to the field The Refresh command key clears the screen and resets the display to its initial values The Command command key displays a command entry line Which allows you to executed OS 400 commands The Cancel command key exits the user from the Define Audit Log Information display The More Keys command key displays other command keys that are available Page 86
65. l command key exits the user from the Define Prompt Program for Field display The Import command key Imports a List of Values from an existing DBUnifier Application The More Keys command key displays other command keys that are available Page 42 Defining Relational Operators for Field Validity Checks The Define Relational Operators display allows you to assign validity checking for a field The input field value is tested against the relational operators and values defined Input data will only be accepted if 1t matches the defined conditions You can specify one test or as many as 24 tests If the field value entered does not pass the defined test the field will be highlighted If an Error Message has been defined using the F8 Define Error Message and the field does not pass the defined test the defined error message will be sent to the display to notify the user of the error Define Relational Operators display m OBUnifier version 4 2 Define Relational Uperators Type choices sequence Number Field Name S H Type A Length Field Heading State Province FERT Type comparisons EQ WE AND OR E value Field Number or Characters More Fe4 More Keys C Copyright PraData Computer Services Inc 2004 Define Relational Operators Prompt Fields Field Description of Prompt Field AND OR The AND OR prompt field allows any one of the following entries AND Continues connections OR
66. l i TH Hpplication name Library name Execution mode File Name Library name Member name Name Name CURLIB KINQUIRY UPDATE Mame DEFAULT Name CURLIE Mame FIAST EXAMPLE LIBL INQUIRY DEFAULT LIBL KFIRST KALL LIBL FULL LIBL Mumber lative Record Number Character urned More OeEXTE F4 Prompt Fo Refresh Fi Cancel FiS How to use this display F4e4 More keys Run DBUnifier Processor RUNDBUAPP command Prompt Fields Field Description of Prompt Field Application The Application Name prompt field specifies the DBUnifier Application name to be processed name Application The Library Name prompt field qualifies the library from which the DBUnifier Processor will access the Library name Execution mode application definition Special value LIBL tells the processor to search all the libraries in the job s library list until the first match is found Special value CURLIB checks the current library for the job to locate the application definition The Execution Mode prompt field tell the DBUnifier Processor the mode the application is to be processed The possible modes are INQUIRY for inquiry mode only UPDATE which allows changes to be made to the database records FULL which allows changes inserts adds and deletions to the database records and NODELETE which allows changes and inserts
67. le DBFSOURCE in library DBUNIFIER DBUnifier Processor DBF1000 Parameter Group Required Yes Yes Yes Yes Yes NO No DBUnifier Processor DBF1 Parameter Usage Type DBUnifier Application and Library Input Char 20 Name Execution Mode Input Char 10 File and Library Name Input Char 20 Member Name Input Char 10 Query Selection Expression Input Char 256 Returned Relative Record Number Outpu Integer 10 0 t Data Returned Record Data Outpu Char 32766 t 000 Parameter Descriptions DBUnifier Application and Library name INPUT CHAR 20 The DBUnifier Application you want to process and the library in which it is located The first 10 characters contain the application name and the second 10 characters contain the library name You can use the following special values for the library name LIBL Searches all the libraries in the job s library list until the first match is found CURLIB Checks the current library for the job to locate the application definition Execution Mode INPUT CHAR 10 Tells the DBUnifier Processor the mode the application is to be processed The default mode is INQUIRY The following is the list of possible values INQUIRY UPDATE FULL NODELETE The DBUnifier Application is processed in inquiry mode only Field values will not be changed the record will not be updated the insert and delete record function is not accessible The DBUnifi
68. le name that starts with the characters you typed Once you have located the file you want type a 1 in the Opt option field next to the file name you want After you have made your selection press the Enter key to return to the Specify File Selection display The file you selected will be returned to the File prompt field Page 20 Selecting File Members The Select Member display appears when you position the cursor on the Member prompt of a display and press F4 Prompt The Select Member display shows you a list of members and allows you to select the one from which your application can process data This display appears only when you are creating or changing an application Select Member display DBUnifier version 4 2 Member 110904 16 24 19 Pate se ow x18 x 3 E amp HMPFLELF Library NR LIBL Upt Member 1 EAAMPLELF Bottom Fl Help E It Tres T2 Lancet Fes More Reus CO Copyright PraData Computer Services Inc 2004 If you came from the Specify File Selection display you can specify which member you want DBUnifier to process data from The names of the members that currently exist in the file show in the Member column You can choose a member by typing a 1 in the Opt column to the left of the member When you press the Enter key on the Select Member display the member you selected is then shown in the Member prompt on the display that you return to Page 21 Defining Result Fields Th
69. lect from possible values F5 Refresh The Refresh command key clears the screen and resets the display to its initial values F10 Validation The Validation Messages command key displays a window that shows all the validation error message Messages F12 Cancel The Cancel command key exits the user from the Initial Multi Record Display Subfile Oee Nm u Page 13 Creating a DBUnifier Application This chapter describes the process of creating a DBUnifier Application that can be used to display and maintain AS 400 databases The chapter begins with selecting option 1 Create on the Work with DBUnifier Applications display and then it introduces the six other possible definition steps you can use to define an application or change part of an existing application The detail for each definition steps are described in later chapters For detail of each of the major tasks please refer to their corresponding chapters Starting DBUnifier Application Definition You start DBUnifier Application definition by selecting option 1 Create on the Work with DBUnifier Applications display and by specifying the name of the application you want to create To specify an application name you type the name of the application in the Application prompt that you want to define and you specify the name of the library Library prompt in which it is to be stored Or you can choose from the list of names to select the application name and library name y
70. mpt to I nput Page 34 Define Screen Field Details Command Keys Command Keys F1l Help F3 Exit F4 Extended Attributes F5 Refresh F10 Command F11 Define Screen Layout F12 Cancel F13 Display Screen Layout F16 Edit Codes F21 Select All F24 More Keys Description of Command Key Help information has not yet been made available This command key is for future use The Exit command key exits from the Define Screen Field Details display The Extended Attributes command key shows the Define Extended Field Attributes display The Refresh command key clears the screen and resets the display to its initial values The Command command key displays a command entry line Which allows you to executed OS 400 commands The Define Screen Layout command key shows the Define Screen Layout display The Define Screen Layout allows you to determine the screen positioning of the fields and their label texts The Cancel command key exits the user from the Define Screen Field Details display The Display Screen Layout command key shows a sample of how the detail portion of the DBUnifier Application will appear when being processed The Edit Codes command key allows you to assign an edit code for numeric values The Select All command key selects all the fields defined for this DBUnifier Application The More Keys command key displays other command keys that are available Page 35 Defining Screen Layout The Define Screen La
71. n is required and you use it to specify the file from which you want your application to obtain information Define result fields Use this option to define fields that do not exist in your file but you want to use in your application Page 15 neee aall A Making your Choices continued Define initial multi record display Use this option to select the fields from your selected file and your result field s that you want to appear on the multi record display subfile You also specify in what order you want them to appear Specify screen options Use this option to select the screen size of the multi record display subfile define the screen headings and the column labels Define screen field details Use this option to select and sequence the fields that will be processed in the detail record portion of the application The field labels field position on screen and extended attributes such as field level validation field prompting and associated message are also defined with this option Define exit programs Use this option to define the exit point programs that are associated to the application Page 16 Specifying and Selecting a File This chapter describes how you select and use a database file that is to be displayed and maintained Specifying file selection the first option on the Define DBUnifier Application display is the first step that you can use to define an application This step includes specifying or changi
72. nM cda na ah uU Ac ice MM E 6 DBUNIFIER APPLICATION PROCESSOR FUNCTIONALITY 0 ccccsscsssccccccscccsccccccsccssccecceecs 7 Initial Mu lti Reeord Display d Subfile ce tenti re eel ep bere ema ee Grit dames ex eade test aea 7 Initial Multi Record Display Subfile Options cccccccccccccc ccc cece EEE EE EEE tent tenes 7 Initial Multi Record Display Subfile Command Keys sss e eee e eee b bet teteeeeebeeeEee eS DCL LOSON DPA LAT T2 0 DC En 9 Set Position Display Window Command Keys abe ettet ium e bte tu e tem pu Vers a 9 Denne Search Display cutus aate eel oto cate a La Lo ost 10 Define Search PEODmnDJ 19 085 citada situa tul Gnas cule RSI aad Ath Ai tails A Ne Reais E Sel Bas ca Art 10 Denne search Commddld KEOPS NE E E east AAO AA ll Usine More Than One Comparison Tel aec inisa ran N 11 COMPA SOU eS ae feet p DR mM Eum A ie AMA M M UDMeU OI I MT Crue UE 11 TP VCTOUS AS COMI AV ISON Values asocia ism LU IMP II ME I DUE 12 Character Constants as Comparison Jalisco cecus dc oit cec oo icto eee eom erat babe tenga aicts 2 Numeric Constants as Comparison Values sse eene enne eneeeeeeeen nennen nennt eene nennen nne 12 Perdi REA TOUS DIGV aa sates ach harsh E sene cada T ata ean hci ea Rs eae LE I c eiue 13 Detail Record Display Command K VS x53 cccatso tak das mta uis eo docemus A 13 CREATING A DBUNIFIER APPLICA TION iA GI Iesse Ue Uovs o o cy vuv sae aUe des ae ava E Ee P CUe ae pep Fog EC RE e
73. nal displays The More Keys command key displays other command keys that are available Page 64 Deleting a DBUnifier Application To delete a DBUnifier Application from the Work with DBUnifier Applications display type a 4 in the Opt field next to the DBUnifier Application name you wish to delete Pressing the Enter key will display the Confirm Deletion of DBUnifier Application display Confirm Deletion of DBUnifier Application display UBUnifier version 4 2 Work with DBUnifier Applications 11 10 04 14291127 LIDEBSPEU xoG dcl 6G 4 LIBL cii A X ALL Fosition EX x 2 Wock 3 Star LIBL F4 for list generic ing characters O to i ct and DBUnifier Application pr e Change J Copy N Displ 9 Run Confirm Deletion of DBllnifier Application 117 1004 14 51 29 E F nter to confirm your choices for 1 Cancel to return to change your choices HhunlloHtrBH amp 3 P V EXAMPLE LX BEP 29 2 xx 439 amp x DBUNIFIER Bottom Fl Help C Copyright ProData Computer Services Inc Confirm Deletion of DBUnifier Application Prompt Fields Field Description of Prompt Field Application The Application display field shows the DBUnifier Application that 1s to be deleted Library The Library display field shows the library where the DBUnifier application will be deleted Confirm Deletion of DBUnifier Application Command Keys Command Keys Description of Command Key
74. nality is only available when the Query Selection Expression is ALL The Perform Search command key continues the search process defined in the Define Search display This functionality is only available when the Query Selection Expression is ALL The More Keys command key displays other command keys that are available Page 8 Set Position Display Window The Set Position display window queries the attributes of the database being processed determines the key fields that are defined for the database file displays an entry window for these fields then when values are entered and the Enter key is pressed Reloads the Multi Record Display Subfile from this file position Set Position display window An Example DBlnifier Applicaton Presidents Master File Maintenance Set Position Cc oF Record Key E eu P FOSE FITZ Caneel MARTIN VAN BUREN KINDERHOOK WILLIAM HENRY HARRISON NORTH BEND JOHN TYLER RICHMOND JAMES FOLK NASH ILLE ZACHARY TAYLOR ST MATTHEWS More Fiv Cancel ine Search Fib Perform Search User Define Message Line Set Position Display Window Command Keys Command Keys _ Description of Command Key F3 Exit The Exit command key exits from the Set Position display window F12 Cancel The Cancel command key exits the user from the Set Position display window Page 9 Define Search Display The Define Search display allows the entry of search criteria After search criteria has been d
75. ncountered that is shorter than the previous result it is padded with blanks The final result 1s a string with the same length as the longest argument If any of the arguments are variable length the maximum length is used as the length of the argument OR Is used to identify the lower and upper boundaries for the value of a field or expression RANGE must be specified as the right side of a relation whose operator is equal The low value and high value argument must be field names character strings or numeric literals to match the type of field or expression specified as left side of the relation For example to select only records where the numeric field NBRFLD has a value ranging from 10 AUS 4 daW Ge argument and returns the seconds part of the value The date time argument can be a time or timestamp field a time duration or timestamp duration either field or literal or a numeric field or literal The returned value is of type BIN4 ARANGE VoSECOND Accepts a numeric argument and returns the sine of the argument The SIN argument must be specified in radians SIN and ASIN are inverse operations Accepts a numeric argument and returns the hyperbolic sine of the argument 0 QE The argument must be specified in radians VoSQRT Accepts a numeric argument and returns the square root of the argument Accept a character string a starting position expression and an optional length SST expression as arguments They re
76. nd key 1s for future use The Exit command key exits from the Initial Multi Record Display Subfile The Refresh command key clears the screen and resets the display to its initial values The Set Key Position command key displays the Set Position display window DBUnifier Application Processor determines the key fields defined in the database file being processed displays entry fields for those key fields then sets the file position based off the input value The Initial Multi Record Display is then reloaded starting from this file position The Insert Record command key displays the Record Detail portion of the application processor If there are fields that have been define as input capable their initial values are displayed and their values are changeable Once field validations have been satisfied The record is inserted into the database file being processed This option is only available when the application processor is invoked with FULL execution mode The Cancel command key exits the user from the Initial Multi Record Display Subfile The Define Search command key shows the Define Search display After search criteria has been defined and the enter key is pressed the application processor searches for a matching entry in the database being processed If a matching record is found before the maximum number of records to search limit 1s reached the Initial Multi Record Display is reloaded staring with the matching entry This functio
77. ne Exit Programs Command Keys Command Keys _ Description of Command Key F1l Help Help information has not yet been made available This command key 1s for future use F3 Exit The Exit command key exits from the Define Exit Programs display F4 Prompt The Prompt command key shows the list of possible values that can be assigned to the field F5 Refresh The Refresh command key clears the screen and resets the display to its initial values F10 Command The Command command key displays a command entry line Which allows you to executed OS 400 commands F12 Cancel The Cancel command key exits the user from the Define Exit Programs display F24 More Keys The More Keys command key displays other command keys that are available Sample Exit Programs There are sample User Exit Programs provided in library DBUNIFIER file DBFSOURCE The following table shows the library file member names and simple description of Exit Point Programs Library File Member Description An example exit program that showing parameters and data types utilized by DBUnifier Applications when processing a User Defined Exit program prior to the record field information being display on the detailed portion of the DBUnifier Application that 1s being processed DBUNIFIER DBFSOURCE B4DISPLAY An example exit program that shows the parameters ant data types utilized by DBUnifier Applications when processing a User Defined Exit program that is to be executed prior t
78. ng the file you want to select for you application and seeing which file is already selected This step also allows you to select when necessary file and member for the file The displays related to the file selection process are e Specify File Selections e Select File optional e Select Library optional e Select Member optional Specifying File Selection The file selection process includes selecting a file from which your application will get data and also specifying the library containing the file and the file member Specify File Selection display DBlinifier version 4 2 specify File selection af 22 105 14 44 16 Pee fone GS oe Se a ESDMPLELF Name F4 for IE MPH wae eM KLIBL Mame LIBL Member Ml xXFIBST Name FIRST Porte cr ESBMPLEHSHS Fl Help C Copyright PraData Computer Services Inc 2004 The Specify File Selection display is used to specify a database file that you want to display or maintain in your application If you are creating or changing an application definition you should complete all the information needed for the file selection before you start on the other options Based on the values you entered and the key you press DBUnifier shows you the displays you need The order of prompting for a file is file library and member The following special values are shown in the prompts for the file selection when it first appears FIRST for members and LIBL for library
79. ns only numbers If the character constant you specify contains an apostrophe you must enter it as two apostrophes so DBUnifier does not think it has reached the end of the constant DBUnifier counts two apostrophes within a constant as a single apostrophe Numeric Constants as Range Values You must not enclose a numeric constant in apostrophes A numeric constant can be from 1 to 31 digits long Also do not include a currency sign to indicate a monetary value or a thousands separator to indicate thousands millions and so on within the numeric constant Date Time Timestamp Constants as Range Values A date time or timestamp constant must be enclosed in apostrophes and must be a valid date time or timestamp with the appropriate separators Page 47 Defining List of Values for Field Validity Checks The Define List of Values display allows you to assign validity checking for a field and define a prompt window for selection of available values When validation enforcement has been specified the input field value must be equal to one of the values defined in the list If the field value entered does not pass the defined test the field will be highlighted If an Error Message has been defined using the F8 Define Error Message and the field does not pass the defined test the defined error message will be sent to the display to notify the user of the error Once a list of values has been defined for a field and F4 Prompt command key
80. nteger argument for this function can be a numeric expression a field or a literal Accepts an integer argument and returns a labeled duration of minutes The DURMINUTE integer argument for this function can be a numeric expression a field or a literal Accepts an integer argument and returns a labeled duration of months The DURMONTH integer argument for this function can be a numeric expression a field or a literal Accepts an integer argument and returns a labeled duration of seconds The DURSEC integer argument for this function can be a numeric expression a field or a literal Accepts an integer argument and returns a labeled duration of years The DURYEAR integer argument for this function can be a numeric expression a field or a literal Accepts a numeric argument and returns a value that is the base of the EXP natural logarithm e raised to a power specified by the argument EXP and LN are inverse operations Page 78 Built in Functions continued Accepts an argument and returns the hexadecimal equivalent of the HEX argument s value The hexadecimal argument can be of any type The returned value is of type CHAR Accepts a date time argument and returns the hour part of the value The date time argument can be a time or timestamp field a time duration or timestamp duration either field or literal or a numeric field or literal The returned value is of type BIN4 HOUR Accepts one argument and re
81. o the record being updated when the DBUnifier Application is processed DBUNIFIER DBFSOURCE B4UPDATE An example exit program used in DBUnifier Application STATE This exit DBUNIFIER DBFSOURCE STATE EXIT program has been assigned as the Program to Call Before Record 1s Updated for the STATE application Page 60 Saving a DBUnifier Application The Exit This Application display allows you to exit the DBUnifier Application definition process and save or discard changes made to the definition If you are saving a newly created application the object type USRSPC user space cannot already exist in the library specified If you are saving a changed version of an application the original application name and library can be specified or a new application and library can be specified Exit this Application display DBUnifier Iversion 4 2 Exit this Application Lif loos Loe ae Apo lication amp ox Y y res N No For a saved application Application o 2 i EAHMPLE Lihtarg ui Loo i DBUNTFIER Mame F4 for list tee D Hn Example DBlnifier Application Bottom Fl Help 3 Exi Tres Fe4 More Keys C Copyright PraData Computer Services Inc 2004 Exit this Application Prompt Fields Field Description of Prompt Field Save Application The Save Application Prompt field allows you to specify if you would like to save the changes you have defined If this is anew DBUnifier Application an object type USRSPC will be created If you
82. on Multiplication Division e A character expression assigns characters or performs an operation on them Character expressions can contain the following operators or functions Concatenation Operator SUBSTR Substring function VALUE Value function DIGITS Digits function e A date expression performs an operation on a date Date expressions can contain the following operators or functions Addition Subtraction CHAR DATE DAY DAYS MONTH YEAR A time expression performs an operator on a time Time expressions can contain the following operators or functions Addition Subtraction CHAR TIME HOUR MINUTE SECOND MICROSECOND A timestamp expression performs an operation on a timestamp Timestamp expressions can contain the following operators or functions Addition Subtraction CHAR TIMESTAMP Page 23 Numeric Expressions To define a numeric result field that 1s a result field that contains a numeric value you need to follow the rules for creating numeric expressions A numeric expression for a result field can contain the following alone or in combination e Numeric field names names of fields that contain numeric values You can use the names of numeric fields listed on the lower part of the display numeric fields have number shown in the Len and Dec column and the names of previously defined numeric result f
83. on display 1s shown 6 Print Prints the application definition The DBUnifier Application definition is printed to an out queue 9 Run Runs an application Depending on the application definition a database file will be displayed or the ability to maintain the database is allowed HnnM t Page 5 Work with DBUnifier Application Command Keys Command Keys _ Description of Command Key F1l Help F3 Exit F4 Prompt F5 Refresh F10 Command F12 Cancel Help information has not yet been made available This command key 1s for future use The Exit command key exits from the Work with DBUnifier Applications display The Prompt command key displays a list of possible values that are available for the field where the cursor is located when it is pressed The Refresh command key clears the screen and resets the display to its initial values The Command command key displays a command entry line Which allows you to executed OS 400 commands The Cancel command key exits the user from the Work with DBUnifier Application display F24 More Keys The More Keys command key displays other command keys that are available Working with a List of DBUnifier Applications When you work with a list of DBUnifier Applications there are several functions to help you Here are some possibilities To see all the applications in a different libra
84. ormat name in the Format field Page 18 Selecting Files The Select File display shows you a list of files from which you can select a file that your application is to display or maintain This display appears if you position the cursor on the File prompt of a display and the press F4 Prompt The following is an example of how the Select File display might appear Select File display DBUnifion SIE Am 1109r 0q 15 18 47 LIDPaP o x A u x i LIBEL Mame LIGL F4 for list subset ASG Vee ESAMPLE Name generiek Fosition tO v x 3 Starting 5 Type option land File press Enter Library ESAMFLELF OBUNIFIER EAHMPLELT DBUNIFIER ESAMFLELZ DBUNIFIEHR EABFPFLEPE DBUNIFIER cu ct id By Key id Bu Mame eyed By Alternate Na yed By Key Logical Fil Lugripal rail Logical Fil Fhysical File nu rct m m A u ID m ium m a cu ct iD ion mb n cu pt m Bott orm Fi Help 3 Exit fres 12 Cancel F24 More C Copyright PraData Computer Services Inc 2004 The list on this display includes all files for which you have the needed authority that are in the library shown at the top of the display If you specified a generic file name as a file name on the Specify File Selection display it is used as a subset value on this display and only the file names starting with those generic characters are included in the list You can specify another subset value on the display to change the subset sh
85. otes the library where the DBUnifier application will be Library name copied into Page 63 Copy DBUnifier Application Command Keys Command Keys F3 Exit F4 Prompt F5 Refresh F9 AII Parameters F11 Keywords F12 Cancel F13 How to use this display F14 Command String F15 Error Messages F16 Complete Command F24 More Keys Description of Command Key The Exit command key exits from the Copy DBUnifier Application display The Prompt command key shows the list of possible values that can be assigned to the field The Refresh command key clears the screen and resets the display to its initial values The All Parameters command key shows the entry field for all parameters including those not selected by entries on previous parameters and those commonly used The Keywords command key toggles between the version of the prompt display that shows possible choices and the version that show parameter keywords The Cancel command key exits the user from the Copy DBUnifier Application display The How to use this display command key shows help for the prompt display The Command string command key shows the resulting command as it would run with the parameter values currently entered The Error Messages command key shows all error message that pertain to the command being entered The Complete Command command key indicates all values needed have been entered and requests the system to run the command without showing additio
86. ou want to use The DBUnifier Application name must begin with an alphabetic character A through Z or and can be followed by no more than 9 alphanumeric characters A through Z 0 through 9 7 or When you are creating an application you can check this list to see what names are already used before you choose a new name Type a 1 in the Option prompt field the new name in the Application prompt field and type the library name in the Library prompt field _ Work with DBUnifier Applications display _ DBlinifiser version 4 2 Work with DBUnifier Applications 11 09 04 lori Ub LIR Ye SG Se ee o LIBL Yame x LIBL F4 for Sheet G 4 Se at Boe Se ALL Jame generic POStt itn Tos I x amp te i 5 ing characters 1 fand DBlinifier Application pr Lhange S lopg a Displ Print 4 Run Application Library Text EABHBPLE OBUNIFIER An Example DbBlinifier Application giu ea OBUNIFIER Example Selection List Of Presidents OUTPUT OBUNIFIER Example Prompt Sele utput Queue SAMPLE DEUNIFIER STATE DBUNIFIER ile Maintenance SIRMLELDUDE DBUNIFIER State Codes Bottom Fl Help j Exit F4 Prompt Tres F44 More Keys C Copyright PraData Computer Services Inc 2004 Page 14 Selecting Definition Steps When Defining a DBUnifier Application When you specify option 1 Create on the Work with DBUnifier Application display you are shown the Define DBUnifier Application display Where you select one several or all
87. own You can use the Library prompt to see the files that exist in a different library or group of libraries If you want to select a particular library from a list of libraries press F4 with the cursor positioned in the Library prompt The list that is shown contains only libraries that you have authority to use If you do not want or need to see a list of libraries type the name of a library a generic library name or one of the following special library names LIBL CURLIB USRLIBL ALLUSR or ALL Page 19 After you have entered a value in the Library prompt at the top of the display press the Enter key and a list of the files that you are authorized to use from that library appear Fosition to Typ Opt LC Copyright FroData Computer Bg LU Fi Help option and Library 1 20 16 Library LIBL CURLIEB USRLIBL ALLUSR ALL H CGULIEB SDFULIB HOSULIB tL IBRRRW HSDHLIB Select Library display DBlinifier version 4 2 Select Libraru Fd Prompt Services 11 09 04 15 45 23 Mare F44 More Keys To move position the list of file names so that it starts with a particular name move the cursor to the Position to prompt and type all of the characters or one or more of the starting characters in the name you want and press the Enter key If a specific library name is used in the Library prompt DBUnifier moves the list so that the first position shown contains the first fi
88. pe SAVLIB and press F4 to prompt the following options Note Replace TAP01 with the name of the device containing the initialized tape Save Library Command display Ss ee ees Sree UP MM EE Tupe choices p Library DBUNTFIER Name Device TREO Mame S5AWF for more values Fi Additional parame F 2 z M ore Le gl a generic NUNSYS xMHEDDFIM Bottom Fiv Cancel Page 3 Deleting DBUnifier Use the Delete Library DLTLIB command to delete DBUnifier Follow the Two step process 1 Sign on the iSeries 400 system as security officer QSECOFR 2 Delete DBUnifier with the DLTLIB command Type DLTLIB and press F4 to prompt for the following options Delete Library Command display lelete Library DLTLIB Type choic Sa oS Busco io REPE DBUNTFIER Name Bottom F5 Retresh T2 Cancel Fis How to use this display Page 4 Work with DBUnifier Applications WRKDBUAPP The Work with DBUnifier Applications display is the major starting point for working with one or more DBUnifier Applications Using this display you can select and therefore start one or more of the following primary tasks e Create anew Application e Change copy display or delete an existing application e Print the definition of an application e Run an application to view or maintain database information Work wi
89. r Messages command key shows all error message that pertain to the command being entered The Complete Command command key indicates all values needed have been entered and requests the system to run the command without showing additional displays The More Keys command key displays other command keys that are available Page 75 Query Selection Expression The Query Selection Expression specifies the selection values used to determine which records are available for processing when the DBUnifier Processor is executed The special value ALL denotes that all the records in the physical or logical file and member specified are selected Specifying an expression of up to 256 characters that describes the values used to determine which records are selected Arithmetic Operators Operator Description S er Addition Subtraction Multiplication Division T Exponentiation Remainder String Operators Operator Description CATor Concatenation CT Contains Relational Operators Operator Description S GT gt Greater than LT x Less than EQ Equals GE gt Greater than or Equal to LE lt Less than or Equal to NE Not Equal to NG gt Not Greater Than NL lt Not Less Than Logical Operators Operator Description AND amp OR XOR amp amp Exclusive OR NOT 7 Built in Functions Functions Description VoABSVAL Accepts a numeric argument and returns the absolute value of the a
90. rd Display screen The return variable is a 10 0 digit integer For RPG amp RPG 400 the return variable can be defined as a BINA field The Return Key Pressed is the HEX value of the key that was pressed to initiate the termination of the DBUnifier Detail Processor Run DBUnifier Detail Processor RUNDBUDTL command Command Keys Command Keys F3 Exit F4 Prompt F5 Refresh F9 AII Parameters F11 Keywords F12 Cancel F13 How to use this display F14 Command String F15 Error Messages F16 Complete Command F24 More Keys Description of Command Key The Exit command key exits from the Run DBUnifier Detail Processor command display The Prompt command key shows the list of possible values that can be assigned to the field The Refresh command key clears the screen and resets the display to its initial values The All Parameters command key shows entry field for all parameters including those not selected by entries on previous parameters and those commonly used The Keywords command key toggles between the version of the prompt display that shows possible choices and the version that show parameter keywords The Cancel command key exits the user from the Run DBUnifier Detail Processor command display The How to use this display command key shows help for the prompt display The Command String command key shows the resulting command as it would run with the parameter values currently entered The Erro
91. rgument E REESE R Page 76 eee NN The returned value has the same attributes as the argument unless the argument is a BIN2 in which case the returned value is a BIN4 Accepts a numeric argument and returns the arc cosine of the argument in 0 ae Oe radians ACOS and COS are inverse operations Accepts two or more character or hexadecimal string arguments and returns a string that is the bit wise AND logical and of the arguments This function takes the first argument string AND s it with the next string and continues to AND each successive argument with the previous result If an argument is encountered that is shorter than the previous result it is padded on the right with blanks The returned value is a string of type HEX with the same length as the longest argument If any of the arguments are variable length the maximum length is used as the length of the argument AND Accepts a numeric argument and returns the antilogarithm base 10 of the 0 a argument ANTILOG and LOG are inverse operations Accepts a numeric argument and returns the arc sine of the argument in 0 a radians ASIN and SIN are inverse operations Accepts a numeric argument and returns the arc tangent of the argument in 0 NEE radians ATAN and TAN are inverse operations Accepts a numeric argument and returns the hyperbolic arc tangent of the 0 hee argument in radians ATANH and TANH are inverse op
92. rom the Exit this Application display The More Keys command key displays other command keys that are available Page 62 Copying a DBUnifier Application The Copy DBUnifier Application CPYDBUAPP display allows you to copy a previously saved DBUnifier Application This option allows you to copy an application from someone else s library into your library copy an application so that you can change it without changing the original or for any other purpose you may have Copy DBUnifier Application display E JEUAFF Type choices Tress From application s eaa gt iius Mame Library name P DBUNIFIER Mame CURLIB B apn PCat x 5e eR Bias ee 3 x SAME Mame SAME Library Name so ss E MERC M FROMLIB Name FROMLIB Bottom F4 Prompt Fo Retresh Lance lL FiS How to use this display keus Copy DBUnifier Application Prompt Fields Field Description of Prompt Field From The From Application prompt field defines the DBUnifier Application that is to be copied Application From The From Application Library Name prompt field denotes the library where the DBUnifier application will be Application copied from Library name To Application The To Application prompt field defines the name of the new DBUnifier Application The new application cannot previously exist in the library specified To Application The To Application Library Name prompt field den
93. rompt field Page 52 Select File Command Keys Command Keys F1l Help F3 Exit F4 Prompt F5 Refresh F10 Command F12 Cancel F24 More Keys Description of Command Key Help information has not yet been made available This command key is for future use The Exit command key exits from the Select File display The Prompt command key shows the list of possible values that can be assigned to the field The Refresh command key clears the screen and resets the display to its initial values The Command command key displays a command entry line Which allows you to executed OS 400 commands The Cancel command key exits the user from the Select File display The More Keys command key displays other command keys that are available Page 53 Choosing a Library Because the file you want to select may be in a different library you can specify a different library name generic library name or special library name for the file selection e Ifyou type a generic library name or special library name in this prompt and press the Enter key that library group is searched for the file named in the File prompt e Ifyou type a generic library name or a special library name and then press the F4 with the cursor in this prompt the specified list of library names are shown on the Select Library display When you select the library you want from the list and press the Enter key you will return to this display with the select name filled
94. ry list until the first match 1s found Special value CURLIB checks the current library for the job to locate the application definition The Execution Mode prompt field tell the DBUnifier Processor the mode the application is to be processed The possible modes are INQUIRY for inquiry mode only FUPDATE which allows changes to be made to the database records FULL which allows changes inserts adds and deletions to the database records and NODELETE which allows changes and inserts adds to the database records File name The File Name prompt field specifies the database file to be accessed by the DBUnifier Processor By using the default value DEFAULT the file that was specified when the application was defined is used The File Library Name prompt field qualifies the library where the file will be accessed Special value LIBL File Library tells the processor to search all the libraries in the job s library list until the first match is found Special value CURLIB checks the current library for the job to locate the file to process Page 72 Member name Relative Record Number The Member Name prompt field specifies the member name of the file you would like to process The default value for this field is FIRST which denotes to the DBUnifier Processor to use the first member in the file defined The Relative Record Number prompt field specifies the record number that you wish to process If this values is left blank th
95. ry of group of libraries you can press the Enter key after changing the value in the Library prompt and typing blanks or an asterisk You are shown all the applications that you have the authority to use that exist in that library or group of libraries You indicate which libraries are to be check by specifying a library name a special library name such as LIBL or a generic library name in the Library prompt To see a particular subset a smaller group of application names you can type a generic name in the subset prompt and press the Enter key If you know at least the starting characters in the name you are looking for this function can reduce the time needed to locate it To see if more than one library contains a specific application name you can type that application name in the Subset prompt and type ALL in the Library prompt before you press the Enter key You are shown all the applications by that name for which you have authority to use To position the list to a specific name type the name or the starting characters in the name in the Position to prompt and press the Enter key This function can also reduce the time needed to locate an application You can also use a combination of these things at the same time For example you could specify a different library name generic library name or special library name in the Library prompt a subset value in the Subset prompt a specific application name or the starting characters
96. s You can specify these tests in comparisons e EQ Equal Use this test to determine if the contents of the field and the value are equal e NE Not equal Use this test to determine if the contents of the field and the value are not equal e GT Greater than Use this test to determine if the contents of the field is greater than the value e LT Less than Use this test to determine if the contents of the field 1s less than the value e GE Greater than or equal Use this test to determine if the contents of the field 1s greater than or equal to the value e LE Less than or equal Use this test to determine if the contents of the field is less than or equal to the value e CT Contains Use this test to determine if the value specified 1s contained in the field selected e NC Does Not Contain Use this test to determine if the value specified is Not contained in the field selected Page 11 Fields as Comparison Values If you use a field as a value that is in the Value column on the display the field can be any field that has been previously defined in the DBUnifier Application Also the fields being compared do not have to be the same length and numeric fields do not have to have the same number of decimal positions Character Constants as Comparison Values A character constant is simply characters enclosed in apostrophes The apostrophes are important because DBUnifier assumes that any group of character not enclosed by apostrop
97. specify N in the Save Application prompt field all changes will be discarded Application The Application prompt field defined the name of the application that you are saving the definition changes to If this is a new application the definition will be saved If this is a change to an existing application and error will occur and you will not be allowed to overlay the existing application Library Library denotes the library where the DBUnifier application will be saved To choose from a list of libraries position the cursor on the Library prompt field and press the F4 Prompt command key Text The Text prompt field allows you to assign some descriptive text about the application The text reminds you what the DBUnifier Application is for when it is displayed in a list of applications Page 61 Exit this Application Command Keys Command Keys F1l Help F3 Exit F4 Prompt F5 Refresh F10 Command F12 Cancel F24 More Keys Description of Command Key Help information has not yet been made available This command key is for future use The Exit command key exits from the Exit this Application display The Prompt command key shows the list of possible values that can be assigned to the field The Refresh command key clears the screen and resets the display to its initial values The Command command key displays a command entry line Which allows you to executed OS 400 commands The Cancel command key exits the user f
98. t until the first match 1s found Special value CURLIB checks the current library for the job to locate the application definition The Execution Mode prompt field tell the DBUnifier Processor the mode the application is to be processed The possible modes are INQUIRY for inquiry mode only UPDATE which allows changes to be made to the database records FULL which allows changes inserts adds and deletions to the database records and NODELETE which allows changes and inserts adds to the database records The File Name prompt field specifies the database file to be accessed by the DBUnifier Processor By using the default value DEFAULT the file that was specified when the application was defined is used The File Library Name prompt field qualifies the library where the file will be accessed Special value LIBL tells the processor to search all the libraries in the job s library list until the first match 1s found Special value CURLIB checks the current library for the job to locate the file to process Page 74 Member name Relative Record Number Return Key Pressed The Member Name prompt field specifies the member name of the file you would like to process The default value for this field is FIRST which denotes to the DBUnifier Processor to use the first member in the file defined The Relative Record Number of the record from the file being processed that was selected from the DBUnifier Processors Multi Reco
99. te t lata ited ath lal td d ket ae 36 Define Screen Layout Command Keys ise a ele a mite d Eie a elu aed Geos 38 DEFINING EXTENDED FIELD ATTRIBUTES 00 ccccscssccssccssccscccsccssccssccsccssccccccssccssccscsesces 39 Define Extended Field Attributes Prompt F elds ccc iiis et sessile e ee aero ees 39 Define Extended Field Attributes Command Keys sse eene eene eene eene eene nnns 40 DEFINING PROMPT PROGRAM FOR FIEL D eee esee eee eee eere eee ee ese sese see ee sese sese seseeeoeeone 41 Define Prompt Program for Field Prompt Fields ccccccccccccccc ccc cece cece EEE EERE EEE 41 Define Prompt Program for Field Command Keys sees eene eene thee 42 DEFINING RELATIONAL OPERATORS FOR FIELD VALIDITY CHECKS 43 Define Relational Operators Prompt Fields cccccc ccc EERE EEE 43 Define Relational Operators Command Keys ss audiunt ti ooa cadat ela etae a hiss ona luod mex deua 44 Usine More Thon One Comparison POSER etie eei el ate BA recapito pus uu ban Ku toit rusa di Rud e 44 COmpuartson TOSts accu tette uisi eo tetto sesta UOI ois ad uc st Aa cuc re actu isi du it ecole eese fuut 44 Testing for Values that are Similar LIKE NLIKE s issssisessesseseeeeeeeeeeeee eene nennen inns aaa sas a aaa a sanas 45 Fields as Comparison ValieSssdeeueiomi EEES E eate edente tu bud ms ed tat delit 45 Character Constants as Comparison Valles isase iota ie tio
100. ted from the DBUnifier Processor Multi Record Display screen The record is returned in the format of the external data structure of the file being processed by the DBUnifier Processor The Data Return Variable has a maximum length of 9999 characters Run DBUnifier Processor RUNDBUAPP command Command Keys Command Keys F3 Exit F4 Prompt F5 Refresh F9 AII Parameters F11 Keywords F12 Cancel F13 How to use this display F14 Command String F15 Error Messages F16 Complete Command F24 More Keys Description of Command Key The Exit command key exits from the Run DBUnifier Application Processor command display The Prompt command key shows the list of possible values that can be assigned to the field The Refresh command key clears the screen and resets the display to its initial values The All Parameters command key shows entry field for all parameters including those not selected by entries on previous parameters and those commonly used The Keywords command key toggles between the version of the prompt display that shows possible choices and the version that show parameter keywords The Cancel command key exits the user from the Run DBUnifier Processor command display The How to use this display command key shows help for the prompt display The Command String command key shows the resulting command as it would run with the parameter values currently entered The Error Messages command key shows all error messag
101. termined by the options that are specified during the application creation or definition There are two major screens within the Application Processor the first screen to be displayed when the application processor is invoked is the Initial Multi Record Display Subfile screen the second major screen is the Record Detail portion screen Initial Multi Record Display Subfile The following shows and describes the functionality of the Initial Multi Record Display Subfile Initial Multi Record Display Subfile screen An Example DBUnifier Applicaton Presidents Master File Maintenance Ss press Enter Change jJ Displau Details Mame City GEORGE WASHINGTON MOUNT VERNON JOHN ADAMS QUINCY THOMAS JEFFERSON GHEREDUTTESVILLE JAMES MADISON MONTPELIER STATION cn Te co nr m JAMES MONROE JOHN QUINCY ADAMS ANDREW JACKSON MARTIN VAN BUREN WILLIAM HENRY HARRISON 0 0m RICHMOND QUINCY HERMITAGE KINDERHU UK NORTH BEND JOHN TYLER JAMES POLE ZACHARY TAYLOR RICHMOND NASHVILLE S MATTHEWS Fi Help T Fi2 Cancel Fbh Set key Position 15 Define Search Filb Perform Search User Define Message Line Initial Multi Record Display Subfile Options Options Description of Option 1 Select Select returns the Relative Record Number and the Record Data to the calling program By typing a next to the entry list and pressing the Enter key the first entry selected will be returned
102. th DBUnifier Applications display OBUnifier version 4 2 Work with DBUnifier Applications 110904 La be 0D Lrbb3PH c X Got ea es LIBL Jame LIGBL F4 for list SUBSE Qu oat od cus x HLL dame generic Posi Lion EU 2s 3 5 ing characters 1 fand DBUnifier Application pr P Change a Con 5 Displ B PF1int dzRun Hpplication Library Text EAHMPLE DBUNMIFIER Hn Example OBUnifier Application mum Lied DBLUNIFIER Example Selection List Of Presidents OUTPUT OQ OBUNIFIER Example Prompt Sele utput Queue SAMFLE DBUNIFIER STATE DIBURIFIER lle Maintenance STATEGODE DBUNIFIER State Codes Bottom Fl Help j Exit F4 Prompt TIE F44 More Keys C Copyright PraData Computer Services Inc 2004 Work with DBUnifier Application Options Options Description of Option 1 Create Creates defines a new application When this option is processed the Work with DBUnifier Application display is shown so you can start defining an application 2 Change Change an existing application The Work with DBUnifier Application display is shown for this option also 3 Copy Copies an existing application The Copy DBUnifier Application display is shown 4 Delete Deletes an existing application The Confirm Deletion of DBUnifier Application display is shown 5 Display Shows the application without being able to change it To change the application choose option 2 the Work with DBUnifier Applicati
103. that were selected in the Define Initial Multi Record Display There are two lines of column headings that can be input Window Footer The Window Footer allows you to input the Window Footer Text for your Initial Multi Record Display Subfile This text is also displayed on the Detail Screen of your DBUnifier Application Page 30 Specify Screen Options Command Keys Command Keys F1l Help F3 Exit F5 Refresh F10 Command F11 Center F12 Cancel F13 Select Screen Size F14 Column Spacing F24 More Keys Description of Command Key Help information has not yet been made available This command key is for future use The Exit command key exits from the Specify Screen Options display The Refresh command key clears the screen and resets the display to its initial values The Command command key displays a command entry line Which allows you to executed OS 400 commands The Center command key centers the text for the field where the cursor is positioned when the key is pressed The Cancel command key exits the user from the Specify Screen Options display The Select Screen Size command key allows you select from a list one of the available screen sizes for your Initial Multi Record Display Subfile The Column Spacing command key allows you to Define Column Spacing for fields that have been selected for the Initial Multi Record Display Subfile The More Keys command key displays other command keys that ar
104. the Printed DBUnifier Application Definition Page 66 Example DBUnifier Application Definition Report DBUNIFIER DBF6000 DBUnifier Application Definition 12 12 54 PAGE 1 11 12 2004 WEBSTER Application EXAMPLE An Example DBUnifier Application Library DBUNIFIER Version V4R2 04056 Screen Size z 22x75 window Title An Example DBUnifier Applicaton Application Title Presidents Master File Maintenance Column Heading 1 Key Column Heading 2 Value Name City Copyright Notice User Define Message Line File EXAMPLEL Library LIBL Member FIRST Format EXAMPLE Result Fields Expression Length Decimal NEWFIELD substr name 1 10 10 Seq Field Name Description Type Length Decimal Edit Code 10 KEY Record Key P 9 0 Z 20 NAME Name A 30 30 CITY City A 30 Seq Pag Lin Col Usage Field Name Pag Lin Col Text Type Length Decimal Edit Code 10 1 6 30 I DLTFLAG 1 6 3 Delete Flag A 1 20 1 7 30 I KEY 1 7 3 Record Key P 9 0 Z 30 1 8 30 I NAME 1 8 3 Name E A 30 40 1 9 30 I ALTNAME 1 9 3 Alternate Name A 30 50 1 10 30 I TITLE 1 10 3 Title t A 20 60 1 11 30 I COMPANY Li bi 3 Company Name A 30 70 1 12 30 I ADDR1 l 12 3 Address 1 A 30 80 1 13 30 I ADDR2 1 13 3 Address 2 A 30 90 1 14 30 I ADDR3 1 14 3 Address 3 A 30 100 1 15 30 I CITY 1 15 3 city EUM A 30 110 1 16 30 I STATE 1 16 3 State Province A 20 120 1 17 30 I COUNTRY 1 17 3 Country A 30 130 1 18 30 I POSTAL 1 18 3 Postal code A 10 140 1 19 30 I PHONE 1 19 3 Phone N
105. to use the first member in the file defined Query Selection Expression INPUT CHAR 256 Specifies the selection values used to determine the records that are available to the DBUnifier Processor The default value ALL selects all records in the database file to process Relative Record Number OUTPUT INTEGER 10 0 Returns the relative record number of the record from the file being processed that was selected from the DBUnifier Processor s Multi Record Display screen 7f this return value is zero No Record Was Selected The return value is a 10 0 digit integer For RPG amp RPG 400 the return value can be defined as a BIN4 field Data Returned OUTPUT CHAR 32766 The value of the record from the file being processed that was selected from the DBUnifier Processor Multi Record Display screen The data is retuned in the format of the external data structure of the file being processed Page 84 Defining Audit Logging For DBUnifier Applications The Define Audit Log Information display allows you to define the audit logging images If any you want to be written when a record is added changed or deleted within a DBUnifier Application This screen also allows you to denote the Audit Log File and Library The Audit Log File must match the file layout of DBFHST in library DBUnifier Define Audit Log Information display DBUnifier version 4 2 Define Audit Log Information 12 06 04 bole ce Type cholic Audit Log Ima
106. turn a substring of the string argument with the length equal to the value specified by the length expression Accepts a character string argument an optional strip character and an optional strip function as arguments It returns a result string with the strip character removed from the string argument as specified by the strip function The strip function can be one of three functions 0 A elle LEAD Remove leading strip character s TRAIL Removes trailing strip character s BOTH Remove both leading and trailing strip character s The default strip function is BOTH r Accept a character string a starting position expression and an optional length SUBSTRIN i i G expression as arguments They return a substring of the string argument with the length equal to the value specified by the length expression SUM Accepts a numeric argument and returns the sum of all the values for its argument The argument must be a field name or an expression not a literal Page 80 Built in Functions continued Accepts a numeric argument and returns the tangent of the argument The VoL AN argument must be specified in radians TAN and ATAN are inverse operations Accepts a numeric argument and returns the hyperbolic tangent of the VoL ANH argument The argument must be specified in radians TANH and VoATANH are inverse operations Accepts a date time argument and returns a time The date time argument can be a time or timestamp field
107. turns the number of bytes used to represent the value unless the value is a graphic field type If the value is a graphic field type the number of graphic characters is returned The length argument can be of any type The returned value is of type BIN4 LEN Accepts a numeric argument and returns the natural logarithm of the 0 ALN argument LN and EXP are inverse operations Accepts a numeric argument and returns the common logarithm base 10 of the argument LOG and ANTILOG are inverse operations Accepts one or more character string or date time arguments and returns the largest value from the list Date time arguments are arguments of type DATE TIME or TIMESTP or arguments that are date time or timestamp durations String arguments must be no longer than 256 bytes LOG MAX Accepts a date time argument and returns the microsecond part of the value The date time argument can be a timestamp field or literal a timestamp duration field or literal a character field that contains the external form of a timestamp or a numeric field or literal The returned value is of type BIN4 MICSEC Accepts one or more character string or date time arguments and returns the smallest value from the list Date time arguments are arguments of type DATE TIME or TIMESTP or arguments that are date time or timestamp durations String arguments must be no longer than 256 bytes MIN Accepts a date time argument an
108. ue or Character string that is wrapped in single quotes This is the value that is used in the comparison with the associated field Page 10 i Define Search Command Keys Command Keys _ Description of Command Key F1l Help Help information has not yet been made available This command key 1s for future use F3 Exit The Exit command key exits from the Define Search display F4 Prompt The Prompt command key shows the list of possible values that can be assigned to the field F5 Refresh The Refresh command key clears the screen and resets the display to its initial values F12 Cancel The Cancel command key exits the user from the Define Search display F13 Change The Change Defaults command key displays the Change Search Defaults window From this window you can Defaults define the Occurrences to process Next or Previous Kind of match to process Same Case or Ignore Case and the maximum number of Records to Search at one time F24 More Keys The More Keys command key displays other command keys that are available Using More Than One Comparison Test When you use more than one comparison you need to tell the DBUnifier Processor how to connect them by typing a connection in the AND OR column The two types of connections are e AND Continues connections e OR Separates connections All of the comparisons that are connected by the AND s must be true for the field value to be accepted by that group of comparisons Comparison Test
109. umber A 25 150 1 20 30 I FAX 1 20 3 Fax Number A 25 160 2 6 30 I EMAIL 2 6 3 eMail Address A 50 170 2 8 30 I ADDUSER 2 8 3 Added By User A 10 180 2 9 30 I ADDPGM 2 9 3 Add Program A 10 190 2 10 30 I ADDDATE 2 10 3 Add Date L 10 200 2 11 30 I ADDTIME 2 11 3 Add rime se T 8 210 2 12 30 I LSTUSER 2 12 3 Last Update User A 10 220 2 13 30 I LSTPGM 2 13 3 Last Update Program A 10 230 2 14 30 I LSTDATE 2 14 3 Last Update Date L 10 240 2 15 30 I LSTTIME 2 15 3 Last Update Time T 8 DataBase Validation Field File Library Field Exists STATE STATEPF LIBL STATE YES List of values Field Screen Title Enforce Value Description DLTFLAG List Of Delete Codes YES Blank Active DBUNIFIER DBF6000 DBUnifier Application Definition 12 12 54 PAGE 2 11 12 2004 WEBSTER List of values Field Screen Title Enforce Value Description DLTFLAG List Of Delete Codes YES S Suspended D Flagged For Deletion Prompt Program Application2 Field Type Pgm App Library Return Start Length STATE DBUAPP STATECODE LIBL STATE 2 2 DBUAPP STATECODE LIBL STATE 2 2 DBUAPP STATECODE LIBL STATE 2 2 DBUAPP STATECODE LIBL STATE 2 2 Error Message Information Field Validation Routine First Second Level Message Text DLTFLAG List of Values 1 p se entered for Delete Flat Is Invalid Press F4 for a list of values 2 This is the second level text See Chris STATE Database Validation 1 Invalid State Code Please Correct amp Retry 2 The State Code entered
110. v utto tud babe ue Miam dos 45 Nuneric Constants as Comparison Values 5 ves asias lutei vel E be titu uite nein eateaees 45 Date Time Timestamp Constants as Comparison Values ccccccccccccccccccc cece cece eene eene 45 II DEFINING RANGES FOR FIELD VALIDITY CHECKS 0 ccsssssssssssssssssssssssssssssssssssssssccsees 46 Define Kange S DURUM 46 enne RANGE ommand KOysisssddatone e te t o E E Me O AAEE iaa ede aues 47 Usine More Tham One Range T CSE eso tereti reb tp be ostrea epp bod o eee nitet 47 DETINUIT o C celta rh raid Berl eal Sts BS cas rah al Ade Beas eal acts cae rath al cnt o 47 Character onstants OS KONCEV QOS ait ae aaa oan A tA tatum eee ba ee 47 Numeric Constan s as kange alles oceanerna ea ele dus ads adi ert 47 Date Time Timestamp Constants as Range Values sse eene 47 DEFINING LIST OF VALUES FOR FIELD VALIDITY CHECKS eere eere eren 48 Jennie EiStob Values POMPE eldest sts ut ap tita T tumet uter Seats bea ee E 46 Define List of Values Commana Keysisiiiauotosn ui o e e f ME ut ia e 49 DEFINING DATABASE VALIDATION FOR FIELD VALIDITY CHECKS 50 Define Database Validation Prompt Fields seen eene enne 50 Define Database Validation Command Keys etsi ti ied ea rio 3o ea YI TORIA ELE RE ERR RS meee 31 CO OST d EEE ac iM E IEEE CL iM LE CX iL I nace ee RE M LE LLL A 52 Select Jule DEOMDIJA TOI aec me secu E A A DL
111. yout allows you to define the Page Line and Column where a field will be presented in the detail portion of the DBUnifier Application processor The page line and column change be changed for a field or a label Text Labels can be changed Field Usage is defined Edit Codes can be assigned to numeric values and Extended field Attributes are maintained from this screen P L M _i A A i E ER Bd LA m LA EU EH 1 P i25 c3 Lm PJ m ra 1 II L E Define Screen Layout display DBUnifier wersion 4 2 Define Screen Layout Type information press Enter Field DLTFLAG KEY NAME ALTNAME TITLE COMPANY ADORI et X3 LE 46 3 ED Co Ix 3 D x QUe I L 3t Mare rF2d More Keys TI Define Screen Layout Prompt Fields Field Page Line Column Usage Text Description of Prompt Field Page specifies which page the field or label will be presented on when DBUnifier Application is being processed Line specifies which line the field or label will be presented on when DBUnifier Application is being processed Column specifies which column the field or label will be presented on when DBUnifier Application is being processed Usage determines whether input is allows into this field when being displayed The default usage is O utput only To allow input into this field change the usage prompt to I nput Th

DBUnifier User`s Manual

Contents

Download Pdf Manuals

Related Search

Related Contents