Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

how to add, updat, and delete records using shell

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting how to add, updat, and delete records using shell
# 1  
Old 10-04-2008
how to add, updat, and delete records using shell
thax for replying
Last edited by sarah2009; 10-05-2008 at 08:46 PM..
# 2  
Old 10-04-2008
We would have to know the file layout for RESPR_FILE.
# 3  
Old 10-04-2008
Thax for replying
Last edited by sarah2009; 10-05-2008 at 08:42 PM..
# 4  
Old 10-04-2008
Thax for replying
Last edited by sarah2009; 10-05-2008 at 08:44 PM..
# 5  
Old 10-04-2008
By file layout I mean what do the records in RESPR_FILE file itself look like?

And why are you asked to write something like this when you seem so unprepared to do it? Is this a class assignment?
# 6  
Old 10-04-2008
thax for replying
Last edited by sarah2009; 10-05-2008 at 08:48 PM..
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Delete db records from shell script

Hello Mates, I would request your help in a shell script, simply I need to delete some matching db table records (rows) to ones in a given file: ------------------------------ #!/bin/bash SQL="delete from numberlist where msidn='';" MYSQL_USER="<your-user>"... (4 Replies)
Discussion started by: EAGL€
4 Replies

2. Shell Programming and Scripting

Delete records by string and position

How do i delete the records when we have string "abcd" at position 21 to 24. The file is huge in size. Any help is appreciated. Sample data given below eiojfcdf oijjfdm ijdabcd234vffmv eojfirr jfdiopem ijaabb456irkmd aodniiuielc uejdocvoabcd957wpdjf (4 Replies)
Discussion started by: zooby
4 Replies

3. Shell Programming and Scripting

Delete the records from table

Hi, Can any one help me... the records are not deleting when I run the below script. But if I issue the same delete command manually, the records are getting deleted. script: #!/bin/ksh USAGE_STRING="USAGE $0 " if then echo "SORRY you need to be user 'mqm'. Only 'mqm' has... (5 Replies)
Discussion started by: zxcjggu708
5 Replies

4. Shell Programming and Scripting

Delete records within a file upon a condition

Hi Friends, I have the following file, cat input chr1 1000 2000 chr1 600 699 chr1 701 1000 chr1 600 1710 chr2 900 1800 Now, I would like to see the difference of Record1.Col2 - Record2.Col2 Record1.Col2 - Record2.Col3 Record1.Col3 - Record2.Col2 Record1.Col3 - Record2.Col3 ... (1 Reply)
Discussion started by: jacobs.smith
1 Replies

5. UNIX and Linux Applications

How to delete files with no records?

Hi, I have a file whose size is not zero but it has no records and another which has records. I want to delete all the files that have no records in it (even if size > 0). How do I do it? I have tried the below option #!/bin/ksh temp1 = $(wc -l < INVX102C.sf) if ; then echo "Data... (3 Replies)
Discussion started by: sangharsh
3 Replies

6. Shell Programming and Scripting

how to delete records with the given line numbers

I have a file which has about 10000 records and I need to delete about 50 records from the file. I know line numbers and am using sed '134,1357,......d' filename > new file. It does not seem to be working. Please Advice (5 Replies)
Discussion started by: mad_man12
5 Replies

7. UNIX for Advanced & Expert Users

delete records using line number(NR)

Hai I have a flat file which contains more than 6 crore lines or records. I want to delete only one line, using line number. For example I want to delete 414556 th line . How to do this using sed or awk command. thanks (3 Replies)
Discussion started by: tkbharani
3 Replies

8. Shell Programming and Scripting

delete records from a file

I have a big file with "|" delimiter. I want to delete all the records that have 'abc' in the 2nd field. How can i do that? I am not abe to open it in VI that is why i need to do it from outside. Please suggest (6 Replies)
Discussion started by: dsravan
6 Replies

9. Shell Programming and Scripting

Hai delete the records

Hai all i want to grep the particular pattern and move the mathing records to torget file and delete the matching recodrs from source file. patterns are position based, like 13413432,aaaaaaa,dsfdddddd,34234324,22224555 13413432,aaaaaaa,dsfdddddd,12234324,11222455 i want to move the... (1 Reply)
Discussion started by: readycpbala
1 Replies
Login or Register to Ask a Question