Archives of the TeradataForum

Message Posted: Tue, 08 Apr 2003 @ 18:02:02 GMT

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

Apparently you are running this in SAS with PROC SQL. This statement:

create table work.tamkts as select * from tamkts.taods;

is a pure SAS statement; it is creating a SAS data set called "tamkts" in the library "work".

The inner select in the other statement is being sent to Teradata. Teradata knows nothing about the SAS library "work", and in fact "work" is a reserved word in Teradata, so it can't be used as a database name. Hence, the error.

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