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 PBODB110.INI – PB Docs 110 – PowerBuilder Library

Adding functions to PBODB110.INI – PB Docs 110

  2. Powerbuilder Documentation
  3. Powerbuilder Documentation Older
  4. Powerbuilder Documentation 11.0
  5. Adding functions to PBODB110.INI – PB Docs 110

Adding functions to PBODB110.INI

PBODB110.INI lists the functions for
certain DBMSs that have ODBC drivers. If you need to add a function
to PBODB110.INI 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 PBODB110.INI.
  • New sections Create new sections for your back-end DBMS in PBODB110.INI 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 PBODB110.INI,
use the following procedure to add new functions.

proc.gif To add functions to an existing section in PBODB110.INI:

  1. Open PBODB110.INI 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 PBODB110.INI.

    For example, here is thePBODB110.INI entry
    for SQL Anywhere:

    SQL Anywhere]

  3. Find the name of the section in PBODB110.INI 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 SQL Anywhere indicates that the name of the Functions
    section is ASA_FUNCTIONS:

  4. Find the Functions section for your back-end DBMS
    in PBODB110.INI.

    For example, here is the Functions section for SQL 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 SQL Anywhere
    added at the end of the Functions list:

  6. Save your changes to PBODB110.INI.

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.

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

proc.gif To add functions to a new section in PBODB110.INI:

  1. Open PBODB110.INI 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 PBODB110 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 PBODB110.INI.

    Make sure that you:

    • Follow
      the instructions in the comments at the end of PBODB110.INI.
    • Use the same syntax as existing entries in the DBMS
      Driver/DBMS Settings section of PBODB110.INI.
    • 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 PBODB110.INI to
    add an entry for your back-end DBMS.

    Make sure that you:

    • Follow
      the instructions in the comments at the end of PBODB110.INI.
    • Use the same syntax as existing entries in the Functions
      section of PBODB110.INI.
    • 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 PBODB110.INI.

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