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:
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...
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...