07-26-2010
Hi,
Yes. Query is very much correct.
could anyone pls provide the resolution at the earliest........
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I know htis isnt exactly unix.... but hopefully someone can help me or direct me someplace to get help.
I can run sql queries in scripts against my informix db using:
dbaccess mydb myquery.sql >> sql.output
I need to write my script to select based on todays date. Its very... (5 Replies)
Discussion started by: MizzGail
5 Replies
2. UNIX for Advanced & Expert Users
Hi Folks,
This is a small chunk of the bigger problem which i am facing and some help here will help me resolve the rest of the issue.
Problem is that i need to pass the value of a variable from a shell script to a SQL query (infact a lot of SQL's)
i have the following solution but somehow... (4 Replies)
Discussion started by: kamitsin
4 Replies
3. Shell Programming and Scripting
I created a script to read a csv file with four columns. The script also saved values of each col in a arry.
In the script, i connected to db try to run a query to pull out data baisc on the values from the csv file.
select Num from tableName
where Sec_Num in ('${isin}') /*isin is an arry... (1 Reply)
Discussion started by: Sherry_Run
1 Replies
4. Shell Programming and Scripting
Unix prompt
=========
echo "Enter the query"
read q
==========
User has entered :
SELECT * FROM employee
=====================
Now the problem starts..
echo $q
Output: SELECT "all files names in the PWD" FROM employee
================================================
... (5 Replies)
Discussion started by: Niroj
5 Replies
5. Shell Programming and Scripting
I have a script (say script1.sh ) and I am calling a script (say script2.sh) within the script1.sh. Here in script1.sh I have a hash ( say %hash1) and i have to pass this hash to script2.sh. Basically i have to do some processing in Scirpt2.sh based on the hash(key,values). I wanted to know how can... (2 Replies)
Discussion started by: ammu
2 Replies
6. Shell Programming and Scripting
I heard this was possible but from my research I haven't been able to figure it out yet. Seems it should be simple enough. Basically from a high level view I'm trying to accomplish...
. $X='grep foo blah.log'
then 'mysql command SELECT foo FROM bar WHERE ' . $X
or something like that.
... (2 Replies)
Discussion started by: kero
2 Replies
7. Shell Programming and Scripting
hi there
I have the following script in which i have created a PrintHash() function.
I want to pass to this function the reference to a hash (in the final code i will be passing different hashes to this print function hence the need for a function). I am getting an error
Type of arg 1 to... (1 Reply)
Discussion started by: hcclnoodles
1 Replies
8. Shell Programming and Scripting
How to pass variable to sql file.
Im tryin in two ways,
Method 1:
my.sql
select * from table where col1 = '$1' and col2 = 'text';
Method 1execute: dbaccess database my.sql $var
Method2:
select * from table col1 in (`cat inputfile`) and col2 = 'text';
method... (2 Replies)
Discussion started by: Roozo
2 Replies
9. Shell Programming and Scripting
I have a script in which i connect to database to run a query and get the result of the query to a temp file. This works fine , now what i want is there is flat file which contains the value to be used in the query. I want to read this file line by line and then run the query for each value in that... (7 Replies)
Discussion started by: gpk_newbie
7 Replies
10. Shell Programming and Scripting
Hi,
I have created a shell script that reads line from text file and insert into DB table. I have used IFS to separate the line text. Looks IFS is splitting text properly but while passing one of the values that has special characters in it to query, it is giving weird issue. Below is my... (2 Replies)
Discussion started by: yuvi
2 Replies
LEARN ABOUT HPUX
icecream
ICECREAM(1) icecream ICECREAM(1)
NAME
icecream - download icecast and shoutcast streams, redirecting all fetched content to stdout and/or to disk at the same time
SYNOPSIS
icecream [OPTIONS] URL [URL..]
DESCRIPTION
icecream is a lightweight, non-interactive, stream download utility. It connects to icecast and shoutcast servers or direct stream URLs,
and redirects all fetched content to stdout and/or to media files on your disk.
Listen to the stream piping the output to a stdin-capable media player. Save the stream to a named file or split it into different tracks.
It is possible to redirect the stream and save it to disk at the same time.
icecream is able to parse pls and m3u playlists, and to download mp3 and ogg direct stream URLs. If the stream is anonymous it will be
saved as 'stream-time.mp3', where time is actual timestamp.
OPTIONS
-h, --help
Print a help message describing all options
-q, --quiet
Turn off output
-v, --verbose
Be verbose
-t, --tracks
Split stream into tracks (if possible)
--name=NAME
Save the stream to file specified by NAME. Format codes starting with "%" will be replaced. See the date command for valid format
codes.
--stop=N[units]
Stop downloading the stream after N kb/mb/min/songs
--user-agent=AGENT
Set user-agent header to AGENT
--stdout
Output stream to stdout (implies -q)
--sync Turn syncing on, required for some mpeg players that read from stdin
--debug Turn on debugging outputs
EXAMPLES
Streaming to mpg123
icecream --stdout http://radio.com/playlist.pls | mpg123 -
Split stream into different tracks
icecream -t http://metal.org/radio.pls
Split stream into tracks and play with vlc at the same time
icecream -t --stdout http://streaming.com/playlist.pls | vlc file:/dev/stdin
Prepare a 74 minute CD
icecream -t --stop 74min http://trace.net/playlist.m3u
Use a filename with today's date as output
icecream -q --name 'radio_%Y_%m_%d' --stop 60min http://radio.com/playlist.pls
BUGS
You are welcome to send bug reports about icecream to our mailing list. Feel free to visit http://icecream.sourceforge.net
AUTHOR
Written by Gil Megidish <gil at megidish.net>
1.3 2008-04-28 ICECREAM(1)