Can you please explain to me what is happening in the line Update PRODUCT 11QER/31, P_QTYOH from...

60.1K

Verified Solution

Question

General Management

Can you please explain to me what is happening in theline

Update PRODUCT 11QER/31, P_QTYOH from 47 to46

like why 47 to 46 and no other number?

in the code

Lock INVOICE

Insert row 10983 into INVOICE

Unlock INVOICE

Lock LINE

Insert row 10983, 1 into LINE

Unlock LINE

Lock PRODUCT

Update PRODUCT 11QER/31, P_QTYOH from47 to 46

Unlock PRODUCT

Lock CUSTOMER

Update CUSTOMER 10010, CUS_BALANCEfrom 345.67 TO 464.47

Update CUSTOMER 10010, CUS_DATELSTPURfrom 11-May-2016 to 03-June-2016

Unlock CUSTOMER

Answer & Explanation Solved by verified expert
3.8 Ratings (318 Votes)
Lock INVOICE This is used to lock the table INVOICE Insert row 10983 into INVOICE Here this command is used to insert the row10983 into the table INVOICE Unlock INVOICE This command is used toUnlock the    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students