Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to pass a shellscript variable to a sql file?
Top Forums Shell Programming and Scripting How to pass a shellscript variable to a sql file? Post 302896548 by radoulov on Tuesday 8th of April 2014 05:30:15 AM
Old 04-08-2014
If I understand correctly:

Code:
$ cat a.sql
select &1 from dual;
$ field_name=sysdate
$ sqlplus -s '/ as sysdba' <<EOF
> @a.sql "$field_name"
> EOF
old   1: select &1 from dual
new   1: select sysdate from dual

SYSDATE
---------
08-APR-14

$

For clearer output:

Code:
$ sqlplus -s '/ as sysdba' <<EOF
> set ver off head off pages 0
> @a.sql "$field_name"
> EOF
08-APR-14

$

This User Gave Thanks to radoulov For This Post:
anbu23
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to pass enviroment variable from csh to Informix sql script

Hello, I have a csh script that creates an environment variable. I want to pass the environment variable(CURR_TABLE_DATE) to an Informix sql script. Here is the csh: #!/bin/csh -f setenv INFORMIXSERVER market3_tcp setenv CURR_TABLE_DATE 20090714 set DATABASE = gm_cdr set SQL_DIR =... (0 Replies)
Discussion started by: jwoj
0 Replies

2. Shell Programming and Scripting

Pass variable to sql

Please help. I got these error. I'm try to pass variable extract from data-file.txt to sql file(select.sql). cat: cannot open select cat: cannot open * cat: cannot open from cat: cannot open user cat: cannot open where cat: cannot open name=$list; #!/bin/bash list=`sed q... (3 Replies)
Discussion started by: killboy
3 Replies

3. Shell Programming and Scripting

Pass a variable to SQL script

Hi Guys, I like to pass a variable to a sql file in a unix script.. I tried a below code.. var=200903 db2 -vf test.sql 200903 test.sql is as below. select * from db2.users where quarter = $1; Please tell me where i go wrong.. Thanks in advance, Magesh (2 Replies)
Discussion started by: mac4rfree
2 Replies

4. Shell Programming and Scripting

how to pass a variable to an update sql statement inside a loop

hi all, i am experiencing an error which i think an incorrect syntax for the where clause passing a variable was given. under is my code. sqlplus -s ${USERNAME}/${PASSWORD}@${SID} << END1 >> $LOGFILE whenever sqlerror exit set serveroutput on size 1000000 declare l_rc ... (0 Replies)
Discussion started by: ryukishin_17
0 Replies

5. Shell Programming and Scripting

How to pass arguments to SQL file passed in shell script?

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

6. Red Hat

How to pass value of pwd as variable in SED to replace variable in a script file

Hi all, Hereby wish to have your advise for below: Main concept is I intend to get current directory of my script file. This script file will be copied to /etc/init.d. A string in this copy will be replaced with current directory value. Below is original script file: ... (6 Replies)
Discussion started by: cielle
6 Replies

7. UNIX for Dummies Questions & Answers

To pass multiple arguments from file in to an sql query

Hi all , I want to pass contents from a file say f1 as arguments to a sql query which has In statement using a script example select * from table_1 where login in ( `cat f1`) ; will this work or is there any other way to do it. (1 Reply)
Discussion started by: zozoo
1 Replies

8. Shell Programming and Scripting

Pass command line arg to sql file

Hi all, How to pass the command line argument to a sql file Script: #!/bin/ksh if ] ; then test.sql fi My Sql Informix DB: echo "select * from table where col1 = 2234 and col2 = '$3'"|dbaccess ddname But im getting `:' unexpected error (5 Replies)
Discussion started by: Roozo
5 Replies

9. Shell Programming and Scripting

Unable to pass value from .Shell script to .SQL file

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. Shell Programming and Scripting

Need script to pass all sql file names in a directory to DB query

Hi All, In this path /home/all_files we have follwing files and direcotries proc_edf_sot.sql proc_ssc_sot.sql func_dfg_sot.sql sot unic cmr sdc under sot directory we have other directories sql pas ref under sql directory we have sql_sot sql_mat (6 Replies)
Discussion started by: ROCK_PLSQL
6 Replies

LEARN ABOUT DEBIAN

apr::bucketalloc

libapache2-mod-perl2-2.0.7::docs::api::APR::BucketAlloc(User Contributed Perl Documentlibapache2-mod-perl2-2.0.7::docs::api::APR::BucketAlloc(3pm)

NAME

       APR::BucketAlloc - Perl API for Bucket Allocation

Synopsis
	 use APR::BucketAlloc ();
	 $ba = APR::BucketAlloc->new($pool);
	 $ba->destroy;

Description
       "APR::BucketAlloc" is used for bucket allocation.

   "new"
       Create an "APR::BucketAlloc" object:

	 $ba = APR::BucketAlloc->new($pool);

       class: "APR::BucketAlloc"
       arg1: $pool ( "APR::Pool object" )
	   The pool used to create this object.

       ret: $ba ( "APR::BucketAlloc object" )
	   The new object.

       since: 2.0.00

       This bucket allocation list (freelist) is used to create new buckets (via "APR::Bucket->new") and bucket brigades (via
       "APR::Brigade->new").

       You only need to use this method if you aren't running under httpd.  If you are running under mod_perl, you already have a bucket
       allocation available via "$c->bucket_alloc" and "$bb->bucket_alloc".

       Example:

	 use APR::BucketAlloc ();
	 use APR::Pool ();
	 my $ba = APR::BucketAlloc->(APR::Pool->pool);
	 my $eos_b = APR::Bucket::eos_create($ba);

   "destroy"
       Destroy an "APR::BucketAlloc object":

	 $ba->destroy;

       arg1: $ba ( "APR::BucketAlloc object" )
	   The freelist to destroy.

       ret: no return value
       since: 2.0.00

       Once destroyed this object may not be used again.

       You need to destroy $ba only if you have created it via "APR::BucketAlloc->new". If you try to destroy an allocation not created by this
       method, you will get a segmentation fault.

       Moreover normally it is not necessary to destroy allocators, since the pool which created them will destroy them during that pool's cleanup
       phase.

See Also
       mod_perl 2.0 documentation.

Copyright
       mod_perl 2.0 and its core modules are copyrighted under The Apache Software License, Version 2.0.

Authors
       The mod_perl development team and numerous contributors.

perl v5.14.2							    2011-02-08	      libapache2-mod-perl2-2.0.7::docs::api::APR::BucketAlloc(3pm)
All times are GMT -4. The time now is 03:22 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy