|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Error with nested if within an sqlplus task inside
Post 302860749 by Akshay Hegde on Monday 7th of October 2013 06:53:22 AM
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a file contains
TASK gsnmpproxy {
CommandLine = $SMCHOME/bin/gsnmpProxy.exe
}
TASK gsnmpdbgui {
CommandLine = $SMCHOME/bin/gsnmpdbgui.exe
I would like to comment and than uncomment specific task eg TASK gsnmpproxy
Pls suggest how to do in shell script (9 Replies)
Discussion started by: madhusmita
9 Replies
2. Shell Programming and Scripting
I have a question about nested double quotes. Any help is appreciated.
Here are my commands on Mac OS.
# string="Ethernet \"USB Ethernet\" \"Bluetooth DUN\" AirPort FireWire \"Bluetooth PAN\""
# echo $string
Ethernet "USB Ethernet" "Bluetooth DUN" AirPort FireWire "Bluetooth PAN"
#... (3 Replies)
Discussion started by: lindazhou
3 Replies
3. Shell Programming and Scripting
Hi all,
I am using the below given sqlplus command in my unix script to invoke a stored procedure which returns a value .It works fine.
RET_CODE=$(/opt/oracle/product/10.2.0.4.CL/bin/sqlplus -S $USER/$PASSWD@$DB_NAME <<EOF
EXEC MY_PKG.MY_SP (:COUNT);
PRINT COUNT;
commit;
... (6 Replies)
Discussion started by: Shri123
6 Replies
4. Red Hat
Hello,
I need to repack a file inside several java archives (nested .jar files) with or without overwrite.
I am using a manual approach with mc, but it's painfully slow progress.
For example I want to refresh a file deep inside a java archive (with nested .jar files):
I have a java... (0 Replies)
Discussion started by: Laurentiu
0 Replies
5. Shell Programming and Scripting
I tried this:
for region in 'raj' 'kt' 'kol' 'krl' 'chn' 'dl' 'hr' 'bih' 'ap'
do
sqlplus -s huw$region/`echo $region`huw#321@huw$region<<!
set serveroutput on
begin
select count(*) from tcd_preferred_cust_201109
end;
/
exit;
done
but the error shows like:
Syntax error at line 4 :... (1 Reply)
Discussion started by: deepakprasad29@
1 Replies
6. Shell Programming and Scripting
HI everyone,
I am not able to find error in the script, when i run the script till
line No. 20
i.e, read var4
everything runs fine. After that the script exits out.
#!/bin/bash
echo -e "Want dryrun OR merge: \n "
read var1
if ] ; then
echo -e "\n Please select from the given... (10 Replies)
Discussion started by: rishi.aradhya
10 Replies
7. Shell Programming and Scripting
please let me know if the below code could be written efficiently inside single awk
case "$INP" in
ksh)
cat catalog | awk 'BEGIN {FS=",";} { print $2 } END {}'
;;
pset)
cat catalog | awk 'BEGIN {FS=",";} { print $3 } END {}'
;;
dml)
cat catalog | awk 'BEGIN {FS=",";} {... (2 Replies)
Discussion started by: cvsanthosh
2 Replies
8. Shell Programming and Scripting
Hello,
I have a problem. I want to launch a different sql queries for different shell parameter values, something like this.
#/bin/bash
case $1 in
"A")
sqlplus -s user/pass << SQL
query A;
SQL
"B") sqlplus -s user/pass << SQL2
... (3 Replies)
Discussion started by: Vares
3 Replies
9. Shell Programming and Scripting
Hi,
facing an issue while calling sqlplus inside shell script. It for some reason goes to tmp file to write something and i get error as permission denied as i dont have access there.
ANy idea why sqlplus writes in /tmp and how to change or stop this ? (2 Replies)
Discussion started by: rushikeshs
2 Replies
10. Shell Programming and Scripting
i am using bash shell
Whenever i declare an array, and then using sqlplus, i am getting sqlplus error and return code 127.
IFS=","
declare -a Arr=($Variable1);
SQLPLUS=sqlplus -s "${DBUSER}"/"${DBPASS}"@"${DBASE}
echo "set head off ; " > ${SQLCMD}
echo "set PAGESIZE 0 ;" >> ${SQLCMD}... (6 Replies)
Discussion started by: arghadeep adity
6 Replies
LEARN ABOUT DEBIAN
clag
Psi Release 2.0 1 clag(1) PSI COMMANDS FOR UNIX USERS clag(1) NAME
clag - Lagrangian Program written in C. DESCRIPTION
The program clag forms the lagrangian matrix from the one and two particle density matrices and the one and two elec- tron integrals. The lagrangian is used for MCSCF and CI de- rivative calculations. REFERENCES
Lagrangian: 1. A New Dimension to Quantum Chemistry, Y. Yamaguchi, Y. Osamura, J.D. Goddard, H. F. Schaefer III, Oxford Univ. Press, (1994). FILES REQUIRED
input.dat Input file FILE71 Transformed one-electron integrals FILE72 Transformed two-electron integrals FILE73 One-Particle Density Matrix FILE74 Two-Particle Density Matrix FILES UPDATED
FILE75 Lagrangian output.dat INPUT FORMAT
The input for this program is read from the file input.dat. The following keywords are valid: PRINT = integer This option determines the verbosity of the output. A value of 0 prints nothing, a value of 1 prints calcu- lated ci energy and the various components of the ci energy, a value of 2 prints the one- and two-electron contributions to the MO lagrangian as well as the MO lagrangian, a value of 3 prints the one-particle den- sity matrix, and a value of 4 prints the two-particle density matrix. Do not use print = 4 unless the test case is very small. WRITE_CAS_FILES = boolean If TRUE, then write out the following files in canoni- cal form (p>=q, r>=s, pq>=rs) in Pitzer order: one- Psi Release 2.0 Last change: 21 June, 1996 1 clag(1) PSI COMMANDS FOR UNIX USERS clag(1) electron integrals (file81), two-electron integrals (file82), one-particle density matrix (file83), two- particle density matrix (file84), lagrangian (file85). This is temporary and is intended to aid in linking DETCI with CASSCF. Psi Release 2.0 Last change: 21 June, 1996 2