Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Perl script to load data by calling sqlldr
Top Forums Shell Programming and Scripting Perl script to load data by calling sqlldr Post 302510930 by msrahman on Tuesday 5th of April 2011 10:28:03 AM
Old 04-05-2011
Perl script to load data by calling sqlldr
Hello all,
I know this is Unix forum, but i also know that there are some experts here who can help me out with this situation;

I am loading a data file into oracle table using Perl script by calling sqlldr script.

It does not do anything, and no data is getting loaded.

Any help, suggestion to make this script workable, would appreciate it.

Perl script;
Code:
#!/oracle/product/11.2.0/perl/bin/perl
#Checking the server to connect
if ($ARGV[0] eq 'QA')
{
$ENV{"ORACLE_HOME"} = "/oracle/product/11.2.0";
$LIBPATH = "/oracle/product/11.2.0/lib:/usr/lib";
$dbsid = 'mysid';
$dbuser = 'myuser';
$dbpwd = `/usr/local/pl/perlencrypt.pl -k /kda1/system/ealgorithm -d /sdr1/system/mysidmyuserpw`;
}

#Directories where input file exist (Please Use the Appropriate Directory structure)
my @inputdirectories = ('/MCS/MAINFRAME/REFERENCE');
#directory where files will be moved to after job execution.
my @outputdirectory = '/MCS/MAINFRAME/REFERENCE/Archive';
#File name and location of the text file
my @file = '/MCS/MAINFRAME/REFERENCE/2011030546845.MBT.A0MW9693.NDM.HBIDT.AD38XADJ.txt';
#Logfile location where it will reside
my @logFile= "/MCS/MAINFRAME/REFERENCE/Log";
#Control file location
my @control= "/MCS/MAINFRAME/REFERENCE/control/adjust_rsn_codes.ctl";
$status = system ("$SQLLDR $CONNECT control=$control data=$file log=$logFile");
#$dbh->disconnect;
close $FILE;


SQLLDR SCRIPT;
Code:
LOAD DATA
infile '/MCS/MAINFRAME/REFERENCE/2011031879382.MBT.A0TW9693.NDM.HBIDT.AD37XADJ.txt'
APPEND INTO TABLE ZX02051.ADJUSTMENT_REASON_CODES
TRAILING NULLCOLS
(REASON_CODE           CHAR,
  EFFECTIVE_DATE        CHAR,
  END_DATE              CHAR,
  MCS_CYCLE_BUILD_DATE  CHAR,
  CREATED_TIMESTAMP     DATE "DD/MM/YYY")

Last edited by pludi; 04-05-2011 at 11:35 AM.. Reason: redacted potentially sensitive information
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need help in wrting Load Script for a Load-Resume type of load.

hi all need your help. I am wrting a script that will load data into the table. then on another load will append the data into the existing table. Regards Ankit (1 Reply)
Discussion started by: ankitgupta
1 Replies

2. Web Development

script to load data from csv file

hello i want a script to load the data line by line from a csv file into a mysql table (3 Replies)
Discussion started by: srpa01red
3 Replies

3. Shell Programming and Scripting

Calling 3 perl script from one

hi all, I have 3 perl scripts a.pl,b.pl and c.pl each of these work when i pass a date for eg: perl c.pl 2010-05-27 now i want to write a perl script that would call the 3 scripts and make it run all the 3 scripts (a.pl,b.pl,c.pl) parallelly rather than 1 after the other....... pls... (2 Replies)
Discussion started by: siva_nagarajan
2 Replies

4. Shell Programming and Scripting

Shell script to find specific file name and load data

I need help as to how to write a script in Unix for the following: We have 3 servers; The mainframe will FTP them to a folder. In that folder we will need the script to look and see if the specific file name is there and load it to the correct table. Can anyone pls help me out with... (2 Replies)
Discussion started by: msrahman
2 Replies

5. Shell Programming and Scripting

Perl script to Archive the data file after the load

I have written a perl scripts which loads the data. Now i want to modify the script, to Archive the Input file after the successful load of data. Can anyone please share it and help me .... Thanks. (2 Replies)
Discussion started by: msrahman
2 Replies

6. Homework & Coursework Questions

Shell script calling Perl function, sort and find data, write to new files

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: I must write a shell script that calls two external Perl functions--one of which sorts the data in a file, and... (6 Replies)
Discussion started by: kowit010
6 Replies

7. Shell Programming and Scripting

calling a perl script with arguments from a parent perl script

I am trying to run a perl script which needs input arguments from a parent perl script, but doesn't seem to work. Appreciate your help in this regard. From parent.pl $input1=123; $input2=abc; I tried calling it with system("/usr/bin/perl child.pl $input1 $input2"); and `perl... (1 Reply)
Discussion started by: grajp002
1 Replies

8. Shell Programming and Scripting

How to read file and load data into a script as variable

I need to read a text file that contain columns of data, i need to read 1st column as a function to call, and others are the data i need to get into a ksh script. I am quite new to ksh scripting, i am not very sure how to read each row line by line and the data in each columns of that line, set... (3 Replies)
Discussion started by: gavin_L
3 Replies

9. Shell Programming and Scripting

Parallel sqlldr to load data.

I am using SQLLDR to load data in DB.For parallel loading I'm using nohup command. The requirement is: I have different files within a directories. Ex: 1) Dir/folder_A/AE.txt 2) Dir/folder_A/DM.txt 3) Dir/folder_B/CM.txt I need to loop through directories and load the data... (1 Reply)
Discussion started by: Pratiksha Mehra
1 Replies

10. Shell Programming and Scripting

SQLLDR :Data not loaded completely

Hi , I am using below control file LOAD DATA APPEND INTO TABLE LSHADMIN.EG TRAILING NULLCOLS ( STUDY CHAR ) and the text file to load data is CACZ885M2301 When I run below command: sqlldr userid=apps/apps control=/home/appsuser/dataload/ctl_file.ctl... (3 Replies)
Discussion started by: Pratiksha Mehra
3 Replies

LEARN ABOUT DEBIAN

mcs-getconfval

MCS-GETCONFVAL(1)						   User Commands						 MCS-GETCONFVAL(1)

NAME

       mcs-getconfval - a tool which show your settings from a mcs-managed application.

DESCRIPTION

       mcs-getconfval is a maintenance tool for your mcs installation.
       It will allow you to get the value of an application setting if its configuration is managed through mcs.

SYNOPSIS

       mcs-getconfval <domain> <section> <keyname>

OPTIONS

       <domain>
	      name of the target software.

       <section>
	      configuraton sub-section.

       <keyname>
	      name of the setting.

EXAMPLES

       mcs-getconfval audacious alsa volume_l

       Return left channel volume level from the alsa section of audacious.

FILES

       /etc/mcs-backend
	      Use "default", "kconfig" or "gconf" to select which backend will be used to store mcs-managed applications settings.
	      "kconfig" and "gconf" are available through libmcs-backend-gconf and libmcs-backend-kconfig packages.

       ~/.mcs-backend
	      Overrides /etc/mcs-backend.

SEE ALSO

       mcs-info(1)
       mcs-setconfval(1)
       mcs-query-backends(1)
       mcs-walk-config(1)
       Homepage: http://www.atheme.org/projects/mcs.shtml

AUTHOR

       This manual page was written by Adam Cecile <gandalf@le-vert.net> for the Debian system (but may be used by others).
       Permission  is  granted to copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 2 or any
       later version published by the Free Software Foundation.
       On Debian systems, the complete text of the GNU General Public License can be found in /usr/share/common-licenses/GPL.

0.6.0								   January 2008 						 MCS-GETCONFVAL(1)
All times are GMT -4. The time now is 09:58 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy