MultiStatement - RS Tables

General
Enthusiast

MultiStatement - RS Tables

Hi! 

 

When executing a multistatement, I believe _RS tables are created during its execution. Is it possible to define not to create them?

 

I'm asking that because I'm doing a lot of multistatements in the same table and as soon it is creating its _RS table concurrently, teradata displays an error: 

 

Teradata connection: Table 'TABLETEST_RS' already exists. 

Is there any possible solution to this error? It's not an option to use an intermediate table. 

 

Thanks,

1 REPLY
Highlighted
Junior Contributor

Re: MultiStatement - RS Tables

A MultiStatement Request in Teradata doesn't create any kind of table.

What's the client you use for submitting SQL and what exactly are you doing?