Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Call Script with Parameter (that has another parameter)
Top Forums Shell Programming and Scripting Call Script with Parameter (that has another parameter) Post 302929567 by aimy on Monday 22nd of December 2014 08:37:18 PM
Old 12-22-2014
Lightbulb
Quote:
Originally Posted by Corona688
That depends entirely on the contents of exec_sql.sh, and what "put on top" means.
Oh sorry for not being really clear.

What I actually mean is that the ${file_name} variable is predefined before the command
Code:
sh /EDWH-DMT02/script/MISC/exec_sql.sh "@/EDWH-DMT02/script/others/CSM_CKC/Complete_List.sql ${file_name}" Complete_List.txt

the exec_sql.sh is simply to accept two parameters
1. SQL command to be executed (in this case I pass the script file)
2. The filename of the spool file
Code:
sqlplus -s /nolog <<EOF
@/home/oracle9/dba_area/logon_credentials.sql

spool $2.txt
---------------------------------------------------------------------------------------
$1
/
commit
/

spool off
EOF

And the Complete_List.sql...
Code:
spool complete_$1.list
select $1||'_'||to_char(sysdate,'YYYYMMDD')||'.csv' from dual union
select $1||'_'||to_char(sysdate-1,'YYYYMMDD')||'.csv' from dual union
select $1||'_'||to_char(sysdate-2,'YYYYMMDD')||'.csv' from dual
;
spool off

So any ideas?

Thanks a lot.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how do I make dynamic parameter names? Or get the value of a parameter evaluated twi

Say I write something like the following: var1=1 var2=2 for int in 1 2 do echo "\$var$int" done I want the output to be: 1 2 Instead I get something like: $var1 $var2 (2 Replies)
Discussion started by: Awanka
2 Replies

2. Shell Programming and Scripting

Not getting the out value parameter of a DB call in the ksh file

Hi all Im calling a DB procedure as foll sqlplus -s $DB_USERID/$DB_PASSWD@$DB_NAME<<eof var var1 VARCHAR2(200); exec ODAS_BATCH_JOBS_RETRIEVE.retrieve_user_info(:var1); eof echo $var1 This echo is giving a blank. Also in case the package ODAS_BATCH_JOBS_RETRIEVE is in an un compiled... (2 Replies)
Discussion started by: Sam123
2 Replies

3. AIX

Audit problem : A system call received a parameter that is not valid.

while i try to start the audit i have the below error message . audit>audit start ** auditing enabled already A system call received a parameter that is not valid. please advice (6 Replies)
Discussion started by: thecobra151
6 Replies

4. Shell Programming and Scripting

How to call stored procedure with CLOB out parameter from shell script?

I have written a stored procedure in oracle database, which is having a CLOB OUT parameter. How can i call this stored procedure from shell script and get the CLOB object in shell script variable? (0 Replies)
Discussion started by: vel4ever
0 Replies

5. Shell Programming and Scripting

Command that takes one parameter and then searches for the passed in parameter

Hi I am looking for a unix command or a small shell script which can takes one parameter and then searches for the passed in the parameter in any or all files under say /home/dev/ Can anyone please help me on this? (3 Replies)
Discussion started by: pankaj80
3 Replies

6. Shell Programming and Scripting

Passing parameter to script, and split the parameter

i am passing input parameter 'one_two' to the script , the script output should display the result as below one_1two one_2two one_3two if then echo " Usage : <$0> <DATABASE> " exit 0 else for DB in 1 2 3 do DBname=`$DATABASE | awk -F "_" '{print $1_${DB}_$2}` done fi (5 Replies)
Discussion started by: only4satish
5 Replies

7. Shell Programming and Scripting

How to get the parameter value from the parameter file in perl?

hi all, i have a parameter file of following format, i want a method which can get the value of specific parameter. parameter file format: <Parameter Name="FileLocationWindows"> <Description> The directory location of the logger file. ... (1 Reply)
Discussion started by: laxmikant.hcl
1 Replies

8. Shell Programming and Scripting

Resolving a parameter which is passed as parameter

Hi, I have the following files. ->cat scr.sh export TMP_DIR=/home/user/folder1 export TMP_DIR_2=/home/user/folder2 while read line do cat "$line" done<file_list.dat ------------------------ -> cat file_list.dat $TMP_DIR/file1.txt $TMP_DIR_2/file2.txt --------------------------- -> cat... (6 Replies)
Discussion started by: barath
6 Replies

9. Shell Programming and Scripting

To call Oracle procedure by reading parameter file in UNIX

hi Guys, is there a way to pass parameter into oracle store procedure by reading date range in file and increment accordingly. Something like this file.txt 01-JAN-2015 03-JAN-2015 sqlplus -s user/pwd@DB execute TEST( to_date( '01-JAN-2015, 'dd.mm.yyyy' ), to_date( '03-JAN-2015', ... (1 Reply)
Discussion started by: rohit_shinez
1 Replies

10. Shell Programming and Scripting

Call script parameter based on dates

Hi Guys, I am having a script which needs to be iterated based on date passed and itrate based on no of months given. #!/bin/bash var_d=$1 months=$2 sh invoke_script var_d i need to iterate the inside script something like below sh invoke_script 170101 sh invoke_script... (4 Replies)
Discussion started by: Master_Mind
4 Replies

LEARN ABOUT OPENDARWIN

source

source(n)						       Tcl Built-In Commands							 source(n)

__________________________________________________________________________________________________________________________________________________

NAME

       source - Evaluate a file or resource as a Tcl script

SYNOPSIS

       source fileName

       source -rsrc resourceName ?fileName?

       source -rsrcid resourceId ?fileName?
_________________________________________________________________

DESCRIPTION

       This  command takes the contents of the specified file or resource and passes it to the Tcl interpreter as a text script.  The return value
       from source is the return value of the last command executed in the script.  If an error occurs in evaluating the contents  of  the  script
       then  the source command will return that error.  If a return command is invoked from within the script then the remainder of the file will
       be skipped and the source command will return normally with the result from the return command.

       The end-of-file character for files is '32' (^Z) for all platforms.  The source command will  read  files  up  to  this  character.   This |
       restriction  does  not  exist for the read or gets commands, allowing for files containing code and data segments (scripted documents).	If |
       you require a ``^Z'' in code for string comparison, you can use ``32'' or ``u001a'', which will be safely substituted by the Tcl  inter- |
       preter into ``^Z''.

       The -rsrc and -rsrcid forms of this command are only available on Macintosh computers.  These versions of the command allow you to source a
       script from a TEXT resource.  You may specify what TEXT resource to source by either name or id.  By default Tcl searches all open resource
       files,  which  include  the  current  application  and any loaded C extensions.	Alternatively, you may specify the fileName where the TEXT
       resource can be found.

SEE ALSO

       file(n), cd(n)

KEYWORDS

       file, script

Tcl																	 source(n)
All times are GMT -4. The time now is 05:35 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy