Using the OData Service (Obsolete)
Creating a DataWindow Using an OData
Service
Select the OData Service data source in the
DataWindow wizard:
-
Select File > New from the menu bar and select
DataWindow.If there is more than one target, select the target where you
want the DataWindow to be created from the drop-down list. -
Choose the presentation style for the DataWindow object and
click Next. -
Select the OData Service datasource and click Next.
-
Select the OData profile and click Next.
In the SQL painter:
-
You can select one table.
-
The Sort, Group, and Having tabs are not available.
-
The Results tab is obsolete, because it is used by
PowerBuilder .NET. -
In the Where tab you can specify some selection criteria
using the WHERE clause for the SELECT statement.
-
-
When you complete the query, click OK.
-
Review your specifications and click Finish.
At runtime, the DataWindow or DataStore can manipulate OData
service data, which includes retrieving, updating, inserting, and
deleting the data.
Setting the Connection Information for the
OData Service
As with other databases, use the SQLCA Transaction object (or
user-defined transaction object) to retrieve and display data from the
OData service in a DataWindow or DataStore.
Set the appropriate values for the transaction object.
Connect to the OData service.
Set the transaction object for the DataWindow or DataStore.
Retrieve and update the data.
When the processes are complete, disconnect from the OData
service.
The code looks something like this:
|
1 2 3 4 5 6 7 8 9 |
SQLCA.DBMS = "ODT" SQLCA.DBParm = "ConnectString='URI=http://esx2-appserver/TestDataService/Employee.svc'" //connect to the service connect using SQLCA; dw_1.SetTransObject(SQLCA) dw_1.Retrieve() ... //disconnect from the service disconnect using SQLCA; |
For more information on using the global Transaction object, see
the section called “Using Transaction Objects” in Application Techniques.