Sponsored Content
Top Forums Shell Programming and Scripting updating a column in oracle table using shell script Post 71260 by sveera on Monday 9th of May 2005 12:17:26 PM
Old 05-09-2005
Power updating a column of a oracle table

Hi SSSROW,
Thanks for the reply but it doesnt help me. the update is not taking place.
it says zero rows updated.
Please help out.
thanks
Veera
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

update a oracle table using shell script

Hi, I would like to know how to update a table in Oracle database, if a command in one shell script either successfully completes or it fails.(like Y if its success or N if its a failure) While the command is running,I am able to view the log file created in the Unix machine.After the command... (2 Replies)
Discussion started by: ann_124
2 Replies

2. Shell Programming and Scripting

Store return code of shell script in oracle table

Hi friends, I have to do the following things : 1) there should be a shell script returning the returning the return code of the script. and i have to add some more details like on which machine is has run , at what time and other details and then using plsql i have to add a row to Oracle... (3 Replies)
Discussion started by: sveera
3 Replies

3. Shell Programming and Scripting

script for updating table using file(

Hi, Data file path (.txt) Control file(.ctl) I have delimited file(|). Sample data: 1|name|50009|DS24|0|12 2|name|30009|DS24|0|13 3|name|20409|DS24|0|14 4|name|20009|DS24|0|15 5|name|10009|DS24|0|16 I want to load this data into a oracle table (update and insert) Please help me... (1 Reply)
Discussion started by: unihp1
1 Replies

4. Shell Programming and Scripting

updating a column in a unix table for a particular row

Hi, I have the following requirement. I have a unix table as below progname par1 par2 par3 par4 PROG1 abc def 0012 ooo PROG2 wed xas 0100 xxx PROG3 kkk ppp 0004 ppp Different programs(ex:PROG1,PROG2..) accesses this table and update... (5 Replies)
Discussion started by: thanuman
5 Replies

5. Shell Programming and Scripting

To update a column in a table through shell script

Hi All, I need to write a shell script in UNIX that should accept booking number as an argument and update it with value "NULL" if the transaction date is greater than 2 years. Booking number and transaction_date are the two columns of the table table_booking. Something like this, through... (3 Replies)
Discussion started by: shilpa_acc
3 Replies

6. Shell Programming and Scripting

Shell script to query Oracle table

Hi, unix gurnis I need help for following requirement for writing a shell scritp. log in to oracle database, query one table total records (select count(*) from table1), pass the return value to a file. Thanks in advance (2 Replies)
Discussion started by: ken002
2 Replies

7. Shell Programming and Scripting

Shell script to export data from Oracle table .

Hi, I want to write a shell script which will export data from oracle table . I don't want to save that data . I want the queries . Right now i am right clicking on the table and clicking on export as to my desktop . Please let me know if any one have any idea . (2 Replies)
Discussion started by: honey26
2 Replies

8. Shell Programming and Scripting

Run the Script from any stage by updating data from Oracle Table.

I have 100 Scripts, each containing 10-15 SQL's in them. Each Script run for 40 mins to 1 hour 30 mins. In the event of Failure in any step, if i re-start the Script, it will start running from the beginning. Which is waste of time. So in order handle this, i made the script to run from the... (7 Replies)
Discussion started by: kiran1992
7 Replies

9. Shell Programming and Scripting

Parameterizing to dynamically generate the extract file from Oracle table using Shell Script

I have below 2 requirements for parameterize the generate the extract file from Oracle table using Shell Script. Could you please help me by modifying the script and show me how to execute it. First Requirement: I have a requirement where I need to parameterize to generate one... (0 Replies)
Discussion started by: hareshvikram
0 Replies
Net::DNS::Update(3pm)					User Contributed Perl Documentation				     Net::DNS::Update(3pm)

NAME
Net::DNS::Update - Create a DNS update packet SYNOPSIS
"use Net::DNS::Update;" DESCRIPTION
"Net::DNS::Update" is a subclass of "Net::DNS::Packet", to be used for making DNS dynamic updates. Programmers should refer to RFC 2136 for the semantics of dynamic updates. WARNING: This code is still under development. Please use with caution on production nameservers. METHODS
new $packet = Net::DNS::Update->new; $packet = Net::DNS::Update->new('example.com'); $packet = Net::DNS::Update->new('example.com', 'HS'); Returns a "Net::DNS::Update" object suitable for performing a DNS dynamic update. Specifically, it creates a packet with the header opcode set to UPDATE and the zone record type to SOA (per RFC 2136, Section 2.3). Programs must use the "push" method to add RRs to the prerequisite, update, and additional sections before performing the update. Arguments are the zone name and the class. If the zone is omitted, the default domain will be taken from the resolver configuration. If the class is omitted, it defaults to IN. Future versions of "Net::DNS" may provide a simpler interface for making dynamic updates. EXAMPLES
The first example below shows a complete program; subsequent examples show only the creation of the update packet. Add a new host #!/usr/bin/perl -w use Net::DNS; use strict; # Create the update packet. my $update = Net::DNS::Update->new('example.com'); # Prerequisite is that no A records exist for the name. $update->push(pre => nxrrset('foo.example.com. A')); # Add two A records for the name. $update->push(update => rr_add('foo.example.com. 86400 A 192.168.1.2')); $update->push(update => rr_add('foo.example.com. 86400 A 172.16.3.4')); # Send the update to the zone's primary master. my $res = Net::DNS::Resolver->new; $res->nameservers('primary-master.example.com'); my $reply = $res->send($update); # Did it work? if ($reply) { if ($reply->header->rcode eq 'NOERROR') { print "Update succeeded "; } else { print 'Update failed: ', $reply->header->rcode, " "; } } else { print 'Update failed: ', $res->errorstring, " "; } Add an MX record for a name that already exists my $update = Net::DNS::Update->new('example.com'); $update->push(pre => yxdomain('example.com')); $update->push(update => rr_add('example.com MX 10 mailhost.example.com')); Add a TXT record for a name that doesn't exist my $update = Net::DNS::Update->new('example.com'); $update->push(pre => nxdomain('info.example.com')); $update->push(update => rr_add('info.example.com TXT "yabba dabba doo"')); Delete all A records for a name my $update = Net::DNS::Update->new('example.com'); $update->push(pre => yxrrset('foo.example.com A')); $update->push(update => rr_del('foo.example.com A')); Delete all RRs for a name my $update = Net::DNS::Update->new('example.com'); $update->push(pre => yxdomain('byebye.example.com')); $update->push(update => rr_del('byebye.example.com')); Perform a signed update my $key_name = 'tsig-key'; my $key = 'awwLOtRfpGE+rRKF2+DEiw=='; my $update = Net::DNS::Update->new('example.com'); $update->push(update => rr_add('foo.example.com A 10.1.2.3')); $update->push(update => rr_add('bar.example.com A 10.4.5.6')); $update->sign_tsig($key_name, $key); Another way to perform a signed update my $key_name = 'tsig-key'; my $key = 'awwLOtRfpGE+rRKF2+DEiw=='; my $update = Net::DNS::Update->new('example.com'); $update->push(update => rr_add('foo.example.com A 10.1.2.3')); $update->push(update => rr_add('bar.example.com A 10.4.5.6')); $update->push(additional => Net::DNS::RR->new("$key_name TSIG $key")); Perform a signed update with a customized TSIG record my $key_name = 'tsig-key'; my $key = 'awwLOtRfpGE+rRKF2+DEiw=='; my $tsig = Net::DNS::RR->new("$key_name TSIG $key"); $tsig->fudge(60); my $update = Net::DNS::Update->new('example.com'); $update->push(update => rr_add('foo.example.com A 10.1.2.3')); $update->push(update => rr_add('bar.example.com A 10.4.5.6')); $update->push(additional => $tsig); BUGS
This code is still under development. Please use with caution on production nameservers. COPYRIGHT
Copyright (c) 1997-2002 Michael Fuhr. Portions Copyright (c) 2002-2004 Chris Reinhardt. All rights reserved. This program is free software; you may redistribute it and/or modify it under the same terms as Perl itself. SEE ALSO
perl(1), Net::DNS, Net::DNS::Resolver, Net::DNS::Header, Net::DNS::Packet, Net::DNS::Question, Net::DNS::RR, RFC 2136, RFC 2845 perl v5.14.2 2009-12-30 Net::DNS::Update(3pm)
All times are GMT -4. The time now is 05:17 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy