[Stackoverflow] [Progress OpenEdge ABL] Connecting to Multiple Progress Database using single .p file

Status
Not open for further replies.
V

Varun Sulabha

Guest
Is there a way to connect to multiple progress database. In current situation what we do is we use multiple .p files to fetch the data. Example: 1st program will fetch the data from customer database and using a run command we use to connect to 2nd database. 2nd program we use input parameter to map the value.

My question is, is there a way we can do this in one single program? Below is the sample program:

Code:
/*FIRST Program***/

FIND FIRST customer WHERE customer.cust-id EQ "v456" NO-LOCK NO-ERROR. IF AVAILABLE customer THEN RUN /HOME/dbconnect.p(INPUT customer.cust-id, "ACCOUNTS"). RUN /HOME/program-2.p (INPUT customer.cust-id).

/Second Program**/ DEFINE INPUT PARAMETER ipcCust-id AS CHARACTER.

FOR EACH billing WHERE billing.cust-id EQ ipcCust-id NO-LOCK: DISPLAY billing.DATE. END.

Continue reading...
 
Status
Not open for further replies.
Top