Archives of the TeradataForum

Message Posted: Fri, 05 Nov 2004 @ 18:30:02 GMT

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

Parijat:

You are mixing two different environments. DBC.SysExecSQL is only available in a stored procedure. Although a stored procedure can be created and called from BTEQ, there is no direct connection to the DBC.SysExecSQL check routine within BTEQ.

If you are attempting to using BTEQ to generate SQL from a SELECT, you will need to export it onto the hard drive using a ".export data" and then a ".export reset". Once the file is created, you can then execute it from within the same BTEQ using a ".run file".

If you want to use DBC.SysExecSQL to pass an SQL statement or portion of one, you will need to write a stored procedure.

You can file examples and further information on both of these techniques in the Utilities or SQL reference manuals. Otherwise there are some good books on the subjects available as well.

Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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