LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous (more recent) messageNext (less recent) messagePrevious (more recent) in topicNext (less recent) in topicPrevious (more recent) by same authorNext (less recent) by same authorPrevious page (June 2003, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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


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.

Back to: Top of message | Previous page | Main SAS-L page