|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Calling SQL scripts through Shell Script
Post 302076067 by madhunk on Thursday 8th of June 2006 01:21:35 PM
06-08-2006
Thomas,
I tried to use your script with two control files MetadataA.ctl and MetadataB.ctl
I am unable to execute the Load.ksh script through your script. The Load.ksh script requires three parameters. 1) USERID 2) CONTROL FILE and 3) DATA FILE.
I am not sure how to pass the control file parameter in your SELECT CASE statement.
Please advice...This is becoming more and more complicated for me and I am scratching my head
I tried to use your script with two control files MetadataA.ctl and MetadataB.ctl
I am unable to execute the Load.ksh script through your script. The Load.ksh script requires three parameters. 1) USERID 2) CONTROL FILE and 3) DATA FILE.
I am not sure how to pass the control file parameter in your SELECT CASE statement.
Please advice...This is becoming more and more complicated for me and I am scratching my head
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
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)
Discussion started by: lijju.mathew
1 Replies
2. Shell Programming and Scripting
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)
Discussion started by: dummy_needhelp
6 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. Shell Programming and Scripting
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)
Discussion started by: Radhe
2 Replies
5. UNIX for Advanced & Expert Users
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)
Discussion started by: chintapalli001
1 Replies
6. Shell Programming and Scripting
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)
Discussion started by: shashi369
1 Replies
7. Shell Programming and Scripting
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)
Discussion started by: dazdseg
16 Replies
8. Shell Programming and Scripting
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)
Discussion started by: anil029
7 Replies
9. Shell Programming and Scripting
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)
Discussion started by: sushi
1 Replies
10. Shell Programming and Scripting
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
gen-ctl-io
GEN-CTL-IO(1) libctl GEN-CTL-IO(1) NAME
gen-ctl-io - generate C interface code for libctl control files SYNOPSIS
gen-ctl-io [OPTION]... [spec-file] DESCRIPTION
gen-ctl-io generates C code to import/export the input/output variables used in a libctl control file. gen-ctl-io generates files like ctl-io.h and ctl-io.c. These files define global variables, data structures, and functions for the input/output variables, classes, and function interfaces defined in the spec-file argument, automating the interaction between C and Guile. The arguments such as --code and --header are used to control whether ctl-io.c or ctl-io.h, etcetera, are generated. If no argument is specified then both of these files are generated by default, for backwards compatibility. libctl is a free library to aid in interfacing scientific software with the GNU Guile scripting and extension language. Documentation for it may be found online at the libctl home page: http://ab-initio.mit.edu/libctl OPTIONS
--code Generate C (or C++) source code to implement the Guile interface functions. The default output file name is ctl-io.c (in C) or ctl- io.cpp (in C++). --header Generate the header file declaring the interface data types and functions. The default output file name is ctl-io.h (in C) or ctl- io.hpp (in C++). --swig Generate a SWIG interface definition file declaring automatic conversions for the various libctl data types. The default output file name is ctl-io.i. --cxx Generate C++ code instead of C code. -o file Use file as the output file name instead of the defaults (above). BUGS
Send bug reports to S. G. Johnson, stevenj@alum.mit.edu. AUTHORS
Written by Steven G. Johnson. libctl March 27, 2006 GEN-CTL-IO(1)