Date: Thu, 19 Oct 2006 05:11:44 -0700
Reply-To: pravin <pravin.viroje@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: pravin <pravin.viroje@GMAIL.COM>
Subject: Re: Truncate Table Error
Content-Type: text/plain; charset="iso-8859-1"
I create Oracle Library, give the Schema Name (Database) as Test_BI.
My source table test1 and target table is Test2 (Both are in Oracle).
I want to populate the data from Test1 to Test2, so i create the Job.
In job i mention Load Technique as Refresh - > Truncate.
when i run the job it gives a error. As it create the Truncate
statement as follows
truncate table "Test_BI".Test2
Thanks & Regards
"Gerstle, John CDC/CCID/NCHHSTPCTR wrote:
> First off, next time you have a ETL/DI question, could you make a more
> descriptive Subject line so it's easier to find? I didn't change this
> one, but it could be on the order of: "SAS ETL Job Truncate Table Error"
> or something like that... Having only "SAS ETL Job" doesn't give enough
> information, so when you search the archives for Truncate Table Error,
> you may not find your question. Just FYI...
> Second, I'm going to guess as I'm not able to replicate what you're
> doing. I'm thinking that the problem is not the Load Technique, per se,
> but a naming problem of the Target dataset. Did you look over the Target
> metadata to see if there's a naming error? Are you database and table
> names actually SchemaName and tablename??
> That's my guess...
> John Gerstle, MS
> Northrop Grumman
> CDC Information Technological Support Contract (CITS)
> NCHSTP \DHAP \HICSB \Research, Analysis, and Evaluation Section
> Centers for Disease Control and Prevention
> "Boss. We've got cats." "Meow"
> "All truth passes through three stages:
> First, it is ridiculed;
> Second, it is violently opposed;
> Third, it is accepted as being self-evident."
> - Arthur Schopenhauer (1830)
> >>-----Original Message-----
> >>From: email@example.com
> >>On Behalf Of pravin
> >>Sent: Wednesday, October 18, 2006 6:20 AM
> >>To: firstname.lastname@example.org
> >>Subject: SAS ETL Job
> >>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.