Step 2: declare the stored procedure as an external function – PB Docs 150
Step 2: declare the stored procedure as an external function FUNCTION or SUBROUTINE declaration You can declare a non-result-set database stored procedure as an external function or external subroutine in a PowerBuilder application. If the stored procedure has a return value, declare it as a function (using the FUNCTION keyword). If the stored procedure returns…
Step 1: define the standard class user object – PB Docs 150
Step 1: define the standard class user object To define the standard class user object: Start PowerBuilder. Connect to a database that supports stored procedures. The rest of this procedure assumes you are connected to an Oracle database that contains remote stored procedures on the database server. For instructions on connecting to an Oracle database…
Using Transaction objects to call stored procedures – PB Docs 150
Using Transaction objects to call stored procedures SQLCA is a built-in global variable of type transaction that is used in all PowerBuilder applications. In your application, you can define a specialized version of SQLCA that performs certain processing or calculations on your data. If your database supports stored procedures, you might already have defined remote…
Running and examining examples – PB Docs 150
Running and examining examples Once you have located an example that performs some processing you want to learn about, you can run it to examine how it works and look at the code (and copy it if you want to). Running an example To run the highlighted example, double-click it or click Run!. You can…
Pooling database transactions – PB Docs 150
Pooling database transactions Transaction pooling To optimize database processing, an application can pool database transactions. Transaction pooling maximizes database throughput while controlling the number of database connections that can be open at one time. When you establish a transaction pool, an application can reuse connections made to the same data source. How it works When…
Error handling after a SQL statement – PB Docs 150
Error handling after a SQL statement When to check for errors You should always test the success or failure code (the SQLCode property of the Transaction object) after issuing one of the following statements in a script: Transaction management statement (such as CONNECT, COMMIT, and DISCONNECT) Embedded or dynamic SQL Not in DataWindows Do not…
Defining Transaction objects for multiple database connections – PB Docs 150
Defining Transaction objects for multiple database connections Use one Transaction object per connection To perform operations in multiple databases at the same time, you need to use multiple Transaction objects, one for each database connection. You must declare and create the additional Transaction objects before referencing them, and you must destroy these Transaction objects when…
Creating and modifying publications – PB Docs 150
Creating and modifying publications You create publications using Sybase Central or the SQL CREATE PUBLICATION statement. In Sybase Central, all publications and articles appear in the Publications folder. This section describes how to create publications in Sybase Central. For information about creating and modifying publications using SQL, see the online MobiLink – Client Administration book….
Creating remote databases – PB Docs 150
Creating remote databases Any SQL Anywhere database can be converted for use as a remote database in a MobiLink installation. You can also create a new SQL Anywhere remote database that uses all or part of the schema of the consolidated SQL Anywhere database. You create the database on your desktop using the Sybase Central…
Adding pbdom150.pbx to your application – PB Docs 150
Adding pbdom150.pbx to your application The PBDOM classes are implemented in a DLL file with the suffix PBX (for PowerBuilder extension). The simplest way to add the PBDOM classes to a PowerBuilder target is to import the object descriptions in the pbdom150.pbx PBX file into a library in the PowerBuilder System Tree. You can also…