05-01-2008
sqlloader issue
Hi All,
I am using sqlloader in my shellscript.pastimg my code below
sqlldr XXXXXX/XXXXXXX@10.58.111.121:1221/XXXX control=/root/tracking/load.ctl log=sqlloaderlogs.log
I have 3 questions ..
1) how can i avoid printing the sqlloader operations messages in my screen while running.
2) How can i check the status of my sqlloader operation..
3) My script is a cronjob .In the load.ctl control file, how can i set the INFILE filename from my script while running the script.
Thanks in advance
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a shell scripting. This will take 7 digit number in each line and add 7 digit number with next subsequent lines ( normal addition ).
Eg:
0000001
0000220
0001235
0000022
0000023
...........
.........
........
Like this i am having around 1500000 records. After adding... (23 Replies)
Discussion started by: thambi
23 Replies
2. Shell Programming and Scripting
Hello there,
I'm writing a shellscript and it uses sqlloader, it works good coz load the data into the DB. But I'm runing the shell from a java program with Runtime(). It does execute the shell but the sqlloader doesn't seem to be working!!
Does anybody out there knows why?? (0 Replies)
Discussion started by: ying_dav
0 Replies
3. Programming
Hi ,
I have a dellimited .dat file and a sqlloader.
I want to call the sqlloader from a oracle stored procedure.
The procedure should return the result of sqlloader's execution. (3 Replies)
Discussion started by: Haque123
3 Replies
4. Shell Programming and Scripting
Hi all,
I am very new to shell scripting.I have the requirement like
one program is there, if it is running leave like that only and if it is stopped it has to be restart and once again keep watching and it is stopped we a have to restart once agian.I want a shell script for this.Please help me... (10 Replies)
Discussion started by: bhas85
10 Replies
5. Shell Programming and Scripting
Dear,
I must load a file in a table via sqlloader. I have also a column in this table which must contain the same value for all rows in this table. And this value is get from a shell script variable.
Can you give me a sort example on how to use a shell script variable as a paramter in a CTL... (1 Reply)
Discussion started by: yeclota
1 Replies
6. UNIX for Dummies Questions & Answers
In LINUX(CentOS, RedHat) is there a way to have the banner statement appear before the logon instead of after the logon? In UNIX and Windows the banner appears before a person actually logs on, what I'm seeing in LINUX is that it appears after the login(ftp, telnet, SSH).
Thanks (0 Replies)
Discussion started by: ejjones
0 Replies
7. Shell Programming and Scripting
Hello I am having a problem with a script. I try to run a store procedure from unix with sqlldr and shows me the following error.
begin
*
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "RNP.SP_ARCH_SALIDA", line 64
ORA-06512: at line 2
The sp... (1 Reply)
Discussion started by: Rodrih92
1 Replies
8. Programming
Hi ,
I have a data file in this format.
p1 p2 p3
10 0
10 0 1000
I am using a sqlloader script to load the data into the database table.There is a unique constraint on the columns p1 and p2.
So, sqlldr cannot load both the records. This eliminates duplicate records from being... (1 Reply)
Discussion started by: megha2525
1 Replies
9. Shell Programming and Scripting
Hello everyone, I'm in need of some assistance. I'm currently enrolled in an introductory UNIX shell programming course and, well halfway through the semester, we are receiving our first actual assignment. I've somewhat realized now that I've fallen behind, and I'm working to get caught up, but for... (1 Reply)
Discussion started by: MrMagoo22
1 Replies
10. Shell Programming and Scripting
Hi All,
I am using the below script which has awk command, but it is not returing the expected result. can some pls help me to correct the command.
The below script sample.ksh should give the result if the value of last 4 digits in the variable NM matches with the variable value DAT. The... (7 Replies)
Discussion started by: G.K.K
7 Replies
LEARN ABOUT DEBIAN
app::control
Control(3pm) User Contributed Perl Documentation Control(3pm)
NAME
App::Control - Perl module for apachectl style control of another script or executable
SYNOPSIS
use App::Control;
my $ctl = App::Control->new(
EXEC => $exec,
ARGS => @args,
PIDFILE => $pidfile,
SLEEP => 1,
VERBOSE => 1,
);
my $pid = $ctl->pid;
if ( $ctl->running )
{
print "$pid is running
";
}
else
{
print "$pid is not running
";
}
# or alternatively ...
print $ctl->status;
$ctl->start;
# or alternatively ...
$ctl->cmd( 'start' );
$ctl->stop;
$ctl->hup;
$ctl->restart;
DESCRIPTION
App::Control is a simple module to replicate the kind of functionality you get with apachectl to control apache, but for any script or exe-
cutable. There is a very simple OO interface, where the constructor is used to specify the executable, command line arguments, and pidfile,
and various methods (start, stop, etc.) are used to control the executable in the obvious way.
The module is intended to be used in a simple wrapper control script. Currently the module does a fork and exec to start the executable,
and sets the signal handler for SIGCHLD to 'IGNORE' to avoid zombie processes.
CONSTRUCTOR
The constructor is called with a hash of options in the standard way. The options are as follows:
EXEC
Path to the executable to be controlled. This option is REQUIRED.
ARGS
Command line arguments for the executable. This option is OPTIONAL, but if set, should be an ARRAY reference.
PIDFILE
Path to the pidfile for the executable. This need not exists, but the constructor will die if it thinks it can't create it. If the path
where the pidfile lives doesn't exist the constructor will try to create it. This option is REQUIRED.
IGNOREFILE
The ignore file allows you to temporarily disable the control functionality. Suppose you have a chkdaemon / crontab entry that restarts a
service; specifying an IGNOREFILE means that you can disable this wihtout having to edit the relevant config files.
CREATE_PIDFILE
By default, App::Control depends on the application to manage the pid file. This is consistent will analogous utilities (apachectl, chk-
daemon, etc.), but if you would like App::Control to create and remove pid files for you, then set this option to a true value.
SLEEP
Number of seconds to sleep before checking that the process has been started. If the start fails, the control script will loop with a
SLEEP delay per iteration until it has (see <"LOOP">). Default is 1 second.
head2 LOOP
Number of times to loop before giving up on starting the process.
VERBOSE
If set to a true value, the module will output verbose messages to STDERR.
METHODS
start
Start the executable specified in the constructor. This method waits until it is convinced that the executable has started. It then writes
the new pid to the pidfile.
stop
Stop the executable specified in the constructor. It assumes that the pid listed in the pidfile specified in the constructor is the process
to kill. This method waits until it is convinced that the executable has stopped.
hup
Send a SIGHUP to the executable.
restart
Basically; stop if running, and then start.
status
Returns a status message along the lines of "$exec ($pid) is / is not running".
cmd
All of the above methods can also be invoked using cmd; i.e.:
$ctl->start;
is equivilent to:
$ctl->cmd( 'start' );
give or take a call to AUTOLOAD!
pid
Returns the current value of the pid in the pidfile.
running
returns true if the pid in the pidfile is running.
AUTHOR
Ave Wrigley <Ave.Wrigley@itn.co.uk>
COPYRIGHT
Copyright (c) 2001 Ave Wrigley. All rights reserved. This program is free software; you can redistribute it and/or modify it under the same
terms as Perl itself.
perl v5.8.8 2003-08-27 Control(3pm)