question about versions

[Tom]

We have an AS/400 running DB2 v5r2m0. I want to get a copy of DB2 for
my desktop, primarily to create queries that I will "pass-thru" to the
400 using MSAccess. I believe the current version of DB2 is 8.1.
Will I have any problem with 8.1 talking to an older v5?

I ask because as I was working on getting MS Access to talk to our db
on the 400, I seem to remember an error message about the current
version can only talk to an older version that is no more than two
versions old. I'm getting quotes back that list both 8.1 and 6.1.
And, obviously, I don't want to get the "wrong" one.

Any help is appreciated.

Thanks in advance,

Tom

[Larry]

You don't need DB2, you need DB2 Connect if you want to "pass queries
through" to DB2/400. And if you use DB2 Connect V8, I don't see any
reason why you couldn't connect to V5R2 on 400, but you should check the
DB2 Connect doc just to be sure.

Larry Edelstein

Tom wrote:

We have an AS/400 running DB2 v5r2m0. I want to get a copy of DB2 for
my desktop, primarily to create queries that I will "pass-thru" to the
400 using MSAccess. I believe the current version of DB2 is 8.1.
Will I have any problem with 8.1 talking to an older v5?

I ask because as I was working on getting MS Access to talk to our db
on the 400, I seem to remember an error message about the current
version can only talk to an older version that is no more than two
versions old. I'm getting quotes back that list both 8.1 and 6.1.
And, obviously, I don't want to get the "wrong" one.

Any help is appreciated.

Thanks in advance,

Tom

[Larry]

You don't need DB2, you need DB2 Connect if you want to "pass queries
through" to DB2/400. And if you use DB2 Connect V8, I don't see any
reason why you couldn't connect to V5R2 on 400, but you should check the
DB2 Connect doc just to be sure.

Larry Edelstein

Tom wrote:

We have an AS/400 running DB2 v5r2m0. I want to get a copy of DB2 for
my desktop, primarily to create queries that I will "pass-thru" to the
400 using MSAccess. I believe the current version of DB2 is 8.1.
Will I have any problem with 8.1 talking to an older v5?

I ask because as I was working on getting MS Access to talk to our db
on the 400, I seem to remember an error message about the current
version can only talk to an older version that is no more than two
versions old. I'm getting quotes back that list both 8.1 and 6.1.
And, obviously, I don't want to get the "wrong" one.

Any help is appreciated.

Thanks in advance,

Tom

[Franco Lombardo]

> We have an AS/400 running DB2 v5r2m0. I want to get a copy of DB2 for

my desktop, primarily to create queries that I will "pass-thru" to the
400 using MSAccess. I believe the current version of DB2 is 8.1.
Will I have any problem with 8.1 talking to an older v5?
Maybe there is a misunderstanding: the version number of
DB2/400 and DB2 UDB are not the same. (I think that the DB is not the same
at all :-).

V5R2M0 is the most recent version of DB2400 (better, OS400), while
8.1 is the most recent version of DB2 UDB.

I ask because as I was working on getting MS Access to talk to our db
on the 400

In order to do this, the best way is to use the ODBC driver shipped whith
i-Series Access (former known as Client Access).

Bye

Franco

[Tom]

Thanks.

I know to "pass thru" a query I only need DB2 Connect. But I've read,
in multiple responses, that processing a DB2 query on the 400 is much
better than letting Access process the request. So I'm ASSUMING that
I need a copy of DB2 on MY PC, so I can develop the query which I will
eventually "pass thru".

On the typical client (user's) PC, I would only install DB2 Connect,
once I have developed my app, and am ready to load it on their
machine. (They all already have Access.)

SO...can I expect a problem using v8.x on my PC to develop my code for
processing on the 400?

Thanks.

On Thu, 29 Apr 2004 00:45:26 GMT, Larry <La***@nospam.net> wrote:

You don't need DB2, you need DB2 Connect if you want to "pass queries
through" to DB2/400. And if you use DB2 Connect V8, I don't see any
reason why you couldn't connect to V5R2 on 400, but you should check the
DB2 Connect doc just to be sure.

Larry Edelstein

Tom wrote:

We have an AS/400 running DB2 v5r2m0. I want to get a copy of DB2 for
my desktop, primarily to create queries that I will "pass-thru" to the
400 using MSAccess. I believe the current version of DB2 is 8.1.
Will I have any problem with 8.1 talking to an older v5?

I ask because as I was working on getting MS Access to talk to our db
on the 400, I seem to remember an error message about the current
version can only talk to an older version that is no more than two
versions old. I'm getting quotes back that list both 8.1 and 6.1.
And, obviously, I don't want to get the "wrong" one.

Any help is appreciated.

Thanks in advance,

Tom

[Franco Lombardo]

> We have an AS/400 running DB2 v5r2m0. I want to get a copy of DB2 for

my desktop, primarily to create queries that I will "pass-thru" to the
400 using MSAccess. I believe the current version of DB2 is 8.1.
Will I have any problem with 8.1 talking to an older v5?
Maybe there is a misunderstanding: the version number of
DB2/400 and DB2 UDB are not the same. (I think that the DB is not the same
at all :-).

V5R2M0 is the most recent version of DB2400 (better, OS400), while
8.1 is the most recent version of DB2 UDB.

I ask because as I was working on getting MS Access to talk to our db
on the 400

In order to do this, the best way is to use the ODBC driver shipped whith
i-Series Access (former known as Client Access).

Bye

Franco

[Tom]

On Thu, 29 Apr 2004 14:36:34 +0200, "Franco Lombardo"
<f_********@hotmail.com> wrote:

We have an AS/400 running DB2 v5r2m0. I want to get a copy of DB2 for
my desktop, primarily to create queries that I will "pass-thru" to the
400 using MSAccess. I believe the current version of DB2 is 8.1.
Will I have any problem with 8.1 talking to an older v5?
Maybe there is a misunderstanding: the version number of
DB2/400 and DB2 UDB are not the same. (I think that the DB is not the same
at all :-).

V5R2M0 is the most recent version of DB2400 (better, OS400), while
8.1 is the most recent version of DB2 UDB.

Do you mean that v8.x on the 400 (assuming it even exists) can NOT be
considered the same as v8.x on a non 400 box?

So if v5 on the 400 is the most recent FOR the 400, will running v8.x
on my client machine, to develop code to run on the 400, work? Will
the version difference be a problem?

I ask because as I was working on getting MS Access to talk to our db
on the 400
In order to do this, the best way is to use the ODBC driver shipped whith
i-Series Access (former known as Client Access).

Sorry, that will NOT work. The ODBC driver that comes with i-Series
Access, DOES work for our apps developed by our software vendor.
BUT...it does NOT work for Access. Well, okay, TECHNICALLY it works.
I mean, one CAN link to the db using the i-Series driver. But this
linking is NOT at the same level (for lack of a better description) as
DB2 Connect provides. With DB2 Connect, I can see the libraries,
tables and fields I need. With i-Series, I can NOT.

If you believe that it CAN, please tell me how, I'd like to know.
Seriously.
Thanks.

Bye

Franco

[Tom]

Thanks.

I know to "pass thru" a query I only need DB2 Connect. But I've read,
in multiple responses, that processing a DB2 query on the 400 is much
better than letting Access process the request. So I'm ASSUMING that
I need a copy of DB2 on MY PC, so I can develop the query which I will
eventually "pass thru".

On the typical client (user's) PC, I would only install DB2 Connect,
once I have developed my app, and am ready to load it on their
machine. (They all already have Access.)

SO...can I expect a problem using v8.x on my PC to develop my code for
processing on the 400?

Thanks.

On Thu, 29 Apr 2004 00:45:26 GMT, Larry <La***@nospam.net> wrote:

You don't need DB2, you need DB2 Connect if you want to "pass queries
through" to DB2/400. And if you use DB2 Connect V8, I don't see any
reason why you couldn't connect to V5R2 on 400, but you should check the
DB2 Connect doc just to be sure.

Larry Edelstein

Tom wrote:

We have an AS/400 running DB2 v5r2m0. I want to get a copy of DB2 for
my desktop, primarily to create queries that I will "pass-thru" to the
400 using MSAccess. I believe the current version of DB2 is 8.1.
Will I have any problem with 8.1 talking to an older v5?

I ask because as I was working on getting MS Access to talk to our db
on the 400, I seem to remember an error message about the current
version can only talk to an older version that is no more than two
versions old. I'm getting quotes back that list both 8.1 and 6.1.
And, obviously, I don't want to get the "wrong" one.

Any help is appreciated.

Thanks in advance,

Tom

[Tom]

On Thu, 29 Apr 2004 14:36:34 +0200, "Franco Lombardo"
<f_********@hotmail.com> wrote:

We have an AS/400 running DB2 v5r2m0. I want to get a copy of DB2 for
my desktop, primarily to create queries that I will "pass-thru" to the
400 using MSAccess. I believe the current version of DB2 is 8.1.
Will I have any problem with 8.1 talking to an older v5?
Maybe there is a misunderstanding: the version number of
DB2/400 and DB2 UDB are not the same. (I think that the DB is not the same
at all :-).

V5R2M0 is the most recent version of DB2400 (better, OS400), while
8.1 is the most recent version of DB2 UDB.

Do you mean that v8.x on the 400 (assuming it even exists) can NOT be
considered the same as v8.x on a non 400 box?

So if v5 on the 400 is the most recent FOR the 400, will running v8.x
on my client machine, to develop code to run on the 400, work? Will
the version difference be a problem?

I ask because as I was working on getting MS Access to talk to our db
on the 400
In order to do this, the best way is to use the ODBC driver shipped whith
i-Series Access (former known as Client Access).

Sorry, that will NOT work. The ODBC driver that comes with i-Series
Access, DOES work for our apps developed by our software vendor.
BUT...it does NOT work for Access. Well, okay, TECHNICALLY it works.
I mean, one CAN link to the db using the i-Series driver. But this
linking is NOT at the same level (for lack of a better description) as
DB2 Connect provides. With DB2 Connect, I can see the libraries,
tables and fields I need. With i-Series, I can NOT.

If you believe that it CAN, please tell me how, I'd like to know.
Seriously.
Thanks.

Bye

Franco

[Karl Hanson]

Franco Lombardo wrote:

We have an AS/400 running DB2 v5r2m0. I want to get a copy of DB2 for
my desktop, primarily to create queries that I will "pass-thru" to the
400 using MSAccess. I believe the current version of DB2 is 8.1.
Will I have any problem with 8.1 talking to an older v5?

Maybe there is a misunderstanding: the version number of
DB2/400 and DB2 UDB are not the same. (I think that the DB is not the same
at all :-).

V5R2M0 is the most recent version of DB2400 (better, OS400), while
8.1 is the most recent version of DB2 UDB.

Just a terminology clarification: V5R2M0 is the most recent version of
DB2 UDB for iSeries - as part of OS/400, the version is the same. 8.1
is the version of DB2 UDB for LUW (Linux, Unix, and Windows).

There is some DB2 UDB Family info here:
http://www.ibm.com/servers/enable/site/db2/porting.html

Two database connectivity tools commonly used with iSeries are iSeries
Access (formerly Client Access) and DB2 Connect:
http://www.ibm.com/servers/eserver/iseries/access/
http://www.ibm.com/software/data/db2/db2connect/

--
Karl Hanson

[Karl Hanson]

Tom wrote:

On Thu, 29 Apr 2004 14:36:34 +0200, "Franco Lombardo"
<f_********@hotmail.com> wrote:

We have an AS/400 running DB2 v5r2m0. I want to get a copy of DB2 for
my desktop, primarily to create queries that I will "pass-thru" to the
400 using MSAccess. I believe the current version of DB2 is 8.1.
Will I have any problem with 8.1 talking to an older v5?
Maybe there is a misunderstanding: the version number of
DB2/400 and DB2 UDB are not the same. (I think that the DB is not the same
at all :-).

V5R2M0 is the most recent version of DB2400 (better, OS400), while
8.1 is the most recent version of DB2 UDB.

Do you mean that v8.x on the 400 (assuming it even exists) can NOT be
considered the same as v8.x on a non 400 box?

DB2 for Linux on iSeries is v8.x, but it runs in a Linux partition on
iSeries. Here is more info:
http://www.ibm.com/servers/eserver/i...db2/index.html

This is different than DB2 UDB for iSeries, that is part of OS/400 (eg
V5R2M0):
http://www.ibm.com/servers/eserver/iseries/db2/

So if v5 on the 400 is the most recent FOR the 400, will running v8.x
on my client machine, to develop code to run on the 400, work? Will
the version difference be a problem?
The version difference should not be a problem.

I ask because as I was working on getting MS Access to talk to our db
on the 400

In order to do this, the best way is to use the ODBC driver shipped whith
i-Series Access (former known as Client Access).

Sorry, that will NOT work. The ODBC driver that comes with i-Series
Access, DOES work for our apps developed by our software vendor.
BUT...it does NOT work for Access. Well, okay, TECHNICALLY it works.
I mean, one CAN link to the db using the i-Series driver. But this
linking is NOT at the same level (for lack of a better description) as
DB2 Connect provides. With DB2 Connect, I can see the libraries,
tables and fields I need. With i-Series, I can NOT.

iSeries Access was developed to have tight integration with the iSeries
server, whereas DB2 Connect is more generic, providing support for
OS/390 (zSeries) too. In terms of objects residing on iSeries (schemas,
tables, views, column info, etc), you should be able to "see" all of it
via iSeries Access. You can verify this using iSeries Navigator, the
Run SQL Scripts facility, etc. However there may be (?) some
interaction between MSAccess and iSeries Access ODBC driver that is
hiding iSeries database objects (I am not familiar with MSAccess).

--
Karl Hanson

[Karl Hanson]

Franco Lombardo wrote:

We have an AS/400 running DB2 v5r2m0. I want to get a copy of DB2 for
my desktop, primarily to create queries that I will "pass-thru" to the
400 using MSAccess. I believe the current version of DB2 is 8.1.
Will I have any problem with 8.1 talking to an older v5?

Maybe there is a misunderstanding: the version number of
DB2/400 and DB2 UDB are not the same. (I think that the DB is not the same
at all :-).

V5R2M0 is the most recent version of DB2400 (better, OS400), while
8.1 is the most recent version of DB2 UDB.

Just a terminology clarification: V5R2M0 is the most recent version of
DB2 UDB for iSeries - as part of OS/400, the version is the same. 8.1
is the version of DB2 UDB for LUW (Linux, Unix, and Windows).

There is some DB2 UDB Family info here:
http://www.ibm.com/servers/enable/site/db2/porting.html

Two database connectivity tools commonly used with iSeries are iSeries
Access (formerly Client Access) and DB2 Connect:
http://www.ibm.com/servers/eserver/iseries/access/
http://www.ibm.com/software/data/db2/db2connect/

--
Karl Hanson

[Karl Hanson]

Tom wrote:

On Thu, 29 Apr 2004 14:36:34 +0200, "Franco Lombardo"
<f_********@hotmail.com> wrote:

We have an AS/400 running DB2 v5r2m0. I want to get a copy of DB2 for
my desktop, primarily to create queries that I will "pass-thru" to the
400 using MSAccess. I believe the current version of DB2 is 8.1.
Will I have any problem with 8.1 talking to an older v5?
Maybe there is a misunderstanding: the version number of
DB2/400 and DB2 UDB are not the same. (I think that the DB is not the same
at all :-).

V5R2M0 is the most recent version of DB2400 (better, OS400), while
8.1 is the most recent version of DB2 UDB.

Do you mean that v8.x on the 400 (assuming it even exists) can NOT be
considered the same as v8.x on a non 400 box?

DB2 for Linux on iSeries is v8.x, but it runs in a Linux partition on
iSeries. Here is more info:
http://www.ibm.com/servers/eserver/i...db2/index.html

This is different than DB2 UDB for iSeries, that is part of OS/400 (eg
V5R2M0):
http://www.ibm.com/servers/eserver/iseries/db2/

So if v5 on the 400 is the most recent FOR the 400, will running v8.x
on my client machine, to develop code to run on the 400, work? Will
the version difference be a problem?
The version difference should not be a problem.

I ask because as I was working on getting MS Access to talk to our db
on the 400

In order to do this, the best way is to use the ODBC driver shipped whith
i-Series Access (former known as Client Access).

Sorry, that will NOT work. The ODBC driver that comes with i-Series
Access, DOES work for our apps developed by our software vendor.
BUT...it does NOT work for Access. Well, okay, TECHNICALLY it works.
I mean, one CAN link to the db using the i-Series driver. But this
linking is NOT at the same level (for lack of a better description) as
DB2 Connect provides. With DB2 Connect, I can see the libraries,
tables and fields I need. With i-Series, I can NOT.

iSeries Access was developed to have tight integration with the iSeries
server, whereas DB2 Connect is more generic, providing support for
OS/390 (zSeries) too. In terms of objects residing on iSeries (schemas,
tables, views, column info, etc), you should be able to "see" all of it
via iSeries Access. You can verify this using iSeries Navigator, the
Run SQL Scripts facility, etc. However there may be (?) some
interaction between MSAccess and iSeries Access ODBC driver that is
hiding iSeries database objects (I am not familiar with MSAccess).

--
Karl Hanson

[Tom]

Thanks so much!

On Thu, 29 Apr 2004 08:08:37 -0500, Karl Hanson
<kc******@youess.ibm.com> wrote:

Franco Lombardo wrote:

We have an AS/400 running DB2 v5r2m0. I want to get a copy of DB2 for
my desktop, primarily to create queries that I will "pass-thru" to the
400 using MSAccess. I believe the current version of DB2 is 8.1.
Will I have any problem with 8.1 talking to an older v5?

Maybe there is a misunderstanding: the version number of
DB2/400 and DB2 UDB are not the same. (I think that the DB is not the same
at all :-).

V5R2M0 is the most recent version of DB2400 (better, OS400), while
8.1 is the most recent version of DB2 UDB.

Just a terminology clarification: V5R2M0 is the most recent version of
DB2 UDB for iSeries - as part of OS/400, the version is the same. 8.1
is the version of DB2 UDB for LUW (Linux, Unix, and Windows).

There is some DB2 UDB Family info here:
http://www.ibm.com/servers/enable/site/db2/porting.html

Two database connectivity tools commonly used with iSeries are iSeries
Access (formerly Client Access) and DB2 Connect:
http://www.ibm.com/servers/eserver/iseries/access/
http://www.ibm.com/software/data/db2/db2connect/

[Tom]

Thanks so much!

On Thu, 29 Apr 2004 08:08:37 -0500, Karl Hanson
<kc******@youess.ibm.com> wrote:

Franco Lombardo wrote:

We have an AS/400 running DB2 v5r2m0. I want to get a copy of DB2 for
my desktop, primarily to create queries that I will "pass-thru" to the
400 using MSAccess. I believe the current version of DB2 is 8.1.
Will I have any problem with 8.1 talking to an older v5?

Maybe there is a misunderstanding: the version number of
DB2/400 and DB2 UDB are not the same. (I think that the DB is not the same
at all :-).

V5R2M0 is the most recent version of DB2400 (better, OS400), while
8.1 is the most recent version of DB2 UDB.

Just a terminology clarification: V5R2M0 is the most recent version of
DB2 UDB for iSeries - as part of OS/400, the version is the same. 8.1
is the version of DB2 UDB for LUW (Linux, Unix, and Windows).

There is some DB2 UDB Family info here:
http://www.ibm.com/servers/enable/site/db2/porting.html

Two database connectivity tools commonly used with iSeries are iSeries
Access (formerly Client Access) and DB2 Connect:
http://www.ibm.com/servers/eserver/iseries/access/
http://www.ibm.com/software/data/db2/db2connect/

[Franco Lombardo]

Do you mean that v8.x on the 400 (assuming it even exists) can NOT be
considered the same as v8.x on a non 400 box?
I think so. The SQL sintax is 99% similar, but there are some
minor differences, expecially on the table structure manipulation
commands.
So if v5 on the 400 is the most recent FOR the 400, will running v8.x
on my client machine, to develop code to run on the 400, work? Will
the version difference be a problem?

I did it some times ago. The real problem, as you said, is not SQL,
but the ODBC drivers, that behave in some different way, expecially with
MS Access.

In order to do this, the best way is to use the ODBC driver shipped whith
i-Series Access (former known as Client Access).

Sorry, that will NOT work. The ODBC driver that comes with i-Series
Access, DOES work for our apps developed by our software vendor.
BUT...it does NOT work for Access. Well, okay, TECHNICALLY it works.
I mean, one CAN link to the db using the i-Series driver. But this
linking is NOT at the same level (for lack of a better description) as
DB2 Connect provides. With DB2 Connect, I can see the libraries,
tables and fields I need. With i-Series, I can NOT.

If you believe that it CAN, please tell me how, I'd like to know.
Seriously.

i-Series Access ODBC drivers can really do the work, but I think that
the software have to be modified a bit to fit them.
I think that, expecially for performance reasons, they are the best
choice.

Bye

Franco

[Franco Lombardo]

Do you mean that v8.x on the 400 (assuming it even exists) can NOT be
considered the same as v8.x on a non 400 box?
I think so. The SQL sintax is 99% similar, but there are some
minor differences, expecially on the table structure manipulation
commands.
So if v5 on the 400 is the most recent FOR the 400, will running v8.x
on my client machine, to develop code to run on the 400, work? Will
the version difference be a problem?

I did it some times ago. The real problem, as you said, is not SQL,
but the ODBC drivers, that behave in some different way, expecially with
MS Access.

In order to do this, the best way is to use the ODBC driver shipped whith
i-Series Access (former known as Client Access).

Sorry, that will NOT work. The ODBC driver that comes with i-Series
Access, DOES work for our apps developed by our software vendor.
BUT...it does NOT work for Access. Well, okay, TECHNICALLY it works.
I mean, one CAN link to the db using the i-Series driver. But this
linking is NOT at the same level (for lack of a better description) as
DB2 Connect provides. With DB2 Connect, I can see the libraries,
tables and fields I need. With i-Series, I can NOT.

If you believe that it CAN, please tell me how, I'd like to know.
Seriously.

i-Series Access ODBC drivers can really do the work, but I think that
the software have to be modified a bit to fit them.
I think that, expecially for performance reasons, they are the best
choice.

Bye

Franco