Re: Accessing a PC based DB2 server -- PCTECH

Subject: Re: Accessing a PC based DB2 server
From: Rob Berendt <rob@xxxxxxxxx>
Date: Wed, 18 Dec 2019 14:39:46 +0000
List-archive: <https://archive.midrange.com/pctech/>
List-help: <mailto:pctech-request@lists.midrange.com?subject=help>
List-id: "PC Technical Discussion for IBM i \(AS/400 and iSeries\) Users" <pctech.lists.midrange.com>
List-post: <mailto:pctech@lists.midrange.com>
List-subscribe: <https://lists.midrange.com/mailman/listinfo/pctech>, <mailto:pctech-request@lists.midrange.com?subject=subscribe>
List-unsubscribe: <https://lists.midrange.com/mailman/options/pctech>, <mailto:pctech-request@lists.midrange.com?subject=unsubscribe>

I might have to figure out how to get this on my workstation.
For now I am trying it on the Windows server.
db2 => select * from sqlcolumns
SQL1024N A database connection does not exist. SQLSTATE=08003
db2 => connect to gddb2
SQL1013N The database alias name or database name "GDDB2" could not be found.
SQLSTATE=42705

Ok, so the database name is not the same as the server. What is the way to look that up? I'm betting it's not WRKRDBDIRE.

Rob Berendt

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: Accessing a PC based DB2 server , Rob Berendt

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.