Date: Wed, 8 Sep 2010 22:58:23 -0400
Reply-To: Arthur Tabachneck <art297@NETSCAPE.NET>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Arthur Tabachneck <art297@NETSCAPE.NET>
Subject: Re: CLI Fetch error Invalid datetime format
Gima,
You didn't indicate which operating system you were on. You might find
the direction you need by doing the following Google search:
http://www.google.ca/search?
hl=en&rlz=1R2SKPB_enCA369&as_q=odbc+CLI+cursor+extended+fetch+error+oracle+
datetime&as_epq=&as_oq=&as_eq=&num=10&lr=&as_filetype=&ft=i&as_sitesearch=s
upport.sas.com&as_qdr=all&as_rights=&as_occt=any&cr=&as_nlo=&as_nhi=&safe=i
mages
or, in short form: http://xrl.us/bhym6u
HTH,
Art
---------
On Wed, 8 Sep 2010 20:50:05 -0400, Barkanic, Gema 1915
<Gema.Barkanic@CIGNA.COM> wrote:
>I'm getting a CLI Fetch error whhile reading in an ODBC file. Is there a
way to override this so I can at least read the data in. I know the
problem is with a certain variable. Thanks, Gema
>
>This is the actual error I'm getting:
>
>
>
>ERROR: CLI cursor extended fetch error: [Oracle][ODBC]Invalid datetime
format.
>NOTE: The data step has been abnormally terminated.
>NOTE: Missing values were generated as a result of performing an
operation on missing values.
> Each place is given by: (Number of times) at (Line):(Column).
> 495288 at 17:11 3 at 18:13
>NOTE: The SAS System stopped processing this step because of errors.
>NOTE: There were 2373000 observations read from the data set
PROD.MEMBDGIS.
>WARNING: The data set MAIN.MEMBERLEVEL may be incomplete. When this step
was stopped there
> were 9160 observations and 49 variables.
>NOTE: Compressing data set MAIN.MEMBERLEVEL decreased size by 99.05
percent.
> Compressed is 87 pages; un-compressed would require 9160 pages.
>WARNING: Data set MAIN.MEMBERLEVEL was not replaced because this step was
stopped.
>NOTE: DATA statement used (Total process time):
> real time 10:33.34
>2 The SAS System 17:52
Tuesday, September 7, 2010
>
> cpu time 1:54.86
>
>
>
>Gema Barkanic
>Health Data Specialist
>412-747-7537
>412- 473- 7694 (home office M and F)
>gema.barkanic@cigna.com
>
>aConfidential, unpublished property of CIGNA. Do not duplicate or
distribute. Use and distribution limited solely to authorized personnel.
(c) Copyright 2010 CIGNA
>
>
>--------------------------------------------------------------------------
----
>CONFIDENTIALITY NOTICE: If you have received this email in error, please
immediately notify the sender by e-mail at the address shown. This email
transmission may contain confidential information. This information is
intended only for the use of the individual(s) or entity to whom it is
intended even if addressed incorrectly. Please delete it from your files
if you are not the intended recipient. Thank you for your compliance.
Copyright 2010 CIGNA
>
==========================================================================
==
| 
