06-17-2008
chk once ur parameters
hi
chk ur parameters passing to ur scripts ..
./hema.sh path/sqlfile.sql path/sqlfile.csv
$1 is path/sqlfile.sql
$2 is path/sqlfile.csv
parameter passing will be like this
myscript.sh first second third
but u have taken in reverse
$1 is ur spool file
$2 is ur sql file to be ran
parameter u used in
spool ${filename}
@${sqlfile}
try like this
./hema.sh path/sqlfile.csv path/sqlfile.sql
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am trying to pass some of the variables in my shell scripts to the sqlplus call and use them as parameters.
For example, I would like to replace the 'SAS', and '20050612' with $var1 and $var2, respectively, how can I do that?
--------------------------------------------------------... (1 Reply)
Discussion started by: Jtrinh
1 Replies
2. Shell Programming and Scripting
if
then
# mail -s "Import failed file does not exist" sanjay.jaiswal@xyz.com
echo "FILE does not exist"
exit 1
fi
echo "FILE EXIST"
size=-1
set $(du /export/home/oracle/nas/scott21.dmp.gz)
while
do
echo "Inside the loop"
size=$1
set $(du... (1 Reply)
Discussion started by: sanora600
1 Replies
3. Shell Programming and Scripting
Hi,
I need help urgently for following issue. Pls help me to resolve this issue.
I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql)
I given... (6 Replies)
Discussion started by: praka
6 Replies
4. Shell Programming and Scripting
Hi,
I am using SYBASE database. in my script i am connecting to DB via using isql.
isql -U${S_USER} -S${S_SERV} -D${S_DB} -P${S_PWD} -b0 -w3000 -h0 -s"|" -i${MYDIR}/ABC.sql -oXYZ.txt << FINSQL
i am taking a ABC.sql file to use the queries written in it and storing the output in... (3 Replies)
Discussion started by: dazdseg
3 Replies
5. UNIX and Linux Applications
using sqlplus I want to execute a .sql script that has dbms_output statments in rhe script. I want to write the dbms_output statements from .sql file to a log file. is this possible. thanks
any help would be appreciated
:wall: (1 Reply)
Discussion started by: TRS80
1 Replies
6. Shell Programming and Scripting
Gurus,
The issue I'm having is that my Shell won't accept SQL parameters properly......
Here's they way I'm running it....
applmgr@ga006hds
=> sh CW_MigrationDeployScript.sh apps <appspwd> <SID> '01-JAN' '31-MAR'
The process just hangs not submitting the SQL job...
... (3 Replies)
Discussion started by: WhoDatWhoDer
3 Replies
7. Shell Programming and Scripting
echo "set echo off"; echo "set feedback off"; echo "set linesize 4000"; echo " set pagesize 0"; echo " set sqlprompt ''"; echo " set trimspool on";
Select statement is mentioned below
echo "select res.ti_book_no from disney_ticket_history res where res.ti_status =${STATUS} and... (7 Replies)
Discussion started by: aroragaurav.84
7 Replies
8. Programming
i have file in which i have employee id are there and every time number of employee id are different in file means number of count of employee id in file are every time different.
343535435
365765767
343534543
343543543
i want to pass this file to sqlplus
and sql command is
... (7 Replies)
Discussion started by: pallvi_mahajan
7 Replies
9. Shell Programming and Scripting
Hi All,
I am new to shell script. I am trying to pass value from .sh file to .sql file .
But I am able to run the .sql file from .sh file with values in sql file.
But I am unable to pass the values from .sh file. can some one please help to resolve this.
here is my .sh file
s1.sh
... (4 Replies)
Discussion started by: reddy298599
4 Replies
10. UNIX for Beginners Questions & Answers
hello friend good morning
I have a problem, how can I take the value that the PROCEDURE returns to me in the variable "CodError", when the connection to the bbdd is closed I lose the value and I need it in the shell
#AIX
cat <<EOF | sqlplus -s ${ORA_LOGIN}/${ORA_PASSWORD} > $logftmp
set... (6 Replies)
Discussion started by: tricampeon81
6 Replies
LEARN ABOUT DEBIAN
pymetrics
PYMETRICS(1) User Commands PYMETRICS(1)
NAME
pymetrics - Python source code metrics
SYNOPSIS
pymetrics [options] files...
DESCRIPTION
This manual page documents briefly the pymetrics command
pymetrics is a program that produces metrics for Python programs. Metrics include McCabe's Cyclomatic Complexity metric, LoC, %Comments,
etc. Users can also define their own metrics using data from PyMetrics. PyMetrics optionally outputs to stdout, SQL command files and CSV
files.
OPTIONS
These programs follow the usual GNU command line syntax, with long options starting with two dashes (`-'). A summary of options is
included below.
-h, --help
show this help message and exit
-s SQLFILENAME, --sql=SQLFILENAME
name of output SQL command file. (Default is metricData.sql)
-t SQLTOKENTABLENAME, --tokentable=SQLTOKENTABLENAME
name of output SQL token table. (Default is metricTokens)
-m SQLMETRICSTABLENAME, --metricstable=SQLMETRICSTABLENAME
name of output SQL metrics table. (Default is metricData)
-c CSVFILENAME, --csv=CSVFILENAME
name of output CSV data file. (Default is metricData.csv)
-f INFILELIST, --files=INFILELIST
File containing list of path names to modules for analysis.
-i INCLUDEMETRICSSTR, --include=INCLUDEMETRICSSTR
list of metrics to include in run. This is a comma separated list of metric module names with no whitespace. Optionally, you can
specify the class name of the metric by following the module name with a colon (:) and the metric class name. (Default metrics are
'simple:SimpleMetric,mccabe:McCabeMetric,sloc:SLOC Metric'. Default metric class name for metric module 'wxYz' is 'WxYzMetric' when
only module name given -- note capitalized metric class name.)
-l LIBNAME, --library=LIBNAME
user-defined name applied to collection of modules (Default is '')
-e, --exists
assume SQL tables exist and does not generate creation code. Using this option sets option -N. (Default is False)
-N, --noold
create new command output files and tables after deleting old results, if any. Ignored if -e is set. (Default is False)
-B, --nobasic
suppress production of Basic metrics (Default is False)
-S, --nosql
suppress production of output SQL command text file. (Default is False)
-C, --nocsv
suppress production of CSV output text file. (Default is False)
-H, --noheadings
suppress heading line in csv file. (Default is False)
-k, --kwcnt
generate keyword counts. (Default is False)
-K, --nokwcnt
suppress keyword counts. (Default is True)
-q, --quiet
suppress normal summary output to stdout. (Default is False)
-z, --zero
display zero or empty values in output to stdout. (Default is to suppress zero/empty output)
-v, --verbose
Produce verbose output - more -v's produce more output. (Default is no verbose output to stdout)
-d, --debug
Provide debug output, not usually generated - internal use only
AUTHOR
pymetrics was written by Reg. Charney.
This manual page was written by Andrew Pollock <apollock@debian.org>, for the Debian project (but may be used by others).
pymetrics 0.8.1 September 2009 PYMETRICS(1)