Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Need script to pass all sql file names in a directory to DB query
Top Forums Shell Programming and Scripting Need script to pass all sql file names in a directory to DB query Post 302973519 by Don Cragun on Wednesday 18th of May 2016 09:51:31 AM
Old 05-18-2016
Moderator's Comments:
Mod Comment We are not here to act as your personal programming staff.
Repeatedly bumping up your posts with "help me" messages is against forum rules and with three active infractions for bumping up posts and an active 3rd infraction for not using CODE tags correctly, this account is in read-only mode for three days.

Please take this time to review the rules you agreed to when you joined this forum.

If you continue ignoring the rules in the future, you may be banned from this site permanently.


What output does the command:
Code:
sqlplus -s $DB_CONNECTION/$PASS_WORD << EOF
	  
	          set termout off;
              set verify off;
              set feedback off;
              set heading off;
              set newpage 0;
              set pagesize 0;
              set linesize 200;
              SELECT  SUBSTR(trunk_path,3,INSTR(trunk_path,'sql')),new_file_name FROM directory_map
              WHERE object_name=SUBSTR(UPPER('$1'),1,INSTR(UPPER('$1'),'.')-1);
              exit success;
EOF

produce? Is it one line with a space or tab between the selected part of the trunk_path and the new_file_name; or do those values appear on separate lines?

Does the output contain any quoting characters around the strings produced?

What operating system and shell are you using? On many shells, the script you showed us would generate a syntax error for an unterminated here-document.

Did you get any diagnostic messages when you ran the script you showed us in post #5?

What command line did you use to invoke your script?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

TO execute .sql 2005 query file in shell script

Hi, I know in oracle a .sql file is called by @ <path> /<filename>. But how to call in sql 2005, I am opening the sql sessionwith sqsh, is there any command to execute there a .sql file (query in sql 2005) in K shell script. (0 Replies)
Discussion started by: n2ekhil
0 Replies

2. 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

3. Programming

JDBC code to pass the SQL query as parameter and execute?

Below i have the sample code. i need to pass the entire query from file or as parameter and read the results and write into a output file. here the number of columns are unknown. some times it may be 2,3 or entire columns from the table. read all the column results and write into a comma... (0 Replies)
Discussion started by: laknar
0 Replies

4. Shell Programming and Scripting

Need help to run sql query from a script..which takes input from a file

I need to run sql script from shell script which takes the input from a file and contents of file will be like : 12345 34567 78657 and query will be like : select seq_nbr from bus_event where event_nbr='12345'; select seq_nbr from bus_event where event_nbr='34567'; select seq_nbr... (1 Reply)
Discussion started by: rkrish
1 Replies

5. 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

6. Shell Programming and Scripting

SQL query in UNIX script - output in flat file

Hi, I never did this before... what I want to do is execute a SQL query from a unix script and redirect sql query's output to a flat file (comma separated one) without the header info (no column names). I would also want not to print the query's output to the screen. snapshot of my script:... (13 Replies)
Discussion started by: juzz4fun
13 Replies

7. Shell Programming and Scripting

How to pass an array containing file names to a sftp script?

hi, i want to pass an array parameters to a sftp script so that i can transfer each file in the array to the remote server by connecting only once to the sftp remote server. i thought of using a variable that contains list of file names separated by a space and pass the variable to the sftp... (3 Replies)
Discussion started by: Little
3 Replies

8. Shell Programming and Scripting

How to pass string into sql query?

Hi Gurus, I have a request which needs to pass string into sql. dummy code as below: sqlplus -s user/password@instance << EOF >>output.txt set echo off head off feed off pagesize 0 trimspool on linesize 1000 colsep , select emp_no, emp_name from emp where emp_no in ('a', 'b', 'c'); exit;... (4 Replies)
Discussion started by: ken6503
4 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. UNIX for Beginners Questions & Answers

Not able to write SQL query output in to .csv file with shell script.

I am trying to write SQL query output into a .csv file. But in the output columns are displaying in different lines instead of coming in one line. Main Code shell script: this is my code: #!/bin/bash file="db_detail.txt" . $file rm /batch/corpplan/bin/dan.csv... (6 Replies)
Discussion started by: sandeepgoli53
6 Replies

LEARN ABOUT REDHAT

forum

FORUM(1)							       mrtg								  FORUM(1)

NAME

       forum - Interactive Help for MRTG users

SYNOPSIS

       There is a lot of written documentation for mrtg. But never the less you may have a problem where you can't find the solution.  In this
       case some Human Help may be necessary. With MRTG there are several ways to get Humans to help you.

MAILING-LIST
       There are three mailing lists for MRTG available.

       mrtg
	   for discussion among mrtg users

       mrtg-announce
	   for announcements regarding new versions of mrtg related software

       mrtg-developers
	   for discussion among people who write software in connection with mrtg or who hack mrtg itself.

       THE RULES

       Please note, that the memebers of the mrtg mailinglist value politeness highly. This means behave in a way you would like others to behave
       towards you.

       o   No shouting. (NO CAPS)

       o   No rude language

       o   No demands. everybody is on the list out of their own free will. If you do not get an answer to your question, chances are high that
	   you did not give sufficent details about the nature of your problem or that the answer to your problem is in the documentation.

       o   If you do not follow the rules you will be unsubscribed from the list with no further questions asked.

       o   Decisions about your unsubscription from the list will be taken by

	    Alex van den Bogaerdt <alex@slot.hollandcasino.nl>
	    Paul C. Williamson	  <pwilliamson@MANDTBANK.COM>

	   If you feel that you have been treated unfairly, you may send mail to me and explain the situation.

	    Tobi Oetiker <oetiker@ee.ethz.ch>

       SUBSCRIBING

       These lists are managed by a mailing-list management software (listar).	It allows you to subscribe to these lists by sending a message
       with the subject: subscribe to the following address:

	listname-request@list.ee.ethz.ch

       You will then get a message asking you to confirm your subscription.

       For posting to the lists use the following address

	listname@list.ee.ethz.ch

       Note that only people who are subscribed to the list can post.

       Further information about the usage of the mailing lists is available by sending a message with the subject line help to either one of the
       request addresses.

       For past activity there is also a mailing list archive available:

	http://www.ee.ethz.ch/~slist/mrtg

       There is also a web interface to manage your mailing-list subscription.

	http://www.ee.ethz.ch/~slist/lsg2.cgi

NEWSGROUP

       For discussion of MRTG or related topics on the Usenet, please send your posts to:

	news:comp.dcom.net-management

       Many MRTG users are in this forum and will help you. You can also find an archive of past activity from this Newsgroup on:

	http://www.deja.com/usenet

AUTHOR

       Tobias Oetiker <oetiker@ee.ethz.ch> and many contributors

3rd Berkeley Distribution					      2.9.17								  FORUM(1)
All times are GMT -4. The time now is 01:14 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy