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)
I'm new in Unix shell scripting and i need someone to help me to make Script that run all time watching my directory that files uploaded to it via FTP (/mydir/incoming_files), if any files exists in it then (if many files exists, then sort files and load them ascending) it‘ll checks the size of the... (1 Reply)
Hi all,
How to load variable value into Oracle table? I have created a file validation shell script. After the validation completes, i need to update a Oracle table with the variable value...
Can someone help me how to do it? I have searched, but not able to get answer.
i have 4... (1 Reply)
Hi all,
How to load variable value into Oracle table? I have created a file validation shell script. After the validation completes, i need to update a Oracle table with the variable value...
Can someone help me how to do it? I have searched, but not able to get answer.
i have 4 variables... (2 Replies)
Hi all,
I need to know how to copy data from a table say ABC to a flat file say XYZ.dat in unix,
Please leave ur comments and the fastest way to do so,
I need to load the table records into flat file.
Regards
Ann (4 Replies)
I have a csv file in a folder that is roughly 500,000 rows long.
Rather than using PHP, I would like to use SH to run a MYSQL LOAD DATA command to load the data in, as I think it would be much faster and would not cause any memory problems associated with PHP.
But the problem is, I am not... (18 Replies)
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,... (2 Replies)
Hi All,
I am trying to capture the data in linux .While doing load test.
is there's any sample script please help me.
Linux test4 2.6.18-308.8.1.el5 #1 SMP Fri May 4 16:43:02 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux
Thanks, (5 Replies)
Hi,
i have some data in a temporary file in Unix (the data is taken from the result of an SQL query). Now i want to dump that data into an excel sheet. How to do that. Someone please advise. Thanks
Regards,
Vinit (3 Replies)
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 REDHAT
io::dir
IO::Dir(3pm) Perl Programmers Reference Guide IO::Dir(3pm)NAME
IO::Dir - supply object methods for directory handles
SYNOPSIS
use IO::Dir;
$d = new IO::Dir ".";
if (defined $d) {
while (defined($_ = $d->read)) { something($_); }
$d->rewind;
while (defined($_ = $d->read)) { something_else($_); }
undef $d;
}
tie %dir, IO::Dir, ".";
foreach (keys %dir) {
print $_, " " , $dir{$_}->size,"
";
}
DESCRIPTION
The "IO::Dir" package provides two interfaces to perl's directory reading routines.
The first interface is an object approach. "IO::Dir" provides an object constructor and methods, which are just wrappers around perl's
built in directory reading routines.
new ( [ DIRNAME ] )
"new" is the constuctor for "IO::Dir" objects. It accepts one optional argument which, if given, "new" will pass to "open"
The following methods are wrappers for the directory related functions built into perl (the trailing `dir' has been removed from the
names). See perlfunc for details of these functions.
open ( DIRNAME )
read ()
seek ( POS )
tell ()
rewind ()
close ()
"IO::Dir" also provides an interface to reading directories via a tied HASH. The tied HASH extends the interface beyond just the directory
reading routines by the use of "lstat", from the "File::stat" package, "unlink", "rmdir" and "utime".
tie %hash, IO::Dir, DIRNAME [, OPTIONS ]
The keys of the HASH will be the names of the entries in the directory. Reading a value from the hash will be the result of calling
"File::stat::lstat". Deleting an element from the hash will call "unlink" providing that "DIR_UNLINK" is passed in the "OPTIONS".
Assigning to an entry in the HASH will cause the time stamps of the file to be modified. If the file does not exist then it will be cre-
ated. Assigning a single integer to a HASH element will cause both the access and modification times to be changed to that value. Alterna-
tively a reference to an array of two values can be passed. The first array element will be used to set the access time and the second ele-
ment will be used to set the modification time.
SEE ALSO
File::stat
AUTHOR
Graham Barr. Currently maintained by the Perl Porters. Please report all bugs to <perl5-porters@perl.org>.
COPYRIGHT
Copyright (c) 1997-8 Graham Barr <gbarr@pobox.com>. 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.0 2002-06-01 IO::Dir(3pm)