The UNIX and Linux Forums  
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
.
google unix.com




View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->
  #1 (permalink)  
Old 04-26-2008
rollthecoin rollthecoin is offline
Registered User
  
 

Join Date: Mar 2008
Posts: 26
A script pls( To retrieve database information)

KSH - Unix -AIX - db2

**************
Get the input from the user say '123' (It varies)

Then i want to connect to a database say "D1"
then i want th extract from the database by giving "select * from tablename where input = '123'

I also want to connect to another database "D2"
then i want th extract from the database by giving "select * from tablename where input = '123'

output should be displayed on the screen as it is when i execute the select statements individually.
********************************
This is what i want to do in a script

Can you show a script for that(For eg)?