04-26-2008
Quote:
Originally Posted by
rollthecoin
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)?
##############################################
Data Base Connection & Get information from DB
##############################################
echo "Enter Input File Name"
read FILE
# To check the value in TABLE_CFS_DUMP table FILE_NAME value
RETVAL=`sqlplus -silent USERNAME/PASSWORD@DBNAME <<EOF
set pagesize 0 feedback off verify off heading off echo off
select * from TABLE_CFS_DUMP where FILE_NAME like '$FILE';
exit;
END`
echo "The DB Query Output is: $RETVAL "
10 More Discussions You Might Find Interesting
1. Programming
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
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
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
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
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
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
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
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
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
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
LEARN ABOUT DEBIAN
grass-sqlite
grass-sqlite(1grass) Grass User's Manual grass-sqlite(1grass)
NAME
grass-sqlite - SQLite driver
SQLite driver SQLite driver in GRASS
Creating a SQLite database
GRASS is automatically creating the SQLite database if it is not yet existing when the first table is created in the SQLite database. It is
sufficient to define the connection (see next step).
Connecting GRASS to SQLite
The database name 'sqlite.db' is at user's choice. Also the file storage location can be freely chosen. If the database does not exist, it
will be automatically created when database content is created:
# example for storing DB in mapset directory (keep single quotes):
db.connect driver=sqlite database='$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite.db'
db.connect -p
Supported SQL commands
All SQL commands supported by SQLite (for limitations, see SQLite help page: SQL As Understood By SQLite and Unsupported SQL).
Operators available in conditions
All SQL operators supported by SQLite.
Browsing table data in DB
A convenient SQLite front-end is sqlitebrowser. To open a DB file stored within the current mapset, the following way is suggested (corre-
sponds to above database connection):
eval `g.gisenv`
# use double quotes:
sqlitebrowser "$GISDBASE/$LOCATION_NAME/$MAPSET"/sqlite.db
SEE ALSO
db.connect, db.execute, db.select
SQL support in GRASS GIS
SQLite web site, SQLite manual, sqlite - Management Tools
Last changed: $Date: 2011-02-07 18:59:50 +0100 (Mon, 07 Feb 2011) $
Help Index
GRASS 6.4.2 grass-sqlite(1grass)