I was wondering if anybody has or knows where I can find an example of a stored procedure that writes from a queue table in TD to an external queue (say activeMQ) via a stored procedure (JDBC connection). Anything would be helpful!
Maybe this can help you:
Kudos to Dieter's stored proc for stats, using queue table. Good reference for push..pop:
For peek it is simple select.
Also like in oracle you can use select ....into ...a variable for processing for pop.
You can use a temp table to populate from a queue table: