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/