Archives of the TeradataForum

Message Posted: Thu, 21 May 2009 @ 21:56:12 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Given these constraints and the rules that apply to transactions and Data Definition statements I can not imagine how you can do what you want in a single request.

Since you are doing this in Java, why not just make two requests? One request to create the VT followed by one to exec the macro.

Granted there are some additional differences between VT and GT, but is the fact that space in GT tables is accounted for in temp a show stopper?

I don't know how complex your macro is, or how you use the volatile table, but you might also consider a derived table.

Glenn Mc

	<Prev	Next>		<<First	<Prev	Next>	Last>>