Sponsored Content
Full Discussion: DB Query for Pivot
Top Forums Programming DB Query for Pivot Post 303021657 by Perlbaby on Tuesday 14th of August 2018 08:09:18 AM
Old 08-14-2018
DB Query for Pivot

hi team


With below results in Db2 v10.5 . Please refer column A and B are same,while Staus column defers with distinct values .


A B STATUS
Insert Update Old
Insert Update New
Insert Update Final


Can someone guide how to achieve this
A B Status
Insert Update Old
Null or Blank New
Null or Blank Final


Column A and B should be show same value . The o/p values are dynamic. please guide
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

pivot

I have a sql table with : Acitvity Date Value ABC 7/11 10 DEF 7/11 98 ABC 7/12 23 DEF 7/12 100 SER 7/12 67 GRH 7/13 123 HJY 7/14 12 I... (4 Replies)
Discussion started by: mukhanj
4 Replies

2. Shell Programming and Scripting

Pivot table

Hello everyone, I would like to use awk to parse a file with three columns in, like: monday 0 1 monday 1 1 monday 2 1 monday 3 1 monday 4 1 monday 5 1 tuesday 0 5 tuesday 1 1 tuesday 2 1 tuesday 3 1 tuesday 4 1 wednesday 0 1 monday 5 25 they represent the day the hour and the... (2 Replies)
Discussion started by: gio001
2 Replies

3. Shell Programming and Scripting

Pivot file contents

Hi All, I am trying to pivot the contents in a file. Ex: I have a file sample.txt with data "A B C D", i need the contents to pivot & resulting file should look like "A B C ... (3 Replies)
Discussion started by: new_ds_man
3 Replies

4. Shell Programming and Scripting

Create Pivot table

I would like to use awk to parse a file with three columns in, like: Chennai,01,1 Chennai,07,1 Chennai,08,3 Chennai,09,6 Chennai,10,12 Chennai,11,19 Chennai,12,10 Chennai,13,12 Kerala,09,2 AP,10,1 AP,11,1 Delhi,13,1 Kerala,13,3 Chennai,00,3 Chennai,01,1 Chennai,02,1 Chennai,07,5 (3 Replies)
Discussion started by: boston_nilesh
3 Replies

5. Shell Programming and Scripting

Pivot script

Hi Please suggest a script that would do a horizontal pivot , on the fields separated by a semicolon Below is my input file 1|c2|aa 1|c3|dd 1|c4|cc 1|c5|aa 1|c6|ss 1|c7|dd 1|c8|bb 1|c9|jjj 1|c10|kkk 1|c11|fffg 1|c12|nnn;indi;pak;linf;wer 1|c13|lllnk;li;sdfsd;oiuo 1|c14|ppp... (5 Replies)
Discussion started by: mabarif16
5 Replies

6. UNIX for Dummies Questions & Answers

Pivot multiple

Dear friend, I want to sum popul based on ville and reg. input date country ville reg popul 20131101 INDIA Gujarat College 322047286 20131101 USA Oregon 2 Kindergaten 477305599 20131101 INDIA Delhi 1 Ecole 255029428 20131101 MEXICO ... (2 Replies)
Discussion started by: radius
2 Replies

7. Shell Programming and Scripting

Pivot using awk

Hi, I am writing a code to basically pivot the data. awk -v var1="" -v var2="" -v var3="" -v var4="" -v var5="" -v Disp=0\ 'BEGIN {FS=":"; OFS="|";}\ /^Pattern1/ {var1=$2;Disp=0;} \ /^Pattern2/ {var2=$2;} \ /^Pattern3/ {var3=$2;} \ /^Pattern4/ {var4=$2;} \ /^Pattern5/... (5 Replies)
Discussion started by: tostay2003
5 Replies

8. Shell Programming and Scripting

Pivot file using shellscript

Hi, I am new at using shell scripting. So I have a question for the more experienced Linux users. I would like to perform some kind of pivot on a file. Example Input file COL1,"2001-01-01","2001-03-01","2001-03-24" A1,22,,44 B1,56,78,12 C2,5,, I would like to have to following output... (2 Replies)
Discussion started by: shanlinux
2 Replies

9. UNIX for Beginners Questions & Answers

Data Pivot

Good Day, I have file input 6285296582710|20170509|INDOTEL 6285296835209|20170509|INDOTEL 6285296940311|20170509|INDOTEL 6285297027737|20170509|MULTIFLAG 6285297027737|20170509|DELTA 6285297304373|20170510|INDOTEL 6285297384129|20170510|INDOTEL 6285296940311|20170510|MULTIFLAG... (2 Replies)
Discussion started by: radius
2 Replies

10. Shell Programming and Scripting

Pivot example

Hi all, I am new to shell scripting so pardon me for the questions I will be asking. I was given a task where I have to pivot my data Example Source SGPAPCTUMACCHEA Expected output SGP APC TUM SGP APC ACC SGP APC HEA Can anybody assist me on this?Please use CODE tags as required... (3 Replies)
Discussion started by: redaela
3 Replies
Net::DNS::Update(3)					User Contributed Perl Documentation				       Net::DNS::Update(3)

NAME
Net::DNS::Update - Create a DNS update packet SYNOPSIS
use Net::DNS::Update; $update = Net::DNS::Update->new; $update = Net::DNS::Update->new('example.com', 'IN'); $update->push(prerequisite => nxrrset('foo.example.com. A')); $update->push(update => rr_add('foo.example.com. 86400 A 192.168.1.2')); 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. METHODS
new $update = Net::DNS::Update->new; $update = Net::DNS::Update->new('example.com'); $update = Net::DNS::Update->new('example.com', 'HS'); Returns a "Net::DNS::Update" object used to perform a DNS dynamic update operation. Specifically, it creates a packet with the header opcode set to UPDATE and zone qtype to SOA (per RFC 2136, 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 strict; use Net::DNS; # Create the update packet. my $update = Net::DNS::Update->new('example.com'); # Prerequisite is that no A records exist for the name. $update->push(prerequisite => 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) { my $rcode = $reply->header->rcode; print 'Update ', $rcode eq 'NOERROR' ? "succeeded " : "failed: $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(prerequisite => 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(prerequisite => 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(prerequisite => 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(prerequisite => yxdomain('byebye.example.com')); $update->push(update => rr_del('byebye.example.com')); Perform a signed update my $key_name = 'tsig-key'; my $key_data = '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_data); Another way to perform a signed update my $key_name = 'tsig-key'; my $key_data = '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_data")); Perform a signed update with a customized TSIG record my $key_name = 'tsig-key'; my $key_data = 'awwLOtRfpGE+rRKF2+DEiw=='; my $tsig = Net::DNS::RR->new("$key_name TSIG $key_data"); $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
WARNING: 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, Net::DNS, Net::DNS::Resolver, Net::DNS::Header, Net::DNS::Packet, Net::DNS::Question, Net::DNS::RR, RFC 2136, RFC 2845 perl v5.16.2 2012-01-27 Net::DNS::Update(3)
All times are GMT -4. The time now is 09:07 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy