Mikito Harakiri wrote:
> Robert Martin wrote:
>
>>Could you show me how you would construct a credit request packet from
>>a customer record and send it to the credit service, and then process
>>the response? Just for the sake of argument we'll keep the packet
>>simple. The request packet is just a simple SSN encoded in BCD in five
>>bytes. The response is two bytes that contain a binary number whose
>>value ranges from 0-999. You send the request to port 884 of
>>124.132.4.23, and it will reply within 2 seconds. If it doesn't reply
>>within 2 seconds you need to retry. After the third attempt, you need
>>to declare an error in the current transaction and create a log file
>>entry. Given a valid reply, you set a flag in the customer record to
>>ACCEPTED if the returned value is > 500, otherwise you set the flat to
>>REJECTED.
It looks like the self-aggrandizing ignorant directed the question to
me. I added him to my twit-filter ages ago. The solution offered by
Mikito is not what I would suggest and doesn't reflect the post to which
Martin replied.
Assuming:
1. The SSN is in ssn_var.
2. The customer relvar has a candidate key ssn.
3. The request relvar physically maps to a channel to 124.132.4.23:884
I might propose:
Repeat up to 3 times
insert into request tuple( ssn_var ),
wait seconds(2)
until ( result = unwrap ( response )){}
else log_and_abort("The error details");
update customer
set flag = case when result > 500 then ACCEPTED else REJECTED end case
where ssn = ssn_var;
Received on Fri Jun 02 2006 - 19:02:12 CDT
