01-21-2013
Millions of record using shell script
I wanna create a millions of record using shell scripts..
the scenario is somehow like this,,,i want to create the record for these fields in my database..id,name,addrs,sales.
So can you please give a overall idea for how to achieve it?
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi All,
I have shell script running on AIX 5.3 box. It has 7 to 8 "sed" commands piped(|) together. It has a an Xml file as its input which has many records internally. There are certain record which which have more than hundered tags.The script is taking a huge amount of time more than 1.5 hrs... (10 Replies)
Discussion started by: aixjadoo
10 Replies
2. Shell Programming and Scripting
Hi, I am trying to parse a very long record in a text file into multiple records by checking ADD, DELETE, or MODIFY field value in a shell script.
Input
# File name xyz.txt
ADD|N000|8015662|DELETE|N001|9915662|MODIFY|N999|85678
Output
ADD|N000|8015662|
DELETE|N001|9915662|... (8 Replies)
Discussion started by: naveed
8 Replies
3. Shell Programming and Scripting
Hi All,
My requirement is like this.
I want to generate records of 1 million lines. If I say lines it means one line will contain some string or numbers like
AA,3,4,45,+223424234,Tets,Ghdj,+33434,345453434,........................ upto length lets say 41. ( 41 comma sepearted aplha numneric... (2 Replies)
Discussion started by: Rahil2k9
2 Replies
4. Shell Programming and Scripting
Hi,
I have a requirement in hand:
I have a file with millions of records say file 1.I have another file, say file 2 which has 2000 records in it. The requirement is to read file2 , and remove the read record from file 1 and move i to a seperate file, file 3.
For eg: Read file 2, get the... (5 Replies)
Discussion started by: kumara2010
5 Replies
5. UNIX for Advanced & Expert Users
Hi guys,
I have an issue processing a large amount of files. I have around 5 million files (some of them are actually directories) in a server.
I am unable to find out the exact number of files since it's taking "forever" to finish (See this thread for more on the issue).
Anyway, now I... (6 Replies)
Discussion started by: verdepollo
6 Replies
6. Shell Programming and Scripting
Hello,
I just saw that on my vps (centOS) my oscommerce with a seo script
has created millions of tmp files inside the /html/cache/ directory.
I would need to remove all those files (millions), I tried via shell but the vps
loads goes to very high and it hangs, is there some way to do a... (7 Replies)
Discussion started by: andymc1
7 Replies
7. Shell Programming and Scripting
hello, I require help in the following. There is a report similar to the ones shown here. I need to do couple of things
10/07 12:47 0003210042 R TENN ANVISER0 DELF96A.V1.O.TENRREG 120710 124657 U 00000 DELFOR 1 4331
10/07 12:47 0003210043 S TENN... (2 Replies)
Discussion started by: rakeshv
2 Replies
8. Shell Programming and Scripting
HI,
I need to print the record count of a file using shell script.
If the record count of a file excluding header and trailer record if greater than zero then print 'Record count of a file is xxxx records'.
If the record count is zero print 'zero records'
Thanks
Mahendra (1 Reply)
Discussion started by: mmeda
1 Replies
9. Shell Programming and Scripting
Hi,
Very good wishes to all!
Please help to provide the shell script for generating the record counts in filed wise from the .csv file
My question:
Source file:
Field1 Field2 Field3
abc 12f sLm
1234 hjd 12d
Hyd 34
Chn
My target file should generate the .csv file with the... (14 Replies)
Discussion started by: Kirands
14 Replies
10. Shell Programming and Scripting
Hi,,
I have requirement that i need to get DISTINCT values from a table and if there are two records i need to update it to one record and then need to submit INSERT statements by using the updated value as a parameter. Here is the example follows..
SELECT DISTINCT ID FROM OFFER_GROUP WHERE... (1 Reply)
Discussion started by: Samah
1 Replies
LEARN ABOUT CENTOS
ntdbtool
NTDBTOOL(8) System Administration tools NTDBTOOL(8)
NAME
ntdbtool - manipulate the contents NTDB files
SYNOPSIS
ntdbtool NTDBFILE [COMMANDS...]
DESCRIPTION
This tool is part of the samba(1) suite.
ntdbtool a tool for displaying and altering the contents of Samba NTDB (New Trivial DataBase) files. Each of the commands listed below can
be entered interactively or provided on the command line.
COMMANDS
create NTDBFILE
Create a new database named NTDBFILE.
open NTDBFILE
Open an existing database named NTDBFILE.
erase
Erase the current database.
dump
Dump the current database as strings.
cdump
Dump the current database as connection records.
keys
Dump the current database keys as strings.
hexkeys
Dump the current database keys as hex values.
info
Print summary information about the current database.
insert KEY DATA
Insert a record into the current database.
move KEY NTDBFILE
Move a record from the current database into NTDBFILE.
store KEY DATA
Store (replace) a record in the current database.
show KEY
Show a record by key.
delete KEY
Delete a record by key.
list
Print the current database hash table and free list.
free
Print the current database and free list.
! COMMAND
Execute the given system command.
first
Print the first record in the current database.
next
Print the next record in the current database.
check
Check the integrity of the current database.
repack
Repack a database using a temporary file to remove fragmentation.
quit
Exit ntdbtool.
SEE ALSO
tdbtool(8)
CAVEATS
The contents of the Samba NTDB files are private to the implementation and should not be altered with ntdbtool.
VERSION
This man page is correct for version 4.0 of the Samba suite.
AUTHOR
The original Samba software and related utilities were created by Andrew Tridgell. Samba is now developed by the Samba Team as an Open
Source project similar to the way the Linux kernel is developed.
Samba 4.1 06/17/2014 NTDBTOOL(8)