Single slot in throttle for multiple requests

Database

Single slot in throttle for multiple requests

Scenario:

I have 10 Insert statements. These are treated seperately in TASM throttle, one executes and the next one waits for its turn the delay queue.

What I want is to treat all these 10 statements as a single unit for throttles. It could be possible if there was feature of MULTI-row insert in teradata but unfortunetly its not there.

Can BTET or Multistatement request help here?

Asim

2 REPLIES
Senior Apprentice

Re: Single slot in throttle for multiple requests

Hi Asim,

the parser and so TASM work on a REQUEST level, so the only way to get all ten Inserts in a single unit of work in TASM is a Multi Statement Request.

Re: Single slot in throttle for multiple requests

So Multi Statement Request will do the trick.

Thanks Dieter