|
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| UNIX for Advanced & Expert Users Expert-to-Expert. Learn advanced UNIX, UNIX commands, Linux, Operating Systems, System Administration, Programming, Shell, Shell Scripts, Solaris, Linux, HP-UX, AIX, OS X, BSD. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Querying database from unix | ragavhere | Shell Programming and Scripting | 3 | 06-02-2008 10:48 AM |
| Querying a database using open source voice control software | iBot | UNIX and Linux RSS News | 0 | 05-16-2008 05:50 AM |
| Connecting and Querying DB2 database from Unix Script? | developncode | Shell Programming and Scripting | 2 | 05-02-2008 01:47 PM |
| Connecting to Oracle Database | dreams5617 | Shell Programming and Scripting | 4 | 05-02-2008 01:37 PM |
| Connecting to a database via UNIX | penfold | UNIX for Advanced & Expert Users | 1 | 03-05-2005 02:37 PM |
 |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
05-02-2008
|
||||
|
||||
Connecting to DB2 database on Mainframe and Querying DB
I am trying to develop a script that can connect to a DB2 database mainframe and Query the database and display the results. I've been researching, but I have yet to find a definitive solution where I can enter in the Mainframe DB2 address db2:// and query the database and return the results. If anyone has any information that can help me it will be greatly appreciated. Thanks All.
|
|
05-02-2008
|
||||
|
||||
|
i) code something using a framework like e.g. Perl DBI or Java JDBC
ii) Does it have to be a standalone script? Install the free DB2 kit on some machine and copy'n'paste in some queries. |
|
05-06-2008
|
||||
|
||||
|
Connecting from Unix to z/OS is not free. You need a license for this.
You need to install and configure DB2 client to do that. Once you have DB2 installed on your UNIX box you will need to catalog the z/OS system and database if you run DB2 Connect locally. If you don't run DB2 Connect locally then you will need to catalog the node to point to the DB2 Connect server. The script does not point to the server directly here is a simple example #!/bin/ksh db2 connect to yourdb db2 "select * from your blah.table" db2 terminate |
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Hybrid Mode
