I want to ask if there is a person, can show me in progress using sample procedure, that will service two relational database in one .p file. An example will be appreciated thanks.
So long as the two databases don't share table names Progress is able to discern which database you're using so just go on as you are. If the databases share table names you will need to qualify them with the database name.
Code:
for each database1.table1 no-lock:
end.
for each database2.table1 no-lock:
end.
Other than that you don't need to do anything special.
Your example above shows...? Relational types to each schema name with its table fields? If so how do i create a procedure that will invoke both tables and shemas on my procedure? In another words i want to understand flow process
One of our applications is deployed with anywhere from one to four databases, depending on which options a client buys. Our table names are unique across all databases, so developers don't have to do anything special to reference them, e.g. qualifying table names with DB names.
E.g.:
Code:
for each TableInDB1 no-lock:
find TableInDB2 no-lock where condition...
end.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.