02-23-2006
your shell script may look like this
//to read from file
cat filename |while read line
do
//do some thing
//create sql script
echo "sql command" >>query.sql
//connect to database
sqlplus username/password@query.sql<<STOP
STOP
done
8 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi ,
I am new to linux and also also to shell scripting.
I have one shell script which unpacks .tgz file and install software on machine.
When this script runs I want to insert id,filename,description(which will be in readme file),log(which will be in log file) and name of unpacked folder... (1 Reply)
Discussion started by: ring
1 Replies
2. Shell Programming and Scripting
Hello Guys,
I'm new to Shell scripting, and i need someone to help me with this issue:
I'm trying to do a dynamic update query on Sysbase database table using shell script.
Lets say, the Update query is "update Table set id=X" , where X is dynamic value for the loop index.
If the loop is... (10 Replies)
Discussion started by: Alaeddin
10 Replies
3. UNIX and Linux Applications
Hello
I'm writing a program for managing accounts and groups in a linux system.
My problem is how to update the members of a group in the /etc/group file,if i have to add/remove those members.
total 3 variables for adding some new members to the group :
char **oldmembers=grp->gr_mem; ... (1 Reply)
Discussion started by: mekos
1 Replies
4. Shell Programming and Scripting
The title says it all. I have a upnp server running fuppes that is connected to my xbox360. In order to see the files on the xbox360 i have to manually update and rebuild the database anytime i add or remove files. I have tried cron jobs to do it every 20 min which works, but if I am streaming... (0 Replies)
Discussion started by: tr6699
0 Replies
5. Shell Programming and Scripting
CAN I download an html file via wget and pass it to mysql and update a database field? (8 Replies)
Discussion started by: mapasainfo
8 Replies
6. Red Hat
For Suppose, I have installed a package having files file1, file2 and file3. After installation, I removed the file "file3".
But "rpm -qf file3" is giving the package name, even file3 was not there. And also "rpm -ql package" is also displaying all 3 files.
How can i update rpm database about... (6 Replies)
Discussion started by: snreddy_gopu
6 Replies
7. UNIX for Dummies Questions & Answers
I have no idea what I should set the topic here =='
This is my story, please you there kindly help me I'm quite newbie for this.
==================================
My host server is CentOS, I spared 9.9GB for /var path that used by MySQL
and...It's full because of heavy load traffic, then... (1 Reply)
Discussion started by: Kapom
1 Replies
8. Shell Programming and Scripting
Im trying to update an informix database table for each occurance of a head_barcode in a file called mw within a for loop
please see below - cant get the syntax correct. any help please?
for a in `cat /tmp/mw`
do
sql image - << STOP > /dev/null 2>&1
update doc_table set status =... (4 Replies)
Discussion started by: worky
4 Replies
LEARN ABOUT DEBIAN
sqlobject-admin
SQLOBJECT-ADMIN(1) General Commands Manual SQLOBJECT-ADMIN(1)
NAME
sqlobject-admin - manage your database as defined with SQLObject classes
SYNOPSIS
sqlobject-admin [options] command
DESCRIPTION
The sqlobject-admin tool included with SQLObject allows you to manage your database as defined with SQLObject classes.
Some of the features include creating tables, checking the status of the database, recording a version of a schema, and updating the
database to match the version of the schema in your code.
COMMANDS
The following commands are recognized:
help
Show the help text.
create
Find the tables and create them. Existing tables are simply skipped.
sql
Show the SQL to create all the tables.
drop
Drop tables. Missing tables are skipped.
execute
Execute an arbitrary SQL expression.
list
List out all the found classes.
status
Show if tables are present in the database.
record
Record historical information about the database status
upgrade
Update the database to a new version (as created by record)
OPTIONS
-c CONNECTION, --connection=CONNECTION
Connection string for the database .
-f FILENAME, --config-file=FILENAME
Configuration file from which to get the connection to the database.
-m MODULE, --module=MODULE
A module to look in for classes.
-p PACKAGE, --package=PACKAGE
A package to look in.
--class=CLASSMATCH
Restricting the found classes to the matching classes.
--egg=EGG_SPEC
Egg description that should be loaded.
AUTHORS
This manual page was written by Carl Chenet <chaica@ohmytux.com>.
LICENSE
This package is licensed under the GNU Lesser General Public License. You can
find the full text of the LGPL in /usr/share/common-licenses/LGPL in your
Debian system.
06/03/2010 SQLOBJECT-ADMIN(1)