Connection Information

To perform the requested action, WordPress needs to access your web server. Please enter your FTP credentials to proceed. If you do not remember your credentials, you should contact your web host.

Connection Type

Adding functions to the PBODB90 initialization file – PB Docs 90 – PowerBuilder Library

Adding functions to the PBODB90 initialization file – PB Docs 90

  2. Powerbuilder Documentation
  3. Powerbuilder Documentation Older
  4. Powerbuilder Documentation 9.0
  5. Adding functions to the PBODB90 initialization file – PB Docs 90

Adding functions to the PBODB90 initialization file

The PBODB90 initialization file lists the functions for certain
DBMSs that have ODBC drivers. If you need to add a function to the
PBODB90 initialization file for use with your back-end DBMS, you
can do either of the following:

  • Existing sections Add the function to the Functions section for your back-end
    database if this section exists in the PBODB90 initialization file.
  • New sections Create new sections for your back-end DBMS in the PBODB90
    initialization file and add the function to the newly created Functions
    section.

Adding functions to an existing section in the file

If sections for your back-end DBMS already exist in
the PBODB90 initialization file, use the following procedure to
add new functions.

proc.gif To add functions to an existing section in the
PBODB90 initialization file:

  1. Open the PBODB90 initialization file in
    one of the following ways:

    • Use
      the File Editor in PowerBuilder. (For instructions, see the User’s Guide
      .)
    • Use any text editor outside PowerBuilder.
  2. Locate
    the entry for your back-end DBMS in the DBMS Driver/DBMS Settings
    section of the PBODB90 initialization file.

    For example, here is the PBODB90 initialization file entry
    for Adaptive Server Anywhere:

  3. Find the name of the section in the PBODB90 initialization
    file that contains function information for your back-end DBMS.

    To find this section, look for a line similar to the following
    in the DBMS Driver/DBMS Settings entry:

    For example, the following line in the DBMS Driver/DBMS
    Settings entry for Adaptive Server Anywhere indicates that the name
    of the Functions section is ASA_FUNCTIONS:

  4. Find the Functions section for your back-end DBMS
    in the PBODB90 initialization file.

    For example, here is the Functions section for Adaptive Server
    Anywhere:

  5. To add a new function, 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.

    note.gif 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 a new function for Adaptive Server Anywhere
    added at the end of the Functions list:

  6. Save your changes to the PBODB90 initialization
    file.

Adding functions to a new section in the file

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

note.gif Before you start For more about the settings to supply for
your back-end DBMS in the PBODB90 initialization file, read the
comments at the end of the file.

proc.gif To add functions to a new section in the PBODB90
initialization file:

  1. Open the PBODB90 initialization file in
    one of the following ways:

    • Use
      the File Editor in PowerBuilder. (For instructions, see the User’s Guide
      .)
    • Use any text editor outside PowerBuilder.
  2. Edit the DBMS Driver/DBMS Settings section
    of the PBODB90 initialization file to add an entry for your back-end
    DBMS.

    note.gif Finding the name The name required to identify the entry for your back-end
    DBMS in the DBMS Driver/DBMS Settings section is in the
    ODBC initialization file.

    For information about the name and location
    of the ODBC initialization file on your platform, see “How PowerBuilder accesses
    the data source”    .

    Make sure that you:

    • Follow
      the instructions in the comments at the end of the PBODB90 initialization
      file.
    • Use the same syntax as existing entries in the DBMS
      Driver/DBMS Settings section of the PBODB90 initialization
      file.
    • Include a section name for PBFunctions.

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

  3. Edit the Functions section of the PBODB90 initialization
    file to add an entry for your back-end DBMS.

    Make sure that you:

    • Follow
      the instructions in the comments at the end of the PBODB90 initialization
      file.
    • Use the same syntax as existing entries in the Functions
      section of the PBODB90 initialization file.
    • Give the Functions section the name that you specified
      for PBFunctions in the DBMS Driver/DBMS Settings entry.

    For example:

  4. 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.

    note.gif 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:

  5. Save your changes to the PBODB90 initialization
    file.

Document get from Powerbuilder help
Thank you for watching.
Powerbuilder Documentation 9.0
PB Docs 90 Powerbuilder Connecting To Your Database Powerbuilder Documentation Powerbuilder Documentation 9.0 Powerbuilder Documentation Older
August 3, 2023
Was this article helpful?
5
3
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x