Date:         Fri, 17 Oct 2003 15:51:19 +0200
Reply-To:     "Besnier, Gwenael IMP-DE" <Gwenael.Besnier@MEISTERVERLAG.DE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Besnier, Gwenael IMP-DE" <Gwenael.Besnier@MEISTERVERLAG.DE>
Subject:      connection to BD2
Content-Type: text/plain; charset="iso-8859-1"

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