Create a procedure that will return a table of booked engagements for a given entertainer

25 pts.
Tags:
AS/400
How can I create a procedure that will return a table of booked engagements for a given entertainer. The procedure accepts the name or ID of the entertainer as input. The output table has the name and ID of the entertainer, the entertainment type, and the begin and end-date of the engagement. Call the procedure with a variety of values to demonstrate that your procedure works. Call the procedure a minimum of 3 times.
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Sounds like a class assignment. We are willing to help but won’t write the code for you. Show us what you have written and any errors you are getting and we will help you fix your problem.

By posting your code we will also know what language you are looking for as it could be any number of of them. We also need to know the database/file names as well as variables/field names.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • dawalama
    I think I got it.
    25 pointsBadges:
    report
  • dawalama
    so far I got these my question is  help me if I am doing correct
    use EntertainmentAgencyExample;
      
    select  EngagementNumber, StartDate, EndDate, Customers.CustCity, Customers.CustState, Entertainers.EntStageName, Entertainer_Styles.StyleStrength
    from Engagements 
    inner join Entertainers on Engagements.EntertainerID = Entertainers.EntertainerID 
    inner join Customers on Customers.CustomerID = Engagements.CustomerID
    inner join Entertainer_Styles on Engagements.EntertainerID = Entertainer_Styles.EntertainerID
    order by EntStageName, StartDate, EndDate;
    25 pointsBadges:
    report
  • Jaideep Khanduja
    That required a simple query.
    19,350 pointsBadges:
    report
  • deepu9321
    Query looks Okay, Have you reviewed the results? 
    4,980 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: