I have the requirement to run multiple SQLs against database running on a server and save the output of SQL executed to a log.
I thought about writing a Function in sh that will take file name as argument and function should return the SQL output to calling program. E.g.
This function I am planning to call multiple times for all SQL files that need to be executed one by one.
Can someone please suggest if the approach I used is correct or is there a better way to achieve it. I am a novice to shell scripting.
Thanks a lot for your time.
Moderator's Comments:
Please view this code tag video for how to use code tags when posting code and data.
Last edited by vbe; 08-31-2012 at 05:21 AM..
Reason: replaced fonts by code tags
As I was just pondering to myself I relized that emergency's do happen and there are times when people need an anwser to their problem ASAP. So what i was thinking why not add a live chat to this board this way people could chat amongst each other in real time. I know this could be done with a... (1 Reply)
I am a student and I love the computer very much ,
especially in programming. However I know little about
programming .
I don't know which I should learn (JAVA and C++).
Would you like to give me a suggestion ?
Thanks! (6 Replies)
Hi all:
I need your suggestion about how to making this script
Purpose:-
Monitor log for the system
OS: Unix Sun Solaris 10
Hold oracle database 10 g
Life time for the system cycle to 48 hours
the system working as the follow
1- the system is divided into three steps
2-... (0 Replies)
Discussion started by: dellsh
0 Replies
5. Post Here to Contact Site Administrators and Moderators
Can we have a forum that is dedicated to topics concerning power management ? It'd be great to have a few moderators to address these issues concerning the power-management. More-so-ever since research related to power management at the OS level is kicking up a lot of dust and becoming a hot area... (7 Replies)
Hello,
I'm working on a Linux 2.6.32-33-server (Ubuntu 4.4.3).
I typed in man -k package and got e.g. apt
I typed in apt --help and got:
The program 'apt' is currently not installed. You can install it by typing:
sudo apt-get install openjdk-6-jdkI don't understand where this... (2 Replies)
Hi folks,
Any good suggestion concerning this BASH search script?
#Any good suggestions for this simple search shell?
#================================
#!/bin/bash
clear
echo "Enter File Name for search"
echo
read filename
locate $filename
if ;
then
echo No such file... (1 Reply)
I'm searching to learn linux coding for a month but no clear about the where to start . Right now i'm in networking but not much interested in this maintenance jobs . I'm looking to create my own product in wireless network and also having idea about gadget that can be useful for students . But i... (1 Reply)
Discussion started by: Cholasivam
1 Replies
9. Post Here to Contact Site Administrators and Moderators
Hello Admin/moderators Team,
Greetings !!
This is regarding a suggestion which may help our forum if this is possible.
Thanks,
R. Singh
"GOD helps those who help themselves" (2 Replies)
Discussion started by: RavinderSingh13
2 Replies
LEARN ABOUT DEBIAN
mongo
MONGO(1) Mongo Database MONGO(1)NAME
mongo - the Mongo command-line tool
SYNOPSIS
mongo [OPTIONS] [DB_ADDRESS] [FILE+]
DESCRIPTION
mongo is a JavaScript shell (with GNU readline capabilities). It supports interactive and non-interactive use. When used interactively,
JavaScript can be used to query the database or perform any other function normally available with SpiderMonkey. Database output is dis-
played in JSON format.
If JavaScript files are specified on the command line, the shell will run non-interactively, running each one in sequence and then exiting.
EXAMPLES
mongo start the shell, connecting to the server at localhost:27017 and using the test database
mongo foo
start the shell using the foo database at localhost:27017
mongo 192.169.0.5/foo
start the shell using the foo database at 192.169.0.5:27017
mongo 192.169.0.5:9999/foo
start the shell using the foo database at 192.169.0.5:9999
mongo script1.js script2.js script3.js
run three scripts and exit
OPTIONS --shell
run the shell after executing files
--help show usage information
--host HOST
server to connect to (default HOST=localhost)
--port PORT
port to connect to (default PORT=27017)
--nodb do not connect to mongod
--eval SCRIPT
evaluate JavaScript
-u USERNAME
specify user to log in as
-pPASSWORD
specify password of user (notice there is no space)
COPYRIGHT
Copyright 2007-2009 10gen
SEE ALSO
For more information, please refer to the MongoDB wiki, available at http://www.mongodb.org.
AUTHOR
Kristina Chodorow
10gen June 2009 MONGO(1)