DB2 Client v8 access DB2 v7

Frederic Mockel

Hi,

we try to access DB2 v7 on z/OS with a client v8 and we got the error
SQL0440N. It seems the correct reaction cause there is no function named
SQLTables. But when we connect with the v8-client to an v7-Unix-Database it
works and in the database there is also no function called SQLTables.

Why i got two different reaction ?

A link to a doc and i will say thank you

Freddy

Nov 12 '05 #1

Subscribe Post Reply

3505

PM \(pm3iinc-nospam\)

On unix, windows, linux, they are installed by default. (db2chema.bnd)
On ZOS, ... you need some

http://publib.boulder.ibm.com/infoce...help/index.jsp
search for ptf
then select

Database Metadata Catalog Query Enablement on DB2 for OS/390 and z/OS When
Using the Universal JDBC Driver
For Version 6: UQ72081 and UQ72082
For Version 7: UQ72083 1

Prerequisites for DB2 Universal Database Version 8 clients connecting to
host databases
APAR PQ62695

Alternatively, you can search the db2 v7 books here
http://www-3.ibm.com/software/data/d...0/v7books.html
PM

"Frederic Mockel" <fr*************@gillardon.de> a écrit dans le message de
news:3f*********************@businessnews.de.uu.ne t...

Hi,

we try to access DB2 v7 on z/OS with a client v8 and we got the error
SQL0440N. It seems the correct reaction cause there is no function named
SQLTables. But when we connect with the v8-client to an v7-Unix-Database it works and in the database there is also no function called SQLTables.

Why i got two different reaction ?

A link to a doc and i will say thank you

Freddy

Nov 12 '05 #2

Mauro Cazzari

Also, make sure to install Fixpak 3 on your client, otherwise you may still
experience some problems with the stored procedure builder.

"PM (pm3iinc-nospam)" <PM(pm3iinc-nospam)@sympatico.ca> wrote in message
news:PI*****************@news20.bellglobal.com...

On unix, windows, linux, they are installed by default. (db2chema.bnd)
On ZOS, ... you need some

http://publib.boulder.ibm.com/infoce...help/index.jsp
search for ptf
then select

Database Metadata Catalog Query Enablement on DB2 for OS/390 and z/OS When
Using the Universal JDBC Driver
For Version 6: UQ72081 and UQ72082
For Version 7: UQ72083 1

Prerequisites for DB2 Universal Database Version 8 clients connecting to
host databases
APAR PQ62695

Alternatively, you can search the db2 v7 books here
http://www-3.ibm.com/software/data/d...0/v7books.html
PM

"Frederic Mockel" <fr*************@gillardon.de> a écrit dans le message de news:3f*********************@businessnews.de.uu.ne t...
Hi,

we try to access DB2 v7 on z/OS with a client v8 and we got the error
SQL0440N. It seems the correct reaction cause there is no function named
SQLTables. But when we connect with the v8-client to an v7-Unix-Database

it
works and in the database there is also no function called SQLTables.

Why i got two different reaction ?

A link to a doc and i will say thank you

Freddy

Nov 12 '05 #3

by: bill | last post by:

I am trying to convince a client that dotNet is preferable to an Access project (ADP/ADE). This client currently has a large, pure Access MDB solution with 30+ users, which needs to be upgraded....

.NET Framework

'Pure' client-side javscript database?

by: cjl | last post by:

Hey all: I know that it is silly in the age of Google to 'lose' something on the internet, but I recently checked out a project that had implemented a database with a subset of SQL in pure...

Javascript

Questions re WITH RETURN TO CLIENT

by: Rhino | last post by:

I am trying to verify that I correctly understand something I saw in the DB2 Information Center. I am running DB2 Personal Edition V8.2.1 on Windows. I came across the following in the Info...

DB2 Database

RADiest Client for SQL Server

by: Mike MacSween | last post by:

I've got a SQL Server database. Nearly finished. It's going to go on a single non networked machine. One day somebody might get access to it over ADSL (probably TS), but for now it's a single user...

Microsoft Access / VBA

Client causing remotable application to freeze

by: Timothy Shih | last post by:

Hi, I am having a freezing issue with my application. My application serves several remotable objects, all of which must be initialized before their use. Furthermore, some of them depend on each...

C# / C Sharp

Smart client - general data access best practice question

by: Marc Gravell | last post by:

Kind of an open question on best-practice for smart-client design. I'd really appreciate anyones views (preferably with reasoning, but I'll take what I get...). Or if anybody has any useful links...

C# / C Sharp

question refined - Copy file from client to server

by: CGW | last post by:

I asked the question yesterday, but know better how to ask it, today: I'm trying to use the File.Copy method to copy a file from a client to server (.Net web app under IIS ). It looks to me that...

.NET Framework

Is There a Client/Server Version of Access ?

by: B1ackwater | last post by:

We've fooled around with Access a bit, but only using the single-user store-bought version. It seems to be a good database - versatile and infinitely programmable - and can apparently be used as a...

Microsoft Access / VBA

.NET Windows Forms Application VS MS Access client Application

by: Jordan S. | last post by:

SQL Server will be used as the back-end database to a non trivial client application. In question is the choice of client application: I need to be able to speak intelligently about when one...

.NET Framework

Initial Client Delay with DHCP

by: WhatHappend | last post by:

I have converted a .Net 1.0 application to .Net 2.0 and the web service invocations have delay of around 10seconds on each intial access. After the first access subsequent access are fast (After a...

.NET Framework

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

DB2 Client v8 access DB2 v7

Similar topics