We have almost 45,000 data files created by a script daily. The file names are of format-ODS.POS.<pharmacyid>.<table name>.<timestamp>.dat. There will be one data file like this for each pharmacy and each table.(Totally around 45,000)
The requirement is to create a control file for each pharmacy id with file name, No.of rows , table name, timestamp and MD5 value.
The data files look like this -
The requirement is to create a control file for each pharmacyid
Controlfile 1 -> for pharmacy id - ABC89
Control file 1 (ODS.POS.<Pharmacyid>.timestamp.ctl )should contain the filename, no.of rows, table name, time stamp and MD5 value for the below files.
Control file 2->for pharmacy id - AEC12
Control file 2 ((ODS.POS.<Pharmacyid>.<timestamp>.ctl )should contain the filename, no.of rows, table name, time stamp and MD5 value for the below files.
can somebody help on this?
Thanks
Maya
Last edited by Scott; 08-02-2010 at 06:16 AM..
Reason: Code tags, please...
I have a directory named Project.I have a control file which contains valid list of files.I would like list the files from directory Project which contains files other than listed in the control file.
Sample control file:
TEST
SEND
SFFFILE
CONTL
The directory contains followign... (15 Replies)
What is a supplementary group and how do you make a supplementary group for members of a team? Thanks in advance.
---------- Post updated 05-10-11 at 12:09 PM ---------- Previous update was 05-09-11 at 10:08 PM ----------
anybody? (1 Reply)
We have created ACL's to allow two differnet groups to access some directories. You can see output from getfacl below.
group::rwx
group:rbauser:r--
The original group has full access, the secondary group has read only. However users in the secondary group can't see the directories. Think this... (1 Reply)
Hi,
I'm the root user on my computer, but I'm writing a script that does a lot of file handling. Every time I create a file or directory it automatically requires root privileges. Is there a way I can just create a file that the user can access without a password?
For example in my script I... (20 Replies)
Hi,
I am working on setup a environment where only a specific user can upload the builds on htdocs of apache.
Now i want that a specific user can copy the builds on htdocs folder.
I created a group "deploy" and assign user1 and user2 to this group.
On Apache side i mentioned User=deploy... (3 Replies)
Hi members,
I have a file with lots of text like this:
asdsfkm
dfsfomnow i want to extract only the rows with HUMAN as its 1st column
for this I used :
ruby -ne 'print if /^Human/; exit if /^TER/' $line | awk 'print $1, "\t"$2, "\t"$3, "\t"$4, "\t"$5}' >$line"new"
This is creating a file... (1 Reply)
Hi,
I have a file with usernames, and the comment section, e.g :
Data removed by request of sanchitadutta91, 20 May 2020
I need to add these users into a server. Is it possible to use a script to create the users, together with the comment ?
From the commandline to add one user, the... (2 Replies)
Delete
---- Original post, restored by mod after being deleted by abhilashnair ----
I have a requirement where, I need to create a control file which will have 3 columns in the header row as below:
Filename
Count
Checksum
This above control file has to contain metadata as above... (2 Replies)
Hi,
I have many files but with only 2 names , I want to load the data of that file into database through sqlldr with single control file. how can i do that ?????
Example:
switch_file
switch_file
billing_file
billing_file
now these files should be loaded into same database but different... (1 Reply)