Need code for updating second record to first record in shell 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..
Result as follows
Above statement always displays 1 or 2 records.If the above query returns 2 rows then i need to update it to 1 row like below
And then i need to execute INSERT statements by using ID as a parameter.
whenever i use ${ID} it should be place with the updated value 1.
insert into <TABLE>values ();
For the above requirement, i need to implement it in shell scripting and i am using nzsql.
Thanks in advance.
Cheers,
Samah
Last edited by Don Cragun; 06-28-2016 at 09:13 PM..
Reason: Fix CODE tags inside CODE tags.
Hi,
I am new to UNIX scripting and woiuld appreicate your help...
Input file contains only one (but long) record:
aaaaabbbbbcccccddddd.....
Desired file:
NEW RECORD #new record (hardcoded) added as first record - its length is irrelevant#
aaaaa
bbbbb
ccccc
ddddd
...
...
... (1 Reply)
My input file like this
01,011600033,011600033,110516,0834,2,90,,2/
02,011600033,011103093,1,110317,0834,,2/
03,105581,,015,+00000416418,,,901,+00000000148,,,922,+00000000354,,/
49,+00000000000416920,00002/
03,113806,,015,+00000559618,,,901,+00000000096,,,922,+00000000621,,/... (1 Reply)
My input file like this
03,105581,,015,+00000416418,,,901,+00000000148,,,922,+00000000354,,/
03,113806,,015,+00000559618,,,901,+00000000096,,,922,+00000000621,,/
03,188986,,015,+00005211517,,,901,+00000002227,,,922,+00000005308,,/... (6 Replies)
Hi,
I have a input file with the following entries:
1one
2two
3three
1four
2five
3six
1seven
1eight
1nine
2ten
The output should be
1one
2two
3three
1four
2five
3six (2 Replies)
Hi,
How to add trailer record at the end of the flat file in the unix ksh shell scripting
can you please let me know the procedure
Regards
Srikanth (3 Replies)
find pattern, delete line with pattern and 3 lines above and 8 lines below the pattern. The pattern is "isup". The entire record with starting tag <record> and ending tag </record> containing the pattern is to be deleted and the rest to be retained.
<record>
... (4 Replies)
Hi! all
can any one tell me how to compare current record of column with next and previous record in awk without using array
my case is like this
input.txt
0 32
1 26
2 27
3 34
4 26
5 25
6 24
9 23
0 32
1 28
2 15
3 26
4 24 (7 Replies)
ldns-read-zone(1) General Commands Manual ldns-read-zone(1)NAME
ldns-read-zone - read a zonefile and print it
SYNOPSIS
ldns-read-zone ZONEFILE
DESCRIPTION
ldns-read-zone reads a DNS zone file and prints it. The output has 1 resource record per line, and no pretty-printing makeup.
OPTIONS -c Canonicalize all resource records in the zone before printing
-d Only print DNSSEC data from the zone. This option skips every record that is not of type NSEC, NSEC3, RRSIG or DNSKEY. DS records
are not printed.
-h Show usage and exit
-n Do not print the SOA record
-s Strip DNSSEC data from the zone. This option skips every record that is of type NSEC, NSEC3, RRSIG or DNSKEY. DS records are still
printed.
-S [[+|0]number | YYYYMMDDxx | unixtime ]
Set serial number to the given number, or when preceded by a sign, offset the exisiting number with it. When giving the literal
strings YYYYMMDDxx or unixtime, the serial number is tried to be reset in datecounter or in unixtime format respectively. Though is
the updated serial number is smaller than the original one, the original one is simply increased by one.
When updating a serial number, records of type NSEC, NSEC3, RRSIG and DNSKEY will be skipped when printing the zone.
-v Show the version and exit
-z Sort the zone before printing (this implies -c)
AUTHOR
Written by the ldns team as an example for ldns usage.
REPORTING BUGS
Report bugs to <ldns-team@nlnetlabs.nl>.
COPYRIGHT
Copyright (C) 2005 NLnet Labs. This is free software. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PUR-
POSE.
30 May 2005 ldns-read-zone(1)