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>
Organization: http://groups.google.com
Subject:      Re: Truncate Table Error
Comments: To: sas-l@uga.edu
In-Reply-To:  <148E8334465C024399DD7B14E61D7D1516457B4D@m-nchstp-2.nchstp.cdc.gov>
Content-Type: text/plain; charset="iso-8859-1"

John,

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
Pravin Viroje



"Gerstle, John CDC/CCID/NCHHSTPCTR wrote:

> Pravin,
> 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
> Biostatistician
> 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: owner-sas-l@listserv.uga.edu
> [mailto:owner-sas-l@listserv.uga.edu]
> >>On Behalf Of pravin
> >>Sent: Wednesday, October 18, 2006 6:20 AM
> >>To: sas-l@uga.edu
> >>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.