Sponsored Content
Top Forums Shell Programming and Scripting A script pls( To retrieve database information) Post 302189472 by rollthecoin on Saturday 26th of April 2008 02:11:33 AM
Old 04-26-2008
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)?
 

10 More Discussions You Might Find Interesting

1. Programming

SunWS_cache: Information: Database is locked, waiting

While compiling a set of proC code I am getting the following error. Any clues why this error is coming and is it related to my Oracle DB/Verison Software DB or compile time generated information? Thanks Rishi (3 Replies)
Discussion started by: RishiPahuja
3 Replies

2. Shell Programming and Scripting

pls help me !! about text database shell programming

my teacher assigned me an assignment about text database shell programming but I don't know anything about that. here is about problem. I must submit this assignment to my teacher before 3 August. contact me at **deleted**, thank you Given a text database file for student registration name... (2 Replies)
Discussion started by: sunattha
2 Replies

3. Solaris

command to retrieve user information

Hi, I want the command to retrieve the existing user information such as * authorization * Profile * role * exipre(expiration date of login) * inactive please tell me how to do that Thank you. (3 Replies)
Discussion started by: S_venkatesh
3 Replies

4. Shell Programming and Scripting

Storing information into a database.

Hey guys, i am having a problem in storing new data into a text file. The database in in a text file and it displays information like this : Name : Price : Quantity Persia : 80 : 30 Now , i have written the code to check if the book already exist in the Databse. Number= echo -n... (3 Replies)
Discussion started by: gregarion
3 Replies

5. Shell Programming and Scripting

Execute a C program and retrieve information

Hi I have the following script: #!/bin/sh gcc -o program program.c ./program & PID=$! where i execute a C program and i get its pid. I want to retrieve information about this program (e.g memory consumption) using command top. So far i have: top -d 1.0 -p $PID But i dont know how to... (6 Replies)
Discussion started by: nteath
6 Replies

6. Programming

pls. help with SQL database...

On the Linux systems, we have scripts which monitor disk usage. I want to take that data and feed that into SQL database. Can you give some advise. For example here is one of the file. I have many files like this but the format is same... 2012-09-24 04:36:14 2012-09-24 04:36:16 48414984... (3 Replies)
Discussion started by: samnyc
3 Replies

7. Shell Programming and Scripting

Retrieve information Text/Word from HTML code using awk/sed

awk/sed newbie here. I have a HTML file and from that file and I would like to retrieve a text word. <font face=arial size=-1><li><a href=/value_for_clients/Tokyo/abc_process.txt>abc</a> NDK Version: 4.0 </li> <font face=arial size=-1><li><a... (6 Replies)
Discussion started by: sk2code
6 Replies

8. Shell Programming and Scripting

Match and retrieve information from file

Hello I just want to ask how to get the match of information column 2 file 1 and retrieve information from column 2 file 2. The column exon in file 1 and column color code in file 2. File 1 //NODECOLORCODE "Exon 1" "ENST00000595813" //NODECOLORCODE "Exon 1" ... (4 Replies)
Discussion started by: Wan Fahmi
4 Replies

9. Solaris

Solaris commands to retrieve chipset information

I need to know what are the commands in Solaris to retrieve the below information about the hardware platform. 1. Chipset information (information about various hardware controller cards on the mother boards, system BIOS versions, PCI firmware version etc..) 2. Serial number of the work... (2 Replies)
Discussion started by: rajujayanthy
2 Replies

10. Shell Programming and Scripting

Hide and retrieve database credentials

Hi Everyone, I am new to shell scripting and I have a requirement to fire a sql statement to Oracle database and create a out file in Unix server. This will be plugged in to Autosys as a batch job. I have the database credentials saved in a configuration file in the below format. ... (7 Replies)
Discussion started by: Pradeep_Raj
7 Replies
gretl(1)							   econometrics 							  gretl(1)

NAME
gretl - GNU Regression, Econometrics and Time-series Library SYNOPSIS
gretl [ options ] [ datafile | scriptfile | sessionfile ] DESCRIPTION
gretl is an econometrics package, built around a shared library which may be accessed using a command-line client program (gretlcli) or a graphical user interface (gretl_x11). The program gretl is a wrapper script that calls the GUI if the DISPLAY environment variable is set, otherwise the command-line client. For details, please start up either the GUI or the command-line client and consult the online help, or read the printed manual, which is available in PDF format via the gretl website, http://gretl.sourceforge.net. OPTIONS
These are the options supported by the gretl_x11 program; gretlcli is a little different. -r script, --run script Open a script. -c, --dump Dump the configuration file. -d database, --db database Open a local database. -e, --english Force use of English. -r script, --run script Open a script. -w database, --webdb database Open a remote database. -h, --help Give help information and exit. -v, --version Give version information and exit. FILES
~/.gretl2rc per-user configuration file ~/.gretl directory for user runtime files ENVIRONMENT VARIABLES
HOME Specifies the user's home directory DISPLAY Specifies the X window display to use SEE ALSO
gretlcli(1) AUTHOR
The gretl team The gretl team 1.9.5 gretl(1)
All times are GMT -4. The time now is 06:41 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy