Progress OpenEdge
Member
Qn 27 and 28 are skipped.
Qn 29: What messages are shown after running the following code (in both cases!) ?
a.
PROCEDURE p1:
MESSAGE 1 AVAILABLE(customer).
END PROCEDURE.
PROCEDURE p2:
DEFINE BUFFER customer FOR customer.
MESSAGE 2 AVAILABLE(customer).
END procedure.
FIND FIRST customer NO-LOCK NO-ERROR.
RUN p1.
RUN p2.
b.
PROCEDURE p1:
FIND FIRST customer EXCLUSIVE-LOCK NO-ERROR.
MESSAGE 1 TRANSACTION.
RUN p2.
END PROCEDURE.
PROCEDURE p2:
MESSAGE 2 TRANSACTION.
END PROCEDURE.
RUN p1.
Ans:
a. 1 and yes or no depending on if customer record is available. 2 and yes or no again.
b.
1 TRANSACTION
2 TRANSACTION
Qn 29: What messages are shown after running the following code (in both cases!) ?
a.
PROCEDURE p1:
MESSAGE 1 AVAILABLE(customer).
END PROCEDURE.
PROCEDURE p2:
DEFINE BUFFER customer FOR customer.
MESSAGE 2 AVAILABLE(customer).
END procedure.
FIND FIRST customer NO-LOCK NO-ERROR.
RUN p1.
RUN p2.
b.
PROCEDURE p1:
FIND FIRST customer EXCLUSIVE-LOCK NO-ERROR.
MESSAGE 1 TRANSACTION.
RUN p2.
END PROCEDURE.
PROCEDURE p2:
MESSAGE 2 TRANSACTION.
END PROCEDURE.
RUN p1.
Ans:
a. 1 and yes or no depending on if customer record is available. 2 and yes or no again.
b.
1 TRANSACTION
2 TRANSACTION