Run SQL from Windows against AS/400

[new]

It seems the DB2 CLP (Command Line Processor) is the way to go (other
ideas???)

I downloaded and installed and configured and got the msg below.
However I do not understand it what gets licensed - on the AS400 or Windows?
My setup is at the bottom.

SQL8002N Connect processing failed; a valid product license was not
found.

SQLSTATE=42968

db2 =>

The final error message was looked up here:

http://publib.boulder.ibm.com/infoce...m0/sql8000.htm

Here is the error message text

SQL8002N
DRDA connect processing failed; a valid product license was not
found.
Explanation: A valid license key could not be found and the evaluation
period has expired.

User Response: Install a license key for the fully entitled version of
the product. You can obtain a license key for the product by contacting your
IBM representative or authorized dealer.

sqlcode: -8002

This is a link to where I downloaded the software from:

https://www6.software.ibm.com/dl/rtcl/rtcl-p

I then ran the setup and the post setup configuration as found here:

http://www-128.ibm.com/developerwork...301chong2.html

[m]

new wrote:

It seems the DB2 CLP (Command Line Processor) is the way to go (other
ideas???)

I downloaded and installed and configured and got the msg below.
However I do not understand it what gets licensed - on the AS400 or Windows?
My setup is at the bottom.

SQL8002N Connect processing failed; a valid product license was not
found.

SQLSTATE=42968

db2 =>

The final error message was looked up here:

http://publib.boulder.ibm.com/infoce...m0/sql8000.htm

Here is the error message text

SQL8002N
DRDA connect processing failed; a valid product license was not
found.
Explanation: A valid license key could not be found and the evaluation
period has expired.

User Response: Install a license key for the fully entitled version of
the product. You can obtain a license key for the product by contacting your
IBM representative or authorized dealer.

sqlcode: -8002

This is a link to where I downloaded the software from:

https://www6.software.ibm.com/dl/rtcl/rtcl-p

I then ran the setup and the post setup configuration as found here:

http://www-128.ibm.com/developerwork...301chong2.html

To connect to a HOST system (z/OS or AS/400) you need DB2 Connect. The
plain ol' windows client (ODBC) won't work.

[new]

If I have iSeries Navigator installed on the same machine would that mean I
have DB2 Connect installed?


"m" <md*******@yahoo.com> wrote in message
news:ce***************************@ALLTEL.NET...

new wrote:

It seems the DB2 CLP (Command Line Processor) is the way to go
(other ideas???)

I downloaded and installed and configured and got the msg below.
However I do not understand it what gets licensed - on the AS400 or
Windows?
My setup is at the bottom.

SQL8002N Connect processing failed; a valid product license was
not found.

SQLSTATE=42968

db2 =>

The final error message was looked up here:


http://publib.boulder.ibm.com/infoce...m0/sql8000.htm

Here is the error message text

SQL8002N
DRDA connect processing failed; a valid product license was not
found.
Explanation: A valid license key could not be found and the
evaluation period has expired.

User Response: Install a license key for the fully entitled version
of the product. You can obtain a license key for the product by
contacting your IBM representative or authorized dealer.

sqlcode: -8002

This is a link to where I downloaded the software from:

https://www6.software.ibm.com/dl/rtcl/rtcl-p

I then ran the setup and the post setup configuration as found
here:


http://www-128.ibm.com/developerwork...301chong2.html

To connect to a HOST system (z/OS or AS/400) you need DB2 Connect. The
plain ol' windows client (ODBC) won't work.

[Kent Milligan]

NO, iSeries Navigator uses the iSeries Access ODBC & JDBC drivers. Maybe, you
should just use the Run SQL Scripts interface in iSeries Navigator.

new wrote:

If I have iSeries Navigator installed on the same machine would that mean I
have DB2 Connect installed?


"m" <md*******@yahoo.com> wrote in message
news:ce***************************@ALLTEL.NET...

new wrote:

It seems the DB2 CLP (Command Line Processor) is the way to go
(other ideas???)

I downloaded and installed and configured and got the msg below.
However I do not understand it what gets licensed - on the AS400 or
Windows?
My setup is at the bottom.

SQL8002N Connect processing failed; a valid product license was
not found.

SQLSTATE=42968

db2 =>

The final error message was looked up here:


http://publib.boulder.ibm.com/infoce...m0/sql8000.htm

Here is the error message text

SQL8002N
DRDA connect processing failed; a valid product license was not
found.
Explanation: A valid license key could not be found and the
evaluation period has expired.

User Response: Install a license key for the fully entitled version
of the product. You can obtain a license key for the product by
contacting your IBM representative or authorized dealer.

sqlcode: -8002

This is a link to where I downloaded the software from:

https://www6.software.ibm.com/dl/rtcl/rtcl-p

I then ran the setup and the post setup configuration as found
here:


http://www-128.ibm.com/developerwork...301chong2.html

To connect to a HOST system (z/OS or AS/400) you need DB2 Connect. The
plain ol' windows client (ODBC) won't work.

--
Kent Milligan
ISV Enablement - System i
km***@us.eye-bee-m.com (spam trick) GO HAWKEYES!!

ibm.com/iseires/db2

(opinions stated are not necessarily those of my employer)