Adding functions to a new section in the file

If entries for your back-end DBMS do not exist in PBODB110.INI, use the following procedure to create the required sections and add the appropriate functions.

NoteBefore you start For more about the settings to supply for your back-end DBMS in PBODB110.INI, read the comments at the end of the file.

StepsTo add functions to a new section in PBODB110.INI:

  1. Open PBODB110.INI in one of the following ways:

  2. Edit the DBMS Driver/DBMS Settings section of the PBODB110 initialization file to add an entry for your back-end DBMS.

    NoteFinding the name The name required to identify the entry for your back-end DBMS in the DBMS Driver/DBMS Settings section is in PBODB110.INI.

    Make sure that you:

    For example, here is the relevant portion of an entry for a DB2/2 database:

    ;***********************************************
    
    ;DBMS Driver/DBMS Settings
    
    ;***********************************************
    
    [DB2/2]
    
    ...
    
    PBFunctions='DB22_FUNCTIONS'
    
    ...
    
  3. Edit the Functions section of PBODB110.INI to add an entry for your back-end DBMS.

    Make sure that you:

    For example:

    ;***********************************************
    
    ;Functions
    
    ;***********************************************
    
    [DB22_FUNCTIONS]
    
    AggrFuncs=avg(),count(),list(),max(),min(),sum()
    
    Functions=curdate(),curtime(),hour(), ...
    
  4. Type a comma followed by the function name at the end of the appropriate function list, as follows:

    NoteCase sensitivity If the back-end DBMS you are using is case sensitive, be sure to use the required case when you add the function name.

    The following example shows (in bold) a new DB2/2 function named substr() added at the end of the Functions list:

    ;***********************************************
    
    ;Functions
    
    ;***********************************************
    
    [DB22_FUNCTIONS]
    
    AggrFuncs=avg(),count(),list(),max(),min(),sum()
    
    Functions=curdate(),curtime(),hour(), substr()
    
  5. Save your changes to PBODB110.INI.