Date: Fri, 17 Oct 2003 11:07:17 -0400
Reply-To: Sigurd Hermansen <HERMANS1@WESTAT.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Sigurd Hermansen <HERMANS1@WESTAT.COM>
Subject: Re: connection to BD2
Content-Type: text/plain; charset="iso-8859-1"
Gwenael:
I would expect to see LIBNAME mydb DB2 followed by a connection string prior
to the SQL query. With SAS/ACCESS the LIBNAME statement opens a connection
to the DB2 database system using the SAS/ACCESS DB2 'driver'. You have
either omitted the critical part of the SAS program that opens the
connection to DB2, or an attempt to open the connection failed, or someone
has closed the connection. Check what you might have in the SAS log prior to
the segment of the log that you included in your message.
Sig
-----Original Message-----
From: Besnier, Gwenael IMP-DE [mailto:Gwenael.Besnier@MEISTERVERLAG.DE]
Sent: Friday, October 17, 2003 9:51 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: connection to BD2
Dear all,
I'm using SAS V8.2 with ACCESS to DB2.
Sometimes the extract from the database is working well but sometimes I get
the following error message:
111 proc sql ;
112 create table tmp.sel_cooking as
113 select
114 o.CUSTOMER_ACCOUNT_NUM,...
117 from mydb.TABLE1 c, mybd.TABLE2 o
118 where c.CONTACT_WID=o.CONTACT_WID ...;
ERROR: CLI prepare error: [IBM][CLI Driver] CLI0106E Connection is closed.
SQLSTATE=08003 SQL statement: SELECT * FROM mydb.TABLE1 FOR READ ONLY .
ERROR: CLI prepare error: [IBM][CLI Driver] CLI0106E Connection is closed.
SQLSTATE=08003 SQL statement: SELECT * FROM mydb.TABLE2 FOR READ ONLY . 126
quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used:
real time 0.01 seconds
cpu time 0.01 seconds
Does someone know where is this error coming from?
Hope for help
Mit freundlichen Grüßen / Best regards
Gwenael Besnier
Database Analyst
D-80807 Munich
