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:
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"
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?
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
Shell(3pm) Perl Programmers Reference Guide Shell(3pm)
NAME
Shell - run shell commands transparently within perl
SYNOPSIS
use Shell qw(cat ps cp);
$passwd = cat('</etc/passwd');
@pslines = ps('-ww'),
cp("/etc/passwd", "/tmp/passwd");
# object oriented
my $sh = Shell->new;
print $sh->ls('-l');
DESCRIPTION
Caveats
This package is included as a show case, illustrating a few Perl features. It shouldn't be used for production programs. Although it does
provide a simple interface for obtaining the standard output of arbitrary commands, there may be better ways of achieving what you need.
Running shell commands while obtaining standard output can be done with the "qx/STRING/" operator, or by calling "open" with a filename
expression that ends with "|", giving you the option to process one line at a time. If you don't need to process standard output at all,
you might use "system" (in preference of doing a print with the collected standard output).
Since Shell.pm and all of the aforementioned techniques use your system's shell to call some local command, none of them is portable across
different systems. Note, however, that there are several built in functions and library packages providing portable implementations of
functions operating on files, such as: "glob", "link" and "unlink", "mkdir" and "rmdir", "rename", "File::Compare", "File::Copy",
"File::Find" etc.
Using Shell.pm while importing "foo" creates a subroutine "foo" in the namespace of the importing package. Calling "foo" with arguments
"arg1", "arg2",... results in a shell command "foo arg1 arg2...", where the function name and the arguments are joined with a blank. (See
the subsection on Escaping magic characters.) Since the result is essentially a command line to be passed to the shell, your notion of
arguments to the Perl function is not necessarily identical to what the shell treats as a command line token, to be passed as an individual
argument to the program. Furthermore, note that this implies that "foo" is callable by file name only, which frequently depends on the
setting of the program's environment.
Creating a Shell object gives you the opportunity to call any command in the usual OO notation without requiring you to announce it in the
"use Shell" statement. Don't assume any additional semantics being associated with a Shell object: in no way is it similar to a shell
process with its environment or current working directory or any other setting.
Escaping Magic Characters
It is, in general, impossible to take care of quoting the shell's magic characters. For some obscure reason, however, Shell.pm quotes
apostrophes ("'") and backslashes ("") on UNIX, and spaces and quotes (""") on Windows.
Configuration
If you set $Shell::capture_stderr to 1, the module will attempt to capture the standard error output of the process as well. This is done
by adding "2>&1" to the command line, so don't try this on a system not supporting this redirection.
Setting $Shell::capture_stderr to -1 will send standard error to the bit bucket (i.e., the equivalent of adding "2>/dev/null" to the
command line). The same caveat regarding redirection applies.
If you set $Shell::raw to true no quoting whatsoever is done.
BUGS
Quoting should be off by default.
It isn't possible to call shell built in commands, but it can be done by using a workaround, e.g. shell( '-c', 'set' ).
Capturing standard error does not work on some systems (e.g. VMS).
AUTHOR
Date: Thu, 22 Sep 94 16:18:16 -0700
Message-Id: <9409222318.AA17072@scalpel.netlabs.com>
To: perl5-porters@isu.edu
From: Larry Wall <lwall@scalpel.netlabs.com>
Subject: a new module I just wrote
Here's one that'll whack your mind a little out.
#!/usr/bin/perl
use Shell;
$foo = echo("howdy", "<funny>", "world");
print $foo;
$passwd = cat("</etc/passwd");
print $passwd;
sub ps;
print ps -ww;
cp("/etc/passwd", "/etc/passwd.orig");
That's maybe too gonzo. It actually exports an AUTOLOAD to the current package (and uncovered a bug in Beta 3, by the way). Maybe the
usual usage should be
use Shell qw(echo cat ps cp);
Larry Wall
Changes by Jenda@Krynicky.cz and Dave Cottle <d.cottle@csc.canterbury.ac.nz>.
Changes for OO syntax and bug fixes by Casey West <casey@geeknest.com>.
$Shell::raw and pod rewrite by Wolfgang Laun.
Rewritten to use closures rather than "eval "string"" by Adriano Ferreira.
perl v5.12.5 2012-11-03 Shell(3pm)