|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Reuse Variable..
Post 302401812 by aimy on Monday 8th of March 2010 02:37:32 AM
03-08-2010
Thank you very much anchal khare and abubacker for your prompt response.
Really appreciate.
To make it clear.. This is my original objective:
In other words, I'm gonna repeat that sqlldr command for another 3 CVs..
Since, the filename only distinctive by that CV.. That's why I don't want to issue that filename command again and again.
Thank you.
---------- Post updated at 03:37 PM ---------- Previous update was at 03:33 PM ----------
So, is that the only way to achive this i.e. by creating function?
I don't know it could be that difficult..
I thought I only need to change something so that the $filename would reflect the current value of $cv.
Why can't it anyway? Anyone?
Really appreciate.
To make it clear.. This is my original objective:
Quote:
job_name="$(echo "load_didrnge.sh")"
table_name="$(echo "DIDRNGE")"
cv="$(echo "CV000")"
cv="$(print 'CV09')"
file_name=`CP99978_`$cv`.TXT`
file_name="$(awk '{print $1}' $cv )"
log=/tmw/oradata14/monthly_log/CP99978_$cv.log
sqlldr crispadm/admcrisp data=/tmw/oradata14/CP99978_CV001.TXT control=/home/oracle9/dba_area/adslmpr.ctl log=/tmw/oradata14/monthly_log/CP99978_CV001.TXT.log \
bad=/tmw/oradata14/monthly_log/CP99978_CV001.TXT.bad errors=5000000 skip=1
set cv="$(echo "CV001")"
/home/oracle9/dba_area/general/PROCEDURE_TRACKING_LOG.sql "$job_name" "$file_name" "$table_name" "$log"
table_name="$(echo "DIDRNGE")"
cv="$(echo "CV000")"
cv="$(print 'CV09')"
file_name=`CP99978_`$cv`.TXT`
file_name="$(awk '{print $1}' $cv )"
log=/tmw/oradata14/monthly_log/CP99978_$cv.log
sqlldr crispadm/admcrisp data=/tmw/oradata14/CP99978_CV001.TXT control=/home/oracle9/dba_area/adslmpr.ctl log=/tmw/oradata14/monthly_log/CP99978_CV001.TXT.log \
bad=/tmw/oradata14/monthly_log/CP99978_CV001.TXT.bad errors=5000000 skip=1
set cv="$(echo "CV001")"
/home/oracle9/dba_area/general/PROCEDURE_TRACKING_LOG.sql "$job_name" "$file_name" "$table_name" "$log"
Since, the filename only distinctive by that CV.. That's why I don't want to issue that filename command again and again.
Thank you.
---------- Post updated at 03:37 PM ---------- Previous update was at 03:33 PM ----------
So, is that the only way to achive this i.e. by creating function?
I don't know it could be that difficult..
I thought I only need to change something so that the $filename would reflect the current value of $cv.
Why can't it anyway? Anyone?
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I am working on device drivers.Once If register a device i'll get one major no. If i unregister and register again i'll get a different major no.What i have to do to get same major no. each time :( (0 Replies)
Discussion started by: Agnello
0 Replies
2. UNIX for Advanced & Expert Users
Does anyone know of a password reuse utility for Solaris 7 or 8? Security people are telling me that I need one.
Thanks (1 Reply)
Discussion started by: rtoba
1 Replies
3. HP-UX
Hello, I have 2 hp-ux both running 11.23, I have move one of a harddisk from "UNIX A" to "UNIX B", so how can I read back the data in "UNIX B"?
Thanks (5 Replies)
Discussion started by: zetadhell
5 Replies
4. Linux
hi
can you all help me to develop anything in unix that could be reused.
any module or application could be helpful (0 Replies)
Discussion started by: infyanurag
0 Replies
5. UNIX for Dummies Questions & Answers
I'm currently using zsh. Sometimes I find myself wishing to reuse an argument from earlier in the command.
I know that I can, of course, assign an argument to a variable ahead of time, and then easily use that variable more than once.
I know about the ability to reuse arguments from previous... (0 Replies)
Discussion started by: marshaul
0 Replies
6. Shell Programming and Scripting
Hello everyone.
I'm trying to create a conf file with variables that my other scripts will use.
I have several scripts that use the same variables, and since I don't know how to read them from an external file, i define them in each script (and then if i want to change one's value i need to... (4 Replies)
Discussion started by: moshe88
4 Replies
7. Emergency UNIX and Linux Support
I have a LUN (From HP-Storage VA7110) that is claimed on 2 servers, but is in used in one of the VG on Server-1 .
Now I want to shut Server-1 and re-use that LUN on server-2 .
Server-1
Path-1 : /dev/rdsk/c4t0d1
Path-2: /dev/rdsk/c6t0d1
Server-2
Path-1: /dev/rdsk/c5t0d1
Path-2:... (8 Replies)
Discussion started by: Shirishlnx
8 Replies
8. Shell Programming and Scripting
Hi
I am trying to write a shell script and wanted to re-use the value which I have entered already.
Here is the sample code.
echo "Enter Value : \c" ; read val
echo "Enter number: $val\c" ; read num
Now I wanted to change the value as showing in 2nd Line or if I will use enter, it... (15 Replies)
Discussion started by: SushilAnand
15 Replies
9. Solaris
Greetings.
First of all I consider myself a newbe in Linux, that's why I'm seeking your help so please be patient!
I was given an old server (Solaris) that has Oracle (10.2.0) installed with a few databases. I'm supposed to reuse this server for this new application which will process data... (11 Replies)
Discussion started by: RedSpyder
11 Replies
10. Programming
I have a collection of format strings for sscanf, such as
"%02d%*1s%02d%*1s%02d"
to read in certain formatted strings, such as dates, times, etc.
I wonder if there is a way to use them in printf without some changes? The example above would not work - at least I can't think of any ways to... (4 Replies)
Discussion started by: migurus
4 Replies
LEARN ABOUT MOJAVE
net::dns::rr::txt5.18
Net::DNS::RR::TXT(3) User Contributed Perl Documentation Net::DNS::RR::TXT(3) NAME
Net::DNS::RR::TXT - DNS TXT resource record SYNOPSIS
use Net::DNS; $rr = new Net::DNS::RR( 'name TXT txtdata ...' ); $rr = new Net::DNS::RR( name => 'name', type => 'TXT', txtdata => 'single text string' ); $rr = new Net::DNS::RR( name => 'name', type => 'TXT', txtdata => [ 'multiple', 'strings', ... ] ); use utf8; $rr = new Net::DNS::RR( 'jp TXT XXXXXXXXXXXX' ); DESCRIPTION
Class for DNS Text (TXT) resource records. METHODS
The available methods are those inherited from the base class augmented by the type-specific methods defined in this package. Use of undocumented package features or direct access to internal data structures is discouraged and could result in program termination or other unpredictable behaviour. txtdata $string = $rr->txtdata; @list = $rr->txtdata; $rr->txtdata( @list ); When invoked in scalar context, txtdata() returns the descriptive text as a single string, regardless of the number of elements. In a list context, txtdata() returns a list of the text elements. COPYRIGHT
Copyright (c)2011 Dick Franks. All rights reserved. This program is free software; you may redistribute it and/or modify it under the same terms as Perl itself. Package template (c)2009,2012 O.M.Kolkman and R.W.Franks. SEE ALSO
perl, Net::DNS, Net::DNS::RR, RFC1035 Section 3.3.14, RFC3629 perl v5.18.2 2014-01-16 Net::DNS::RR::TXT(3)