Advanced Queuing   «Prev  Next»

Using Advanced Queuing

Here are the steps you should have followed:
  1. You began by initializing the queues that you will use in this application. This initialization created the object type for the message that was to be translated, the queue table to hold the messages, and the queue itself. After creating these entities, the macro started the queue.
  2. You enqueued an object into the queue.
  3. You checked the queue by SELECTing from the queue table that holds the messages.
  4. You queued two more messages and checked the queue.
  5. You dequeued a message from the queue and checked the queue.
  6. Finally, you cleaned up the queue by stopping the queue and dropping the queue table.

On your own

If you want to re-create this exercise in your own environment, there are three files to download for this exercise:
  1. START.SQL, which is a script file that creates the queue you will be using
  2. STOP.SQL, which is a script file that removes the queue you will use from your environment
  3. AQPROCS.SQL, which is a script file that will create the stored procedures you will use in the exercise