Date: Wed, 18 Oct 2006 09:50:43 -0400
Reply-To: "Gerstle, John (CDC/CCID/NCHHSTP) (CTR)" <yzg9@CDC.GOV>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Gerstle, John (CDC/CCID/NCHHSTP) (CTR)" <yzg9@CDC.GOV>
Subject: Re: SAS ETL Job
Content-Type: text/plain; charset="us-ascii"
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
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)
>>On Behalf Of pravin
>>Sent: Wednesday, October 18, 2006 6:20 AM
>>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.