Hello people,
Need favour. The problem I have is that, I need to develop a unix shell script that performs recurring exports of data from a csv file to an oracle database. Basically, the csv file contains just the first name and last name will be dumped to an Unix server. The data from these... (3 Replies)
hi everyone, im new here and am in desperate need of help. I want to convert my 32 bit unix time stamp ' 45d732f6' into a readable format (Sat, 17 February 2007 16:53:10 UTC) using c++.
I have looked around the interent but i just cant make sense of anything. All examples i can find just... (3 Replies)
I am trying to connect to Oracle Databse from UNIX box using sqlplus command. But i get sqplus not found message.
$ sqlplus
sqlplus: not found
I have searched in forums and all are suggesting to set environment varaibles...can somebody tell me what variables to set and how to set.and the... (12 Replies)
Hi all
I am working in datawarehouse project and use DB2 database . shell scripting is written to connect with DB2 database in my application but i dont know how to connect with oracle databse or other databases.Is there any command in unix to connect any of these datbases? (6 Replies)
Hi,
the csv file with the delimeter #.
A#B#C#D#E#F#G#H
1#2#3#4#5#6#7#8
Z#x#c#V
7#2#8#9
N.
I want to read the file line by line and store in rowarray.
then the rowarray content should be spilt or made to fields using the delimeter #.
i am not sure can we store the fields in to... (3 Replies)
hi
I have two tables in oracle DB and am using a joining query which will result in the output as follows.
i need to assign it to a two dimensional array and use it for my further calculations.
the way i tried is as follows.
#!/bin/ksh
export... (1 Reply)
Hello everyone,
I am new to shell scripting/ loading data into a database.
I want to load data into Oracle database using SQL loader. Can some one please explain why do we need unix shell script to load the data into the database? Also can someone please explain what has to be in that script?... (5 Replies)
I need to run a SQL select query in Oracle database and have to capture the list of retrieved records in shell script. Also i would like to modify the query for certain condition and need to fetch it again. How can i do this?
Is there a way to have a persistent connection to oracle database... (9 Replies)
Hi, I want to find out the difference in minutes, and seconds between two dates for a job.Tried searching many ways but none of them worked correctly.
eg: Start Time End Time
04/10/2015 02:02:27 04/10/2015 02:02:37 ---- should return 10s
04/10/2015 02:02:27 04/10/2015... (1 Reply)
Discussion started by: rogerben
1 Replies
LEARN ABOUT DEBIAN
rotter
ROTTER(1)ROTTER(1)NAME
rotter - a recording of transmission / audio logger for JACK
SYNOPSIS
rotter [options] <directory>
DESCRIPTION
Rotter is a Recording of Transmission / Audio Logger for JACK. It was designed for use by radio stations, who are legally required to keep
a recording of all their output. Rotter runs continuously, writing to a new file every hour.
Rotter can output files in two different strutures, either all files in a single directory or create a directory structure:
flat: /root_directory/YYYY-MM-DD-HH.suffix
hierarchy: /root_directory/YYYY/MM/DD/HH/archive.suffix
combo: /root_directory/YYYY/MM/DD/HH/YYYY-MM-DD-HH.suffix
dailydir: /root_directory/YYYY-MM-DD/YYYY-MM-DD-HH.suffix
The advantage of using a folder hierarchy is that you can store related files in the hour's directory.
OPTIONS -a
Automatically connect JACK ports to the first two JACK input ports found.
-f <format>
Select the output format of the log files. See the rotter help screen for a list of supported output format names.
-b <bitrate>
Select the bitrate (in kbps) of the log file. This parameter is only supported by bitstream formats (MPEG Audio).
-c <channels>
Set the number of input channels to be logged. This number of JACK ports will be created. Should either 1 or 2.
-n <name>
Choose the name of the Jack client to register as.
-N <filename>
Choose a filename prefix for the archive files created (default archive).
-d <hours>
Specifies the number of hours of audio to keep before it is deleted. Files are deleted at the start of every hour, based on the files
modification date. Default is to not delete files.
-R <secs>
Sets the length (in seconds) of the ringbuffer. This is the buffer between the internal audio grabber and the audio encoder. If you
have a slow machine you might want to try increating the size of the buffer.
-L <layout>
Choose a file layout option for the archive files created. See above for a list.
-j
By default rotter will automatically try and start jackd if it isn't running. This option disables that feature.
-v
Enable verbose mode. Display more messages about what rotter is doing.
-q
Enable quiet mode. Only display error messages.
EXAMPLES
rotter -a -f mp3 -d 1000 -b 160 -v /var/achives
Start logging audio to hourly files in /var/archives. Rotter will automatically connect itself to the first two JACK output ports it finds
and encode to MPEG Layer 3 audio at 128kbps. Each hour it will delete files older than 1000 hours (42 days). Verbose mode means it will
display more informational messages.
AUTHOR
Written by Nicholas J Humfrey
RESOURCES
Web site: http://www.aelius.com/njh/rotter/
COPYING
Copyright (C) 2006-2007 Nicholas J Humfrey. Free use of this software is granted under the terms of the GNU General Public License (GPL).
10/03/2010 ROTTER(1)