Using the JDBC Driver Manager Trace – PB Docs 70
Using the JDBC Driver Manager Trace This section describes how to use the JDBC Driver Manager Trace tool. About JDBC Driver ManagerTrace You can use the JDBC Driver Manager Trace tool to trace a connection to any database that you access in PowerBuilder through the JDBC interface. Unlike the Database Trace tool, the JDBC Driver…
About the PBODB70 initialization file – PB Docs 70
About the PBODB70 initialization file What is the PBODB70 initialization file? When you access data through the ODBC interface, PowerBuilder uses the PBODB70 initialization file to maintain access to extended functionality in the backend DBMS for which ODBC does not provide an API call. Examples of extended functionality are SQL syntax or function calls specific…
Using database profiles – PB Docs 70
Using database profiles What is a database profile? A database profile is a named set of parameters stored in your PowerBuilder initialization file that defines a connection to a particular database in the PowerBuilder development environment. You must create a database profile for each data connection. What you can do Using database profiles is the…
Defining the ODBC interface – PB Docs 70
Defining the ODBC interface To define a connection through the ODBC interface, you must create a database profile by supplying values for at least the basic connection parameters in the Database Profile Setup – ODBC dialog box. You can then select this profile anytime to connect to your data source in the development environment. For…
Accessing the EAS Demo DB – PB Docs 70
Accessing the EAS Demo DB PowerBuilder includes a standalone Adaptive Server Anywhere database called the EAS Demo DB. The database is installed automatically, unless you clear this option in the Setup program. Initially, you access tables in the EAS Demo DB when you use the PowerBuilder tutorial. An Adaptive Server Anywhere database is considered an…
About the PowerBuilder extended attribute system tables – PB Docs 70
About the PowerBuilder extended attribute system tables PowerBuilder uses a collection of five system tables (formerly known as the Powersoft repository) to store extended attribute information (such as display formats, validation rules, and font information) about tables and columns in your database. You can also define extended attributes when you create or modify a table…
Basic steps for setting connection parameters – PB Docs 70
Basic steps for setting connection parameters This section gives basic steps for setting DBParm parameters and database preferences in PowerBuilder on all supported platforms. To set DBParm parameters: Learn how to set DBParm parameters in the development environment or PowerBuilder application script. See “Setting DBParm parameters”. Determine the DBParm parameters you can set for your…
About the Database Profile Setup dialog box – PB Docs 70
About the Database Profile Setup dialog box The interface-specific Database Profile Setup dialog box makes it easy to set additional connection parameters in the development environment or in a PowerBuilder application script. You can: Supply values for connection options supported by your database interface Each database interface has its own Database Profile Setup dialog box…
Setting DBParm parameters – PB Docs 70
Setting DBParm parameters In PowerBuilder, you can set DBParm parameters by doing either of the following on all supported platforms: Editing the Database Profile Setup dialog box for your connection in the development environment Specifying connection parameters in an application script Setting DBParm parametersin the development environment Editing database profiles To set DBParm parameters for…
Setting database preferences – PB Docs 70
Setting database preferences How to set The way you set connection-related database preferences in PowerBuilder varies, as summarized in the following table (AutoCommit and Lock are the only database preferences that you can set in a PowerBuilder application script): Database preference Set in development environment by editing Set in PowerBuilder application by editing AutoCommit Database…