09-17-2010
not ideal, it is too long winded. I don't need credentials as the user running the script will already have read/write on the database. I am hoping there is an easier method...
I am hoping for a simple command to run the SQL within a shell script.
My current method works fine but I would like to merge it into 1 script. I basically echo the SQL to a 2nd file, 2ndfile.sql, then include the command to run that file within my 1st script.
10 More Discussions You Might Find Interesting
1. Programming
hi
I want to call a shell script in C program
the script is : ssh -t user@remote sh /<remote>home/user/<file_name>.sh
and other several commands
C program : Call this script and the retrive the task that is been done in <file_name>.sh file
can any one tell me how... (5 Replies)
Discussion started by: mridula
5 Replies
2. Shell Programming and Scripting
I want to add lines in my script dynamically.
My script:
...
echo addscript
end addscript
...
Lines to add: (can be put in a file and can be added)
cp /opt/script1.sh opt/script1_org.sh
sed 's/testusr/'${FUNCTID}'/g' /opt/script1.sh > ./tmpfile
mv ./tmpfile /opt/script1.sh... (1 Reply)
Discussion started by: chiru_h
1 Replies
3. Shell Programming and Scripting
Hi-
I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment...
I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert... (5 Replies)
Discussion started by: rajagavini
5 Replies
4. UNIX for Dummies Questions & Answers
Hi Gurus,
Is it possible to include perl script with in the unix shell script?
What would be the general syntax?
In the above case, is it required to write the below first two lines of codes?
#!usr/bin/sh -x
#!usr/bin/perl -w
Thanks in advance / Mysore Ganapati. (1 Reply)
Discussion started by: ganapati
1 Replies
5. Shell Programming and Scripting
Hello,
I have a script and a second file that contains all parameters needed for the script.
How can I include this file in the script ?
I tried source but I have a "no such file or directory" error.
:) (1 Reply)
Discussion started by: pppswing
1 Replies
6. UNIX for Dummies Questions & Answers
Hi. When you write a script/program in vi Do you include the $ Eg. #!/bin/bash $ echo "Today's date is `date`" or echo "Today's date is `date`" Make your script executable. $chmod +x script I included that. I keep getting a permission denied... why? Thanks! (5 Replies)
Discussion started by: JudoMan
5 Replies
7. UNIX for Dummies Questions & Answers
Hi guys,
I am new on here, I have a function in oracle that returns a specific value:
create or replace
PACKAGE BODY "CTC_ASDGET_SCHED" AS
FUNCTION FN_ASDSCHEDULE_GET
RETURN VARCHAR2
AS
BEGIN
DECLARE
ASDSchedule varchar2(6);
ASDComplete... (1 Reply)
Discussion started by: reptile
1 Replies
8. UNIX for Dummies Questions & Answers
Can anyone help me how to include COLUMN HEADER when spooling file to .CSV format through SQL statement.
Thanks,
Akbar (4 Replies)
Discussion started by: s1a2m3
4 Replies
9. Shell Programming and Scripting
# dbc "delete from alert;"
DELETE 10
#
However, the script created below generates an error that command does not exits. Can any one please exist.
script.sh:
#!/bin/sh
dbc "delete from alert;" >>$TASKLOGFILE
./script.sh: line 38: dbc: command not found
can any one please... (2 Replies)
Discussion started by: sureshcisco
2 Replies
10. UNIX for Dummies Questions & Answers
Hi guys i have written a script which takes the options given to him and execute itself accordingly.
for example
if a script name is doctortux then executing doctortux without option should made doctortux to be executed in automatic mode i.e. doctortux -a
or if a doctortux is needed to run in... (4 Replies)
Discussion started by: pinga123
4 Replies
LEARN ABOUT DEBIAN
cd-hit-2d-para
CD-HIT-2D-PARA.PL(1) User Commands CD-HIT-2D-PARA.PL(1)
NAME
cd-hit-2d-para.pl - divide a big clustering job into pieces to run cd-hit-2d or cd-hit-est-2d jobs
SYNOPSIS
cd-hit-2d-para.pl options
DESCRIPTION
This script divide a big clustering job into pieces and submit jobs to remote computers over a network to make it parallel. After
all the jobs finished, the script merge the clustering results as if you just run a single cd-hit-2d or cd-hit-est-2d.
You can also use it to divide big jobs on a single computer if your computer does not have enough RAM (with -L option).
Requirements:
1 When run this script over a network, the directory where you
run the scripts and the input files must be available on all the remote hosts with identical path.
2 If you choose "ssh" to submit jobs, you have to have
passwordless ssh to any remote host, see ssh manual to know how to set up passwordless ssh.
3 I suggest to use queuing system instead of ssh,
I currently support PBS and SGE
4 cd-hit-2d cd-hit-est-2d cd-hit-div cd-hit-div.pl must be
in same directory where this script is in.
Options
-i input filename for 1st db in fasta format, required
-i2 input filename for 2nd db in fasta format, required
-o output filename, required
--P program, "cd-hit-2d" or "cd-hit-est-2d", default "cd-hit-2d"
--B filename of list of hosts, requred unless -Q or -L option is supplied
--L number of cpus on local computer, default 0 when you are not running it over a cluster, you can use this option to divide a big
clustering jobs into small pieces, I suggest you just use "--L 1" unless you have enough RAM for each cpu
--S Number of segments to split 1st db into, default 2
--S2 Number of segments to split 2nd db into, default 8
--Q number of jobs to submit to queue queuing system, default 0 by default, the program use ssh mode to submit remote jobs
--T type of queuing system, "PBS", "SGE" are supported, default PBS
--R restart file, used after a crash of run
-h print this help
More cd-hit-2d/cd-hit-est-2d options can be speicified in command line
Questions, bugs, contact Weizhong Li at liwz@sdsc.edu
cd-hit-2d-para.pl 4.6-2012-04-25 April 2012 CD-HIT-2D-PARA.PL(1)