Powerbuilder Connecting To Your Database

Reading DBParm values from an external text file – PB Docs 2017

Reading DBParm values from an external text file As an alternative to setting the DBParm property in a PowerBuilder application script, you can use the PowerScript ProfileString function to read DBParm values from a specified section of an external text file, such as an application-specific initialization file. To read DBParm values from an external text file: Open…

Using the OData Interface (Deprecated) – PB Docs 2017

Using the OData Interface (Deprecated) Contents Database Profile Setup – OData Dialog Box Database Painter Create a DataWindow Using an OData Service Set the Connection Information for the OData Service A known issue with OData About this chapter This chapter describes the OData interface and explains how to prepare to use this interface and how…

Connection Tab – PB Docs 2017

Connection Tab The Connection tab includes basic connection options that you must supply to access the information in the OData service. Profile Name The name of your database profile. Connection Information The uniform resource identifier (URI) that represents the OData service. Authenticated Access Select the type of access: Anonymous access — Opens up the service…

Using Oracle stored procedures with result sets – PB Docs 2017

Using Oracle stored procedures with result sets Overview of basic steps The following procedure assumes you are creating the stored procedure in the ISQL view of the Database painter in PowerBuilder. To use an Oracle stored procedure with a result set: Set up the ISQL view of the Database painter to create the stored procedure. Create the…

Setting Use Extended Attributes or Read Only to control access – PB Docs 2017

Setting Use Extended Attributes or Read Only to control access To control system table access by setting Use Extended Attributes or Read Only: Select Design>Options from the menu bar to display the Database Preferences dialog box. On the General page, set values for Use Extended Attributes or Read Only as follows: Preference What you do…

Using a large-object output parameter – PB Docs 2017

Using a large-object output parameter You can define a large object (LOB) as an output parameter for an Oracle stored procedure or function to retrieve large-object data. There is no limit on the number of LOB output arguments that can be defined for each stored procedure or function. In Oracle 10g, the maximum size of…

Importing an ADO.NET Connection from a Third-Party .NET Assembly – PB Docs 2017

Importing an ADO.NET Connection from a Third-Party .NET Assembly You can import an ADO.NET connection from an external .NET assembly into a PowerBuilder application, enabling the application and the assembly to share the connection. Use the SetAdoConnection method:

where proxy is the instance of type IAdoConnectionProxy that is passed in by the third-party assembly. The imported connection…

Exporting an ADO.NET Connection to a Third-Party .NET Assembly – PB Docs 2017

Exporting an ADO.NET Connection to a Third-Party .NET Assembly To export an ADO.NET connection from a PowerBuilder application, use the GetAdoConnection method:

The method returns an instance of IAdoConnectionProxy. The proxy’s ADO connection object is assigned to property IAdoConnectionProxy.Connection. When a transaction starts, the proxy’s active Transaction object is assigned to property IAdoConnectionProxy.Transaction, and…

What is an Oracle stored procedure? – PB Docs 2017

What is an Oracle stored procedure? Oracle defines a stored procedure (or function) as a named PL/SQL program unit that logically groups a set of SQL and other PL/SQL programming language statements together to perform a specific task. Stored procedures can take parameters and return one or more result sets (also called cursor variables). You create stored…

Datatype conversion – PB Docs 2017

Datatype conversion When you retrieve or update columns, in general PowerBuilder converts data appropriately between the Oracle datatype and the PowerScript datatype. Keep in mind, however, that similarly or identically named Oracle and PowerScript datatypes do not necessarily have the same definitions. For information about the definitions of PowerScript datatypes, see Datatypes in PowerScript Reference….