Sponsored Content
Top Forums Shell Programming and Scripting read database tablename from another file Post 302512011 by mukeshguliao on Friday 8th of April 2011 06:35:13 AM
Old 04-08-2011
hmm...well thanks.. but this dont seem to solve the purpose

its like

abc.txt
Code:
 
emp
dept
table2

and there is script already there..

Code:
export ORAUSER=`grep ORAUSER $PROJECT_HOME/parms/.itracs_pass|cut -c9-`
export ORASCHEMA=`grep ORASCHEMA $PROJECT_HOME/parms/.itracs_pass|cut -c11-`
export ORAPSWD=`grep ORAPSWD $PROJECT_HOME/parms/.itracs_pass|cut -c9-`

#-- Execute the SQL
delete from test WHERE DATA_DT = ????;
commit;


this delete SQL command should pick value from that .txt file and run the query..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

PERL: Read from Database and copy

I have a microsoft access database with anout 220 lines. theres a question and 4 option awnsers and only ones correct which is also listed in th database. Is there any perl script that will copy and the lines from the database and put into a .asp website ? (2 Replies)
Discussion started by: perleo
2 Replies

2. UNIX for Dummies Questions & Answers

Read SQL database from Unix...

Hi there, I am new here and looking for a bit of help... I don't don't know much about Unix but I've tried to include as much info as possible. We currently operate our system as a bespoke on SCO 5.05 with Informix databases. This includes a financials package called "Multisoft". Both... (0 Replies)
Discussion started by: uptheposh
0 Replies

3. Shell Programming and Scripting

Pass tablename as a parameter in the Control File -- sqlldr

Just wanted to know if there is a way to pass the table name as a parameter in the control file. I have two tables...Table A and Table B. LOAD DATA append INTO TABLE TABLE_B FIELDS TERMINATED BY X'09' OPTIONALLY ENCLOSED BY '"' AND '"' TRAILING NULLCOLS Rather than hard coding... (1 Reply)
Discussion started by: madhunk
1 Replies

4. Shell Programming and Scripting

How to pass a date read from database to the shell script?

Hi i have a database table which i will query in a sqlplus session and it will either come back with a date or null? Now, what i want to do is based on the date returned i will either abort or continue with the script execution. I need to know is there a way other than spooling the date... (4 Replies)
Discussion started by: vinoo128
4 Replies

5. Shell Programming and Scripting

To Read a File and Insert a part of the lines into the database

Hi Guys I need to have a shell script which reads a log file and insert a part of each line into the database. Some sample lines in the file are as below. 20091112091359 MED_RQACK : user_data=60173054304,100232120,20091112091359,;ask_status=0;ask_reason=OK;msg_id=20091112091319... (5 Replies)
Discussion started by: Somanadh
5 Replies

6. Shell Programming and Scripting

Assigning value of a select count(*) from tablename ( run on db2 ) to a unix variable

Hi All, I have browsed through the forums for a similar topic, but there is no topic which explains about this problem, when the backend is DB2. I want to assign the output of a select count(*) from tablename to a unix variable in a shell script. I am using ksh. The database used to... (3 Replies)
Discussion started by: Siddarth
3 Replies

7. UNIX for Dummies Questions & Answers

When reading a csv file, counter to read 20 lines and wait for minute then read next 20 till end

Hello All, i am a newbie and need some help when reading a csv file in a bourne shell script. I want to read 10 lines, then wait for a minute and then do a reading of another 10 lines and so on in the same way. I want to do this till the end of file. Any inputs are appreciated ... (3 Replies)
Discussion started by: victor.s
3 Replies

8. Shell Programming and Scripting

How to read a text file line by line and insert into a database table?

I have a test file that I want to read and insert only certain lines into the the table based on a filter. 1. Rread the log file 12 Hours back Getdate() -12 Hours 2. Extract the following information on for lines that say "DUMP is complete" A. Date B. Database Name C.... (2 Replies)
Discussion started by: JolietJake
2 Replies

9. Shell Programming and Scripting

Read latest log files and perform database insert

Hi Experts, I have a situation where I need to write a shell script to continuously monitor a log directory with multiple log files and perform following: 1. Read the latest log file continuously and grep "Success" OR "Failure" 2. As it capture either Success or Failure, it has to perform a... (1 Reply)
Discussion started by: rish_max
1 Replies

10. UNIX for Beginners Questions & Answers

Creating script to read many files and load into database via single control file

Hi, I have many files but with only 2 names , I want to load the data of that file into database through sqlldr with single control file. how can i do that ????? Example: switch_file switch_file billing_file billing_file now these files should be loaded into same database but different... (1 Reply)
Discussion started by: niti_sharma
1 Replies
MP4TRACK(1)							  MP4v2 Utilities						       MP4TRACK(1)

NAME
mp4track - manual page for mp4track - MP4v2 2.0.0 SYNOPSIS
mp4track [OPTION]... [PARAMETERS]... ACTION file... DESCRIPTION
For each mp4 file specified, perform the specified ACTION. An action must be specified. Some options are not applicable to some actions. ACTIONS --list list all tracks in mp4 --enabled BOOL set trak.tkhd.flags (enabled bit) --inmovie BOOL set trak.tkhd.flags (inMovie bit) --inpreview BOOL set trak.tkhd.flags (inPreview bit) --layer NUM set trak.tkhd.layer --altgroup NUM set trak.tkhd.alternate_group --volume FLOAT set trak.tkhd.volume --width FLOAT set trak.tkhd.width --height FLOAT set trak.tkhd.height --language CODE set trak.mdia.mdhd.language --hdlrname STR set trak.mdia.hdlr.name --udtaname STR set trak.udta.name.value --udtaname-remove remove trak.udta.name atom --colr-list list all colr-boxes in mp4 --colr-add add colr-box to a video track --colr-set set colr-box parms --colr-remove remove colr-box from track --pasp-list list all pasp-boxes in mp4 --pasp-add add pasp-box to a video track --pasp-set set pasp-box parms --pasp-remove remove pasp-box from track PARAMETERS --track-any act on any/all tracks --track-index IDX act on track index IDX --track-id ID act on track id ID --colr-parms CSV where CSV is IDX1,IDX2,IDX3 --colr-parm-hd equivalent to --colr-parms=1,1,1 --colr-parm-sd equivalent to --colr-parms=6,1,6 --pasp-parms CSV where CSV is hSPACING,vSPACING OPTIONS -z, --optimize optimize mp4 file after modification -y, --dryrun do not actually create or modify any files -k, --keepgoing continue batch processing even after errors -o, --overwrite overwrite existing files when creating -f, --force force overwrite even if file is read-only -q, --quiet equivalent to --verbose 0 -d, --debug NUM increase debug or long-option to set NUM -v, --verbose NUM increase verbosity or long-option to set NUM -h, --help print brief help or long-option for extended help --version print version information and exit DEBUG LEVELS (for raw mp4 file I/O) 0 supressed 1 add warnings and errors (default) 2 add table details 3 add implicits 4 everything VERBOSE LEVELS 0 warnings and errors 1 normal informative messages (default) 2 more informative messages 3 everything mp4track - MP4v2 2.0.0 June 2012 MP4TRACK(1)
All times are GMT -4. The time now is 09:06 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy