For Programmers: Free Programming Magazines  


Home > Archive > Smalltalk > October 2005 > Accessing DB2 tables in mainframe









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Accessing DB2 tables in mainframe
meetsmalltalker@gmail.com

2005-10-09, 7:05 pm

Hi,

I am new to Smalltalk. I'm currently working on a project where we have
a need to access DB2 tables in mainframe. I'm using VisualWorks for
Smalltalk version 7.0.

Can anyone assist me how to access mainframe DB2 tables using
VisualWorks for Smalltalk?

Thanks in advance for your assistance.

Davide Grandi

2005-10-13, 7:00 pm

<meetsmalltalker@gmail.com> wrote:

> Hi,
>
> I am new to Smalltalk. I'm currently working on a project where we have
> a need to access DB2 tables in mainframe. I'm using VisualWorks for
> Smalltalk version 7.0.


DB2 tables on mainframe (/390 MVS or VSE or ... iSeries) can be accesed
like any other DB2 database if you install the DB2 UDB Connect product.
Then you'll see the mainframe (or i5-iSeries-AS/400) database like any
other database cataloged on your workstation, accessible via ODBC, CLI
or even DB2 command line.

It is available in many flavors, from the single pc edition to the
"enterprise" edition running on a server.

Tipically the DB Administrator on the mainframe has some licensed CD to
spare or, in the worst case, some try-and-buy time-limited edition.

I did'nt remember if there's a downloadable free "developer" and/or time
limited edition, you can browse the ibm.com/software site or ... google.

On the developerworks IBM site there's a serie of 4 articles devoted to
all kinds of DB2 connection and configuration (ahm, er ... this come
from my works on a J... language) : they are maintained so when I need
them I google for "DB2 UDB Connectivity Cheat Sheets".

Good luck !!!

Davide Grandi
---
Ing. Davide Grandi
davide.grandi@mclink.it
meetsmalltalker@gmail.com

2005-10-14, 3:58 am

David,

Thanks for your valuable information.

Regards

meetsmalltalker@gmail.com wrote:
> Hi,
>
> I am new to Smalltalk. I'm currently working on a project where we have
> a need to access DB2 tables in mainframe. I'm using VisualWorks for
> Smalltalk version 7.0.
>
> Can anyone assist me how to access mainframe DB2 tables using
> VisualWorks for Smalltalk?
>
> Thanks in advance for your assistance.


Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com