Search Results

This pattern matching did work
my $filepattern = '.*A0PD7193.*DMECBID.SUPL.*\.txt';


The requirement is we get weekly files that will get loaded.
e.g....

Hello all,

I have written a perl script which searched for a file in a folder, and return the value found or not found.

The file that we are getting is a weekly file and everyweek, the date...

We have a function in Perl called "Open" which creates a file.

I am trying to create the .TXT file in the specified directory.
I tried concatinating the Directory with the string.
...

Hi,

I am quite new to Perl scripting and i need to create a .TXT file using perl, with fields (A,B,C,D,E), and this text file should be named with current file creation date "XYZ_CCYYMMDD.TXT"...

I am using sqlldr in my perl script, which is incorporated in system().
How do i use this or add it into my existing system(), which will count the no. of lines in a .txt file and e-mail it to the...

Dear all,

The perl script to send e-mail is working in my current script.
#This part of the script will send the email notification
my $to='mohamed.rahman@noridian.com';
my...

Hello experts,
I have a perl script which looks for the ARGV and then loads the data as per it.
Example.
#Checking the server to connect
if ($ARGV[0] eq 'QA')
{
$ENV{"ORACLE_HOME"} =...

Dear all,

I have created a perl script with pattern matching, and which loads the data from the Input data file into the Oracle table, and after the load is successful, it deletes the file.
...

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 for the quick reply, but i am not echoing here.

This is the perl script that i am using;

#!/oracle/product/11.2.0/perl/bin/perl -w
#set global variables
#directories where input file...

I am doing a file patterhn matching for a text file in PERL

I am using this,,, but it says that no file is found
$filepattern = '\d{1,4}.*A0NW9693.NDM.HBIDT.*.AD34XADJ.txt';

Can anyone help...

How can i check if sqlldr has been installed on my AIX/UNIX mechine?
Is there any unix script to check this one out....

Thanks for the reply back praveen.
But i cant use the full sqlldr path directly in the script.

I can only run sqlldr as a system call.

Does anyone have a script, or can share thier PERL...

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...

Is it possible to add "Execute procedure" script in my current existing "Create or Replace Procedure script".

I would like this to work simultaneously "create and execute the procedure"

The...

I tried with '/' at the end of the script, and i am got this error;
Enter password:
set serveroutput on size 1000000
*
ERROR at line 2:
ORA-06550: line 2, column 5:
PL/SQL: ORA-00922:...

Hello,

I created a sql file to create a Procedure, and it was successfully created.
I created a sql file to execute the procedure, and it did without any errors, but i dont see the data been...

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...

Well i think the issue is resolved here.

Sorry for replying back so late, but i would like to thanks each one of you for your help and support, in making this work.

Methyl,

I am sorry for not replying back to you as to what Shell i am using.

The answer is :

Its "bash"
-bash-3.00$ echo $0
-bash

I got rid of set -e command.

Now i am facing a new issue.
When i execute the shell script, it just shows me blank with no progress.

-bash-3.00$ ./sqlldrclaims_backup_new.sh
Password:...

I tried with the pre-script error processing, with "sed -e". Looks like its working fine, but for what ever case (0 ,2, 4), it should send the e-mail to the user, stating the result.
But as per the...

Can you please explain to me as to what "sed -e" does here.

I dont want it to consider the whole sub-script as one. They are 5 different sub-scripts and each should run individually.
...

Hi,
I have attached the script as an attachment.

Please advice as to how to write the script which will stop the subscript if errors found, without proceeding further to the next subscript.

Hi,

I have written a shell script which is a combination of 5 scripts into one.
We have a Record Claim indicator in the scpt ($rc) with which we can come to an conclusion if the script failed...