Archives of the TeradataForum

Message Posted: Wed, 03 Dec 2003 @ 12:52:44 GMT

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

Hi Rachana,

Thanks for reply,would pls send sample script based on this functionality,Bcoz i am not sure abt the error whether it is regarding to the previleges or some other.I gone through doumentation mentioned some limitations on using the DBC.SysExecSql() those Operations are

* ALTER PROCEDURE
* CALL
* CREATE PROCEDURE
* DATABASE
* EXPLAIN
* HELP (all forms)
* REPLACE PROCEDURE
* SELECT
* SELECT - INTO
* SET ROLE
* SET SESSION ACCOUNT
* SET SESSION COLLATION
* SET SESSION DATEFORM
* SET TIME ZONE
* SHOW
* Cursor statements (OPEN, FETCH, CLOSE).

Thnaks

Raju

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