Check the syntax; it's fairly simple to find the bugs at this point
1) You changed:
Code:
THEN 'prtnrLoadMetadata.ksh ${USERID} ${CONTROL_FILEB} ${DATA_FILE}'
ELSE 'prtnrLoadMetadata.ksh ${USERID} ${CONTROL_FILEA} ${DATA_FILE}'
to:
Code:
THEN '$PARTNER_DB/prtnrLoadMetadata.ksh ${USERID} ${CONTROL_FILEB} ${DATA_FILE}'
ELSE '$PARTNER_DB/prtnrLoadMetadata.ksh ${USERID} ${CONTROL_FILEA} ${DATA_FILE}'
therefore, you must change the KSH expression that you are looking for:
Code:
case
...
$PARTNER_DB/prtnrLoadMetadata*) exec ${LINE} ;;
...
esac
or
case
...
*prtnrLoadMetadata*) exec ${LINE} ;;
...
esac
2) We both simply missed the missing semicolon here:
Code:
THEN 'CREATE OR REPLACE PUBLIC SYNONYM ACXIOM_METADATA FOR ACXIOM_METADATA_B;' <===
ELSE 'CREATE OR REPLACE PUBLIC SYNONYM ACXIOM_METADATA FOR ACXIOM_METADATA_A;' <===
Conclusions:
Korn shell can't guess where all your strings are changing. Make sure that your case statement can actually match the patter returning from sqlplus
Hi all,
In a shell script I need to pass two parameters to a pl/sql script and get the ouput of the pl/sql script and use it in shell script.
For example
Shell script : test.sh
PL/SQL script : get_id.sql parameter1 parameter2
Actually get_id.sql has a select statement something... (1 Reply)
Hello everybody
I need help calling sql file from shell script.
Can anyone help me creating a small shell script which calls an sql file .
The .sql file should contain some select statements like
select emp_no from emp_table;
select emp_id from emp_table;
And the results should be... (6 Replies)
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)
Dear All,
I want to call an sql script within a unix shell script. I want to pass a parameter into the shell script which should be used as a parameter in teh sql script.
e.g
$ ./shell1.sh 5000129
here 5000129 is a prameter
inside shell script i am calling one sql script
e.g. ... (2 Replies)
Hi
I have a shell script that call a sql file. The sql file will create a spool file.
My requirement is, when ever i get an OS error like file not found. I have to log it in a log file.
Could some who worked in a like scenario help me by giving the code sample.
Many Thanks.. (1 Reply)
Hello gurus,
I have three korn shell script 3.1, 3.2, 3.3. I would like to call three shell script in one shell script.
i m looking for something like this
call 3.1;
If 3.1 = "complete" then
call 3.2;
if 3.2 = ''COMPlete" then
call 3.3;
else
exit
The... (1 Reply)
Hi,
I want to call a sql file in my shell script. see the below code:-
if ]
then
(
isql -U${S_USER} -S${S_SERV} -w100 -b -h0 <<ENDSQL | sed -e "s/Password://"
${S_PWD}
set nocount on
go
use ${S_DB}
go
// need to call a file name... (16 Replies)
Hi,
I am calling a sql file script.sql from shell script and passing few parameters also as shown below:
sqlplus -S id/password @script.sql $param1 $param2
Now,In sql file I have to create a extract text file after querying oracle tables based on the parameters passed(param1,param2) as... (7 Replies)
I have a master shell script which calls some 40 shell scripts. All the shell scripts calls a sql file which executes some sql statements.
I run these scripts in parallel such that it saves me time. When i executed them i saw some strange behavior.
Firstly, I found that some scripts among the 40... (1 Reply)
Hi,
i have one simple PL/SQL Block and i have saved it as .sql file, which i am trying to call from UNIX script.
PL/SQL block structure
CONNECT DB_NAME/PWD@Database
whenever SQLERROR EXIT 1;
Declare
..Variables...
BEGIN
--Code--
exception
END;
exit;
I have save this block as... (3 Replies)
Discussion started by: abhii
3 Replies
LEARN ABOUT DEBIAN
gchem3d
GCHEM3D(1) gnome-chemistry-utils GCHEM3D(1)NAME
gchem3d - a small chemical viewer application
SYNOPSIS
gchem3d [OPTION(S)...] [FILE...]
DESCRIPTION
gchem3d is a small chemical viewer application, which can show several chemical file formats.
OPTIONS
The following options are accepted:
-b COLOR, --bgcolor=COLOR
Use the given color as background color. COLOR can be one of "black" (default), "white", "#rrggbb" (don't forget to escape the "#"
character in the shell).
-d MODEL, --display3d=MODEL
Choose how molecules are displayed. MODEL can be one of "BallnStick" (default), "SpaceFill".
-?, --help
Show application help options.
--help-all, --help-*
Print all or just a group of help options. These options are not documented here. Instead see gtk-options(7) and gnome-options(7).
-v, --version
Print gchem3d version information.
SEE ALSO gnome-options(7), gtk-options(7)AUTHORS
Jean Brefort <jean.brefort@normalesup.org>
Program author.
Daniel Leidert <daniel.leidert@wgdd.de>
Manpage author.
COPYRIGHT
Copyright (C) 2002-2007 Jean Brefort
Copyright (C) 2004-2007 Daniel Leidert
Permission is granted to copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 2 or any
later version published by the Free Software Foundation.
gcu 0.12 $Date: 2009-03-19 10:53:47 +0100 (jeu. 19 mars 2009) $ GCHEM3D(1)
06-08-2006
