Archives of the TeradataForum

Message Posted: Wed, 03 Dec 2003 @ 10:42:58 GMT

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

Hi Raju,

1) To execute dynamic query you can use dbc.sysexecsql SP.

2) It takes one parameter and that is the dynamic query .

3) But to execute it the procedure that is going to call sysexecsql , the procedure should be under the user creating it. It cannot belong to another database.

4) The rights to execute procedure has to be given at object (procedure) level.

5) The output of the select query can be stored in a temporary table. which can be accessed later to get the value.

The dynamic query should be something like this " Insert into temp table "

The structure of temp table can be made same as that of output of select.

Hope this helps...

Rachana

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