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 PBODB100.INI – PB Docs 100 – PowerBuilder Library

Adding functions to PBODB100.INI – PB Docs 100

  2. Powerbuilder Documentation
  3. Powerbuilder Documentation Older
  4. Powerbuilder Documentation 10.0
  5. Adding functions to PBODB100.INI – PB Docs 100

Adding functions to PBODB100.INI

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

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

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

    For example, here is thePBODB100.INI entry
    for ASA:

  3. Find the name of the section in PBODB100.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 ASA indicates that the name of the Functions
    section is ASA_FUNCTIONS:

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

    For example, here is the Functions section for ASA:

  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 ASA added at
    the end of the Functions list:

  6. Save your changes to PBODB100.INI.

Adding functions to a new section in the file

If entries for your back-end DBMS do not exist in PBODB100.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 PBODB100.INI, read the
comments at the end of the file.

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

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

    Make sure that you:

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

    Make sure that you:

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

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