Connecting through the Open ServerConnect middleware product – PB Docs 2017
Connecting through the Open ServerConnect middleware product SAP’s Open ServerConnect supports mainframe applications that retrieve and update data stored on the mainframe that SAP client applications can execute. Client applications can connect directly to a DB2/MVS database through an Open ServerConnect application residing on the mainframe, eliminating the need for an intermediate gateway like DirectConnect….
Setting preferences in the Database Preferences dialog box – PB Docs 2017
Setting preferences in the Database Preferences dialog box To set the following connection-related database preferences, complete the Database Preferences dialog box in the PowerBuilder Database painter: Shared Database Profiles Connect to Default Profile Read Only Keep Connection Open Use Extended Attributes SQL Terminator Character Other database preferences The Database Preferences dialog box also lets you…
Selecting the type of connection – PB Docs 2017
Selecting the type of connection To select how PowerBuilder accesses the database, use the Choose Gateway drop-down list on the Connection tab of the DirectConnect Database Profile Setup dialog box and select one of the following: Access Service Gatewayless TRS All the DBParm parameters defined for the DirectConnect interface are applicable to all three connections except…
Creating the extended attribute system tables – PB Docs 2017
Creating the extended attribute system tables When you create or modify a table in PowerBuilder, the information you provide is stored in five system tables in your database. These system tables contain extended attribute information such as the text to use for labels and column headings, validation rules, display formats, and edit styles. (These system…
RPC calls to stored procedures with array parameters – PB Docs 2017
RPC calls to stored procedures with array parameters If your application performs a remote procedure call (RPC) that passes an array parameter to an Oracle stored procedure, the array size in the stored procedure must not be zero. If the array size is uninitialized (has no size), the PBVM returns an error. Document get from…
Using DirectConnect – PB Docs 2017
Using DirectConnect Contents Using the DirectConnect interface Supported versions for the DirectConnect interface Supported DirectConnect interface datatypes Basic software components for the DirectConnect interface Preparing to use the database with DirectConnect Defining the DirectConnect interface Creating the extended attribute system tables in DB2 databases About this chapter This chapter describes how to use the DirectConnect…
Setting database parameters in a PowerBuilder application script – PB Docs 2017
Setting database parameters in a PowerBuilder application script Contents Copying DBParm syntax from the Preview tab Coding PowerScript to set values for the DBParm property Reading DBParm values from an external text file If you are developing an application that connects to a database, you must specify the required connection parameters in the appropriate script as…
Connecting through the DirectConnect middleware product – PB Docs 2017
Connecting through the DirectConnect middleware product SAP DirectConnect is a data access server that provides a standardized middleware interface between your applications and your enterprise data sources. Data access services to a particular database are defined in a DirectConnect server. Since a DirectConnect server can support multiple access services, you can access multiple databases through…
Coding PowerScript to set values for the DBParm property – PB Docs 2017
Coding PowerScript to set values for the DBParm property Another way to specify connection parameters in a script is by coding PowerScript to assign values to properties of the Transaction object. PowerBuilder uses a special nonvisual object called a Transaction object to communicate with the database. The default Transaction object is named SQLCA, which stands for SQL…
Granting permissions on system tables to control access – PB Docs 2017
Granting permissions on system tables to control access If your DBMS supports SQL GRANT and REVOKE statements, you can control access to the PowerBuilder system tables. The default authorization for each repository table is:
|
1 |
GRANT SELECT, UPDATE, INSERT, DELETE ON table TO PUBLIC |
After the system tables are created, you can (for example) control access to them by granting SELECTÂ authority to end users and SELECT, UPDATE, INSERT,…