Adding functions to a new section in the file
If entries for your back-end DBMS do not exist in PBODB126.INI,
use the following procedure to create the required sections and
add the appropriate functions.
Before you start
For more about the settings to supply for
your back-end DBMS in PBODB126.INI, read the
comments at the end of the file.
To add functions to a new section in PBODB126.INI:
-
Open PBODB126.INI in
one of the following ways:-
Use
the File Editor in PowerBuilder. (For instructions, see the Users Guide.) -
Use any text editor outside PowerBuilder.
-
-
Edit the DBMS Driver/DBMS Settings section
of the PBODB126 initialization file to add an entry for your back-end
DBMS. Finding the name
The name required to identify the entry for your back-end
DBMS in the DBMS Driver/DBMS Settings section is in PBODB126.INI.Make sure that you:
-
Follow
the instructions in the comments at the end of PBODB126.INI. -
Use the same syntax as existing entries in the DBMS
Driver/DBMS Settings section of PBODB126.INI. -
Include a section name for PBFunctions.
For example, here is the relevant portion of an entry for
a DB2/2 database:1;***********************************************1;DBMS Driver/DBMS Settings1;***********************************************1[DB2/2]1...1PBFunctions='DB22_FUNCTIONS'1... -
-
Edit the Functions section of PBODB126.INI to
add an entry for your back-end DBMS.Make sure that you:
-
Follow
the instructions in the comments at the end of PBODB126.INI. -
Use the same syntax as existing entries in the Functions
section of PBODB126.INI. -
Give the Functions section the name that you specified
for PBFunctions in the DBMS Driver/DBMS Settings entry.
For example:
1;***********************************************1;Functions1;***********************************************1[DB22_FUNCTIONS]1AggrFuncs=avg(),count(),list(),max(),min(),sum()1Functions=curdate(),curtime(),hour(), ... -
-
Type a comma followed by the function name at
the end of the appropriate function list, as follows:-
Aggregate functions
Add aggregate functions to the end of the AggrFuncs list.
-
All other functions
Add all other functions to the end of the Functions list.
Case 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:1;***********************************************1;Functions1;***********************************************1[DB22_FUNCTIONS]1AggrFuncs=avg(),count(),list(),max(),min(),sum()1Functions=curdate(),curtime(),hour(), <span>substr()</span> -
-
Save your changes to PBODB126.INI.