SQL and shell scripts Post: 302086445

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers SQL and shell scripts Post 302086445 by Amruta Pitkar on Thursday 24th of August 2006 02:48:08 AM

08-24-2006

Registered User

Why empty variables when executing SQL statements ?

Hi there

I have modified the above code to

Code:

#####Connecting sqlplus to check the connectivity
sqlplus -s /nolog <<EOF>/dev/null
connect ${DB_LOGIN}/${DB_PASSWORD}@${DB_NAME}
cat /home/ampi/EnablementProject/MyWorkSpace/emails/$FILENAME | while read LINE
do
    echo ${LINE}
    acctno=`echo $LINE | cut -f1 -d','`
    echo $acctno
    salutation=`echo $LINE | cut -f2 -d','`
    name=`echo $LINE | cut -f3 -d','`
    billdate=`echo $LINE | cut -f4 -d','`
    totaldue=`echo $LINE | cut -f5 -d','`
    billdeductiondate=`echo $LINE | cut -f6 -d','`
    billduedate=`echo $LINE | cut -f7 -d','`
    templatecode=`echo $LINE | cut -f8 -d','`
    billid=`echo $LINE | cut -f9 -d','`
    emailid=`echo $LINE | cut -f10 -d','`
    brnno=`echo $LINE | cut -f11 -d','`
    billsummaryid=`echo $LINE | cut -f12 -d','`
    batchno=`echo $LINE | cut -f13 -d','`
    emailfile=`echo $LINE | cut -f16 -d','`
    echo "Insert into table"
    spool ${SYS_TEMP_DIR}/${JOB_ID}_db_sql.log
    INSERT INTO SendMailDetails (acctno) values ('${acctno}');
    echo "Table Appended"
done
commit;
spool off;
exit;
EOF

The do..while loop when executed without the SQL statement reads the input filecorrectly and also stores values into the variables. but when I include SQL statements in the loop...no values are read ...Variables are blank...why ?

Amruta Pitkar

Amruta Pitkar

View Public Profile for Amruta Pitkar

Find all posts by Amruta Pitkar

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help with GDL to SQL scripts

Hi to everyone, i want ask if someone knows about a script/program to convert the .gdl (Interbase) to .sql scripts. I wrote a little script to make it but it's very very simple, and the triggers and some code from .gdl are so difficult to me. If somebody could help me, I would very thankful. ...

2. Shell Programming and Scripting

Calling SQL scripts through Shell Script

Oracle and Scripting gurus, I need some help with this script... I am trying to add the query SELECT * FROM ALL_SYNONYMS WHERE SYNONYM_NAME = 'METADATA' in the current script.... Read the result set and look for the TABLE_NAME field. If the field is pointing to one table eg....

3. Shell Programming and Scripting

Running SQL Scripts from Shell script - Need insight!

I've a script that fetches various values from the database as below: #! /bin/ksh $conn="user/pwd@service_name" `sqlplus -s << $conn EOF1 @xyz.sql @pqr.sql @abc.sql EOF1` The output of the script should generate txt files containing the results from queries which are further...

4. Shell Programming and Scripting

Calling SQL LDR and SQL plus scripts in a shell script

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

any possible solution on sql calling scripts

hi all, i have a function which will take i/p as a ddl sctipt as i/p and execute it, let function execute_sql { db_var="$1" v_cnt=`sqlplus -s XXXXX/XXXXX@aXXX << ENDSQL | sed -e "s/Connected\.//" -e "/^$/d" set pagesize 0 feedback off verify off heading off echo off serveroutput on size...

6. Shell Programming and Scripting

Not able to execute many SQL scripts within a shell script

I am using HP-UX: I have written a ksh script where I need to connect to sqlplus and execute few sql scripts. Part of this code is - sqlplus user/temp1234 <<! set serverout on set feedback off set pages 1000 set colsep , set echo off spool /home/supp1/pks/output.csv...

7. Shell Programming and Scripting

Execute multiple SQL scripts from single SQL Plus connection

Hi! I would like to do a single connection to sqlplus and execute some querys. Actually I do for every query one connection to database i.e echo 'select STATUS from v$instance; exit' > $SQL_FILE sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT echo 'select VERSION from v$instance;...

8. UNIX for Advanced & Expert Users

Call parallel sql scripts from shell and return status when both sql are done

Hi Experts: I have a shell script that's kicked off by cron. Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing...

9. UNIX and Linux Applications

how to execute multiple .sql scripts from within a shell script using sqlplus

using sqlplus I want to execute a .sql script that has dbms_output statments in rhe script. I want to write the dbms_output statements from .sql file to a log file. is this possible. thanks any help would be appreciated :wall:

10. Shell Programming and Scripting

Issue in SQL Loader scripts

LEARN ABOUT PHP

mongodbdrivermanager.__construct

MONGODBDRIVERMANAGER.__CONSTRUCT(3)					 1				       MONGODBDRIVERMANAGER.__CONSTRUCT(3)

MongoDBnager::__construct - Create new MongoDB Manager

SYNOPSIS

       finalpublic MongoDBDriverManager::__construct (string	$uri, [array  $options], [array  $driverOptions])

DESCRIPTION

	Constructs a new MongoDBDriverManager object with the specified options.

PARAMETERS

	      o $uri
		- A mongodb:// connection URI:

	      mongodb://[username:password@]host1[:port1][,host2[:port2],...[,hostN[:portN]]][/[database][?options]]

	      o $options
		-Connection string options.

	      Note

		      Specifying options via the $options argument will overwrite any options with the same name in the $uri argument.

	      o $driverOptions
		- Any driver-specific options not included in MongoDB connection spec.

ERRORS
/EXCEPTIONS
	      oThrows InvalidArgumentException on argument parsing errors.

	      oThrows MongoDBDriverRuntimeException if the $uri format is invalid

EXAMPLES

       Example #1

	      MongoDBDriverManager.__construct(3) basic examples

	      Connecting to standalone MongoDB node

	      <?php

	      $manager = new MongoDBDriverManager("mongodb://localhost:27017");

	      ?>

	      Connecting to a replica set

	      <?php

	      $manager = new MongoDBDriverManager("mongodb://rs1.example.com,rs2.example.com/?replicaSet=myReplicaSet");

	      ?>

	      Connecting to a sharded cluster (i.e. one or more mongos instances)

	      <?php

	      $manager = new MongoDBDriverManager("mongodb://mongos1.example.com,mongos2.example.com/");

	      ?>

	      Connecting to MongoDB with authentication credentials for a particular user and database.

	      <?php

	      $manager = new MongoDBDriverManager("mongodb://myusername:mypassword@localhost:27017/mydatabase");

	      ?>

SEE ALSO

       MongoDBDriverServer::__construct, "Chapter#2 Connecting to MongoDB", Connection string URI format.

PHP Documentation Group 										       MONGODBDRIVERMANAGER.__CONSTRUCT(3)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help with GDL to SQL scripts

Discussion started by: ch4r1e5

2. Shell Programming and Scripting

Calling SQL scripts through Shell Script

Discussion started by: madhunk

3. Shell Programming and Scripting

Running SQL Scripts from Shell script - Need insight!

Discussion started by: manthasirisha

4. Shell Programming and Scripting

Calling SQL LDR and SQL plus scripts in a shell script

Discussion started by: rajagavini