Once you successfully load the file make tar of that file and move to your archive directory and if this is successful then remove original file(if required) as below.
Since i'm new to scripting i'm findind it difficult to code a script. The script has to be an executable with 2 paramters passed to it.The Parameters are
1. The Control file name(.ctl file)
2. The Data file name(.csv file)
Does anybody have an idea about it? :confused: (3 Replies)
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)
Hi,
Here is my problem.. i have 2 files (file1, file2).. i have wrote the last two lines and first 4 lines of "file2" into two different variables .. say..
my $firstrec = `head -4 $file2`;
my $lastrec = `tail -2 $file2`;
and i write the rest of the file2 to a tmpfile and cat it with head... (2 Replies)
Hello, maybe this post is offtopic, sorry for the inconveniencies (maybe should be in the forum with questions about C, C++, Java, SQL...).
I found examples about how to populate different fields from a text file (with MySQL, the LOAD DATA INFILE sentece), but not about how to load a complete... (2 Replies)
Hi....can you guys help me out in this script??
Below is a portion text file and it contains these:
GEF001 000093625 MKL002510 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL003604 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL005675 000001... (1 Reply)
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)
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)
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)
We have the data looks like below in a log file.
I want to generat files based on the string between two hash(#) symbol like below
Source:
#ext1#test1.tale2 drop
#ext1#test11.tale21 drop
#ext1#test123.tale21 drop
#ext2#test1.tale21 drop
#ext2#test12.tale21 drop
#ext3#test11.tale21 drop... (5 Replies)
Discussion started by: Sanjeev G
5 Replies
LEARN ABOUT LINUX
shape_tar
SHAPE_TAR(1) General Commands Manual SHAPE_TAR(1)NAME
shape_tar - shapeTools RMS bundle up subsystem in a tar or shar archive
SYNOPSIS
shape tar[VERSIONS=<version_selection_rule>] [ARCHIVE=<filename>]
shape shar[VERSIONS=<version_selection_rule>] [ARCHIVE=<filename>]
DESCRIPTION
Shape tar and shape shar create a tar or a shar archive containing all source components of the current node in the system tree. All source
components listed in the COMPONENTS macro in the Makefile and the release identification file (VERSIONFILE) are written to the archive.
Components of subsystems are not included in the archive file.
The VERSIONS macro may be set to specify a version selection rule to be active during archive file creation. Default is most_recent,
selecting the most recent version of each component. See shape_stdrul(7) or the $(SHAPELIBPATH)/stdrules for other possible settings. You
may also use self defined version selection rules as VERSIONS.
ARCHIVE is the base name of the file where the output shall be written to. Default is $(SUBSYSTEMNAME). The output file gets the filename
extension .tar (resp. .shar). When ARCHIVE=- is given, data will be written to standard output.
SEE ALSO shape_RMS(1), shape_stdrul(7)FILES
$(SUBSYSTEMNAME).tar $(SUBSYSTEMNAME).shar
24.8.119SHAPE_TAR(1)