devxlogo

Accessing Multiple Databases from a Datawindow

Accessing Multiple Databases from a Datawindow

Question:
Using a single datawindow, can I access data from multiple databases (Oracle and Sybase)? If not, can I use PowerBuilder to access it without having any intermediate table?

Answer:
The only way you could achieve this is by using nested or dropdown datawindows. Because you can issue a GetChild against the child datawindows, you could set the transaction object of a different one to the primary datawindow and thus retrieve data from multiple databases.

devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist