Mailing-List:	contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Subscribe:	<mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive:	<http://sources.redhat.com/ml/cygwin/>
List-Post:	<mailto:cygwin AT cygwin DOT com>
List-Help:	<mailto:cygwin-help AT cygwin DOT com>, <http://sources.redhat.com/ml/#faqs>
Sender:	cygwin-owner AT cygwin DOT com
Mail-Followup-To:	cygwin AT cygwin DOT com
Delivered-To:	mailing list cygwin AT cygwin DOT com
X-Injected-Via-Gmane:	http://gmane.org/
To:	cygwin AT cygwin DOT com
From:	"Hans Horn" <hannes AT 2horns DOT com>
Subject:	Re: HELP Accessing DB2 from CYGWIN!
Date:	Mon, 10 Feb 2003 06:51:56 -0800
Lines:	26
Message-ID:	<b28e4u$lag$1@main.gmane.org>
References:	<8029130FC3FEDF43AC1224C66E1B807E074ED3 AT PUNW2KEXG03 DOT pun DOT s1 DOT com>
X-Complaints-To:	usenet AT main DOT gmane DOT org
X-MSMail-Priority:	Normal
X-Newsreader:	Microsoft Outlook Express 6.00.2800.1123
X-MimeOLE:	Produced By Microsoft MimeOLE V6.00.2800.1123

Ramana,

To access DB2 under cygwin you need value of variable DB2CLP (db2
commandline processor).
How you get/set that?
Easy:
  - launch 'db2cmd' from run menu (which opens a DOS-like command window),
or issue C:\Program Files\SQLLIB\bin\db2cmd from a DOS window
  - in command window issue: echo %DB2CLP%
  - note that this temporary env variable changes whenever a new db2cmd
command is issued.
  - create new SYSTEM environment variable with same name & value (My
Computer - Properties - Advanced - Environment Variables...)

add to PATH variable (if it's not already there): e.g.
C:\Progra~1\SQLLIB\BIN (for UDB v7x)

Now you can access db2 seamlessly from within cygwin, just like on unixes
(such as AIX).

Hans

p.s. what I have described above works under Win2k (UDB v7.x) and WinXP (UBD
v8x); I'm not sure about Win9x/ME vintages




--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

- Raw text -