Sponsored Content
Top Forums Shell Programming and Scripting how to use data in unix text file as input to an sql query from shell Post 302330393 by jayan_jay on Wednesday 1st of July 2009 06:05:49 AM
Old 07-01-2009
Try this...
for i in `cat textfile`
do
sh <dbscript-name> "$line"
done

coding for dbscript:
--------------------
sqlplus -s '<user-name>/<password>' > /dev/null << EOF
exec <your own DB process command>('$1');
commit;
EOF

Last edited by jayan_jay; 07-01-2009 at 07:11 AM..
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

sql query results in unix shell script

Hi I want to get the a field from a SQL query into unix shell script variable. the whole situation is like this. 1. Opened a cursor to a table in DB2 databse. 2. Fetching individual rows with the help of cursor. 3. Each row has 4 fields. I want each of the field in individual shell... (1 Reply)
Discussion started by: skyineyes
1 Replies

2. UNIX for Dummies Questions & Answers

How do I use SQL to query based off file data?

This is basically what I want to do: I have a file that contains single lines of IDs. I want to query the oracle database using these IDs to get a count of which ones match a certain condition. the basic idea is: cat myfile | while read id do $id in select count(PC.ptcpnt_id) from... (4 Replies)
Discussion started by: whoknows
4 Replies

3. Shell Programming and Scripting

How to use sql data file in unix csv file as input to an sql query from shell

Hi , I used the below script to get the sql data into csv file using unix scripting. I m getting the output into an output file but the output file is not displayed in a separe columns . #!/bin/ksh export FILE_PATH=/maav/home/xyz/abc/ rm $FILE_PATH/sample.csv sqlplus -s... (2 Replies)
Discussion started by: Nareshp
2 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. Shell Programming and Scripting

Shell Script to execute Oracle query taking input from a file to form query

Hi, I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database. For instance: USER CITY --------- ---------- A CITY_A B CITY_B C ... (2 Replies)
Discussion started by: DevendraG
2 Replies

6. Shell Programming and Scripting

How can i run sql queries from UNIX shell script and retrieve data into text docs of UNIX?

Please share the doc asap as very urgently required. (1 Reply)
Discussion started by: 24ajay
1 Replies

7. Shell Programming and Scripting

Shell scripting unable to send the sql query data in table in body of email

I have written a shell script that calls below sql file. It is not sending the query data in table in the body of email. spool table_update.html; SELECT * FROM PROCESS_LOG_STATS where process = 'ActivateSubscription'; spool off; exit; Please use code tags next time for your code and data.... (9 Replies)
Discussion started by: Sharanakumar
9 Replies

8. Shell Programming and Scripting

Read input file and used it to SQL query

Hi All, Seeking for your assistance to read each line $1 and $2 of input file and used it to query. Ex. file1.txt(number range) 9064500000 9064599999 9064600000 9064699999 9064700000 9064799999 Database name: ranges_log a_no message 9064500001 test 9064700000 ... (7 Replies)
Discussion started by: znesotomayor
7 Replies

9. UNIX for Dummies Questions & Answers

Inserting shell script input data automatically from a text file

Dear experts, I am new to linux programming. I have a shell script which i should run it on all my samples. I only define input and out put for this script. The inputs are 3 numbers(coordination numbers) which are available in a series of text file. Since i have a lots of samples, it takes a... (5 Replies)
Discussion started by: mohamadreza
5 Replies

10. Shell Programming and Scripting

Run sql query in shell script and output data save as delimited text

I want to run sql query in shell script and output data save as delimited text (delimited text would be comma) Code: SPOOL_FILE=/pgedw/dan.txt SQL=/pgedw/dan.sql sqlplus -s username/password@myhost:port/servicename <<EOF set head on set COLSEP , set linesize 32767 SET TRIMSPOOL ON SET... (8 Replies)
Discussion started by: Jaganjag
8 Replies
cat(1)							      General Commands Manual							    cat(1)

NAME
cat - Concatenates or displays files SYNOPSIS
cat [-benrstuv] file... | - The cat command reads each specified file in sequence and writes it to standard output. STANDARDS
Interfaces documented on this reference page conform to industry standards as follows: cat: XCU5.0 Refer to the standards(5) reference page for more information about industry standards and associated tags. OPTIONS
[Tru64 UNIX] Omits line numbers from blank lines when -n is specified. If you specify the -b option, the -n option is automatically invoked with it. [Tru64 UNIX] Same as the -v option with a $ (dollar sign) character displayed at the end of each line. [Tru64 UNIX] Displays output lines preceded by line numbers, numbered sequentially from 1. [Tru64 UNIX] Replaces multiple consecutive empty lines with one empty line, so that there is never more than one empty line between lines containing characters. [Tru64 UNIX] Does not display a message if cat cannot find an input file. (Silent option.) [Tru64 UNIX] Same as the -v option, with the tab character printed as <Ctrl-i> (^I). Does not buffer output. Writes bytes from the input file to standard output without delay as each is read. [Tru64 UNIX] Displays nonprinting characters so that they are visible. OPERANDS
The name of the file to be displayed. If you do not specify a file or if you specify - (dash) instead of file, cat reads from standard input. The cat command accepts mul- tiple occurrences of - (dash) as a file argument. DESCRIPTION
[Tru64 UNIX] The cat command is frequently used with > (redirection symbol) to concatenate the specified files and write them to the spec- ified destination. (See CAUTIONS.) The cat command is also used with >> to append a file to another file. CAUTIONS
Do not redirect output to one of the input files using the > (redirection symbol). If you do this, you lose the original data in the input file because the shell truncates it before cat can read it. (See also the sh command.) EXIT STATUS
The following exit values are returned: Successful completion. An error occurred. EXAMPLES
To display the file notes, enter: cat notes If the file is longer than one screenful, it scrolls by too quickly to read. To display a file one page at a time, use the more com- mand. To concatenate several files, enter: cat section1.1 section1.2 section1.3 > section1 This creates a file named section1 that is a copy of section1.1 followed by section1.2 and section1.3. To suppress error messages about files that do not exist, enter: cat -s section2.1 section2.2 section2.3 > section2 If section2.1 does not exist, this command concatenates section2.2 and section2.3. Note that the message goes to standard error, so it does not appear in the output file. The result is the same if you do not use the -s option, except that cat displays the error message: cat: cannot open section2.1 You may want to suppress this message with the -s option when you use the cat command in shell procedures. To append one file to the end of another, enter: cat section1.4 >> section1 The >> in this command specifies that a copy of section1.4 be added to the end of section1. If you want to replace the file, use a single > symbol. To add text to the end of a file, enter: cat >> notes Get milk on the way home <Ctrl-d> Get milk on the way home is added to the end of notes. With this syntax, the cat command does not display a prompt; it waits for you to enter text. Press the End-of-File key sequence (<Ctrl-d> above) to indicate you are finished. To concatenate several files with text entered from the keyboard, enter: cat section3.1 - section3.3 > section3 This concatenates section3.1, text from the keyboard, and section3.3 to create the file section3. To concatenate several files with output from another command, enter: ls | cat section4.1 - > section4 This copies section4.1, and then the output of the ls command to the file section4. To get two pieces of input from the terminal (when standard input is a terminal) with a single command invocation, enter: cat start - middle - end > file1 If standard input is a regular file, however, the preceding command is equivalent to the following: cat start - middle /dev/null end > file1 This is because the entire contents of the file would be consumed by cat the first time it saw - (dash) as a file argument. An End- of-File condition would then be detected immediately when - (dash) appeared the second time. ENVIRONMENT VARIABLES
The following environment variables affect the execution of cat: Provides a default value for the internationalization variables that are unset or null. If LANG is unset or null, the corresponding value from the default locale is used. If any of the internationalization vari- ables contain an invalid setting, the utility behaves as if none of the variables had been defined. If set to a non-empty string value, overrides the values of all the other internationalization variables. Determines the locale for the interpretation of sequences of bytes of text data as characters (for example, single-byte as opposed to multibyte characters in arguments). Determines the locale for the for- mat and contents of diagnostic messages written to standard error. Determines the location of message catalogues for the processing of LC_MESSAGES. SEE ALSO
Commands: more(1), ksh(1), pack(1), pg(1), pr(1), Bourne shell sh(1b), POSIX shell sh(1p) Standards: standards(5) cat(1)
All times are GMT -4. The time now is 10:30 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy