Extracting data from SQL using a variable from a file

Tags
shell scripts

 
Thread Tools Search this Thread
# 1  
Old 10-27-2011
Extracting data from SQL using a variable from a file

Though, its not new, I am a newbie to shell scripting. Please help me with the below.

There are two steps.

First one is to read a table and create a file with the distinct values. I am able to get this done.

Second step is to read the file (which has the single value, like a number) and pass it as a variable to the sql with which I have to get that particular set of data to send an email.

I tried to create the script but could not create it without errors.

Can you please help me with a small sample of it so that I can use it to create it as per my requirement.


Thanks a lot for your time and information.
# 2  
Old 10-27-2011
So put the job you have done here, and the problem code, we can help to fix it.

|
Thread Tools Search this Thread
Search this Thread:
Advanced Search

More UNIX and Linux Forum Topics You Might Find Helpful
Need Help in extracting data from XML File vx04 Shell Programming and Scripting 7 12-23-2014 12:58 PM
Extracting data blocks from file newbie83 Shell Programming and Scripting 3 02-27-2012 06:27 PM
Extracting data from file slipshft UNIX for Dummies Questions & Answers 1 07-19-2011 10:33 AM
Need help in extracting data from xml file abhishek2386 Shell Programming and Scripting 6 07-16-2011 02:39 PM
Efficient way of extracting data from file akhay_ms UNIX for Dummies Questions & Answers 3 07-14-2011 02:16 PM
Extracting specific lines of data from a file and related lines of data based on a grep value range? Wynner Shell Programming and Scripting 3 05-18-2011 12:35 PM
Extracting data from an xml file Dolph UNIX for Dummies Questions & Answers 15 07-20-2010 04:20 AM
How to use sql data file in unix csv file as input to an sql query from shell Nareshp Shell Programming and Scripting 2 11-09-2009 02:15 AM
extracting data from a .csv file lassimanji Shell Programming and Scripting 3 05-07-2009 08:20 PM
Help in extracting data with command from file in C ahjiefreak Programming 10 03-21-2008 12:26 AM
Extracting Data from a File oop UNIX for Dummies Questions & Answers 0 07-31-2007 12:48 PM
Extracting Data from xml file nishana Shell Programming and Scripting 3 07-13-2007 08:17 AM
Extracting data from an AFP file Dolph UNIX for Advanced & Expert Users 4 05-22-2007 05:29 AM
how to assign sql output data to shell script variable kattics Shell Programming and Scripting 1 07-07-2006 04:57 PM
extracting recursive data file bbeugie UNIX for Dummies Questions & Answers 1 06-16-2004 06:48 AM