Date:         Wed, 18 Oct 2006 03:20:19 -0700
Reply-To:     pravin <pravin.viroje@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         pravin <pravin.viroje@GMAIL.COM>
Organization: http://groups.google.com
Subject:      SAS ETL Job
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset="iso-8859-1"

i am getting error while truncating the table through ETL Job. I
created a job using SAS DI Studio and use Load Technique as
Refresh->Truncate. But while generating sas code for the same it use
the truncate table statement as follows :

 truncate table "SchemaName".tablename

the problem is because of quoates used to enclosed to SchemaName.