Sponsored Content
Full Discussion: sqlloader issue
Top Forums Shell Programming and Scripting sqlloader issue Post 302190937 by subin_bala on Thursday 1st of May 2008 03:28:36 AM
Old 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

Unix Arithmatic operation issue , datatype issue

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

runing shell with java and sqlloader issue

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

How to call sqlloader from stored procedure!!! Advise

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 please help me in this issue.

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

Use a shell variable value in a control file via sqlloader

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

ISSUE and ISSUE.NET files

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

Error sqlloader

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

eliminate duplicate rows - sqlloader

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

Need assistance with a file issue and a terminal issue

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

Variable value substitution issue with awk command issue

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
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)
All times are GMT -4. The time now is 09:04 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy