Date:         Mon, 23 Jun 2003 11:11:27 -0700
Reply-To:     Prasad S Ravi <prasad.s.ravi@HOUSEHOLD.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Prasad S Ravi <prasad.s.ravi@HOUSEHOLD.COM>
Subject:      Re: Informix Connection problem
Comments: To: Bruce Johnson <bjohnson@SOLUCIENT.COM>
Content-type: text/plain; charset=us-ascii

Bruce:

Use PROC SQL connect to informix, here is sample code from SI.

Prasad Ravi
|--------------------------------------------------------------------------|
|                                                                          |
|   libname libref 'SAS-Data-Library';                                     |
|                                                                          |
|   options dbdebug;                                                       |
|   options linesize=250;                                                  |
|                                                                          |
|   proc sql;                                                              |
|          connect to informix ( database='xxxxxxxxxxx');                  |
|          create table libref.dataset as select var1, var2 from           |
|   connection to                                                          |
|   informix                                                               |
|            ( select bigcol[1,200], bigcol[201,249]  from mytable ) ;     |
|   disconnect from informix ;                                             |
|   quit;                                                                  |
|                                                                          |
|   proc fsview data=libref.dataset;                                       |
|   run;                                                                   |
|                                                                          |
|                                                                          |
|                                                                          |
|--------------------------------------------------------------------------|








                         Bruce Johnson
                         <bjohnson@SOLUCIENT.C  To:    SAS-L@LISTSERV.UGA.EDU
                         OM>                    cc:
                         Sent by: "SAS(r)       Subject: Informix Connection problem
                         Discussion"
                         <SAS-L@LISTSERV.UGA.E
                         DU>


                         06/23/2003 10:59 AM
                         Please respond to
                         Bruce Johnson






I am trying to connect to a informix database on a remote server, however,
SAS won't let me connect if I try:

libname db informix database=rihold@deneb_anet
<mailto:database=rihold@deneb_anet>

Is there another way to connect?


Bruce A Johnson
Senior Data Analyst
Solucient, LLC
(847) 440-9635




This message is a private communication. It may contain information that is
confidential and legally protected from disclosure. If you are not an
intended recipient, please do not read, copy or use this message or any
attachments, and do not disclose them to others.

Please notify the sender of the delivery error by replying to this message,
and then delete it and any attachments from your system. Thank you.
Solucient LLC.