10 More Discussions You Might Find Interesting
1. Programming
Here is my select that I have to identify the child records that are Open (e.c7 < 6000) when the parent (t2068) c.c7 > 3
SELECT c.c1000000161,
c.c7,
c.c1000000019,
e.c1000000829
FROM
t2068 c INNER JOIN t1533 e ON e.c1000000829 = c.c301572100
where
c.c7 > 3... (2 Replies)
Discussion started by: newborndba
2 Replies
2. Shell Programming and Scripting
Guys,
Running on Linux Ubuntu.
I need to find a method to automatically update all the rows for 2 columns and only if the rows not null.
e.g : based on the example data below, I want to update all rows under column 2 and 3 (COL2, COL3) with an increment of 1 and only if the value is not... (7 Replies)
Discussion started by: faizalms
7 Replies
3. Shell Programming and Scripting
Hello,
I want to check the value of all MySQL columns.(column name is "status") via bash script.
If value is "0" at I want to make only single column value to "1"
I have many "0" values on mysql database(on "status" column)
"0" means it is a draft post. I want to publish a post. I... (2 Replies)
Discussion started by: tara123
2 Replies
4. Shell Programming and Scripting
I Have a file a.txt in the below format
1 23 50
1 25 6666666666666
1 23 34
If the third column value is greater than two digit then make it 0
New Data File
---------------
a.txt
1 23 50
1 25 0
1 23 34
Need your help regarding this (5 Replies)
Discussion started by: deep_kol
5 Replies
5. Shell Programming and Scripting
I have to update my file from server file.
Server file A on location
serverfile="/orf/ddl/plokall/fileA"
myfile=""/orf/ddl/plokall/myupdatedfile"
fileA:
KALKIKLOKPO001 10.1
HFJFKSLOKPO002 11.4
POLKAK5143 184.3
POLKJI5144 107.5
OKILDL5145 107.10
CVT0909 10.11
KJL0405... (3 Replies)
Discussion started by: asavaliya
3 Replies
6. Shell Programming and Scripting
I need to update a text file within a loop so that the value is added creating a new column at the end. I cannot use paste because I dont know the number of files. If I use >> the value is added after the last row. Please help.
For example:
Input file:
Column 1 Column2
- ... (2 Replies)
Discussion started by: Surabhi_so_mh
2 Replies
7. Shell Programming and Scripting
Hi all
I am new to scripting and i have an application from which i will export into a csv file as follows
Column1, Column2, Column3
Sno1, Folder\Test.txt, Fail
Sno2, Folder\Test1.txt, Pass
Sno3, Folder\Test2.txt, Fail
Now i need to change the column2 in all the rows from "Folder\"
... (1 Reply)
Discussion started by: rajeshrp
1 Replies
8. Shell Programming and Scripting
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
9. Shell Programming and Scripting
I have two files:
fileA
a,b,c,10,apple
a,b,c,20,orange
a,b,c,10,grape
d,e,f,5,pear
d,e,f,100,pear
x,y,z,15,lemon
x,y,z,20,apple
x,y,z,30,grape
fileB
a,b,c,20
d,e,f,100
x,y,z,30
If col1=col1,col2=col2 and col3=3 of fileA to fileB, then take value in 4th col of fileB and replace... (5 Replies)
Discussion started by: giannicello
5 Replies
10. UNIX and Linux Applications
I am running a Informix-4GL program to insert/update/delete on a particular table (say xxx). Now I want to create a logfile in unix which will store the affected data(say xxx.*) along with user information (say uname,IP address etc.)
what command I should use from Informix-4GL ?
I have tried the... (0 Replies)
Discussion started by: subhamukh
0 Replies
tinydyndns-update(8) System Manager's Manual tinydyndns-update(8)
NAME
tinydyndns-update - update TYPE A record in data.cdb
SYNOPSIS
tinydyndns-update fqdn dynip
DESCRIPTION
tinydyndns-update changes the data of a TYPE A record in data.cdb in the current directory. Other than tinydns-data(8), tinydndns-update
does not know about the source file data but changes the binary database data.cdb directly.
First tinydyndns-update checks if the given fqdn has a TYPE A record in data.cdb. Then it checks if the given IP address differs from the
one in the TYPE A record in data.cdb, or if the record's timestamp should be updated. Finally if data.cdb needs to change, tinydyndns-
update copies data.cdb to data.tmp, changes the IP address of the TYPE A record of fqdn to dynip in data.tmp, optionally adjusts time-to-
live or time-to-die, and renames data.tmp to data.cdb.
ENVIRONMENT
TTL time-to-live. The environment variable TTL overrides the default time-to-live in seconds (0 if TTD is set, otherwise 5). If TTL is
not set or zero, the time-to-live of the record will not change. $TTL must be an integer.
TTD time-to-die. $TTD must be an integer, specifying a number of seconds. If TTD is set, the timestamp of the record is set to the
current time plus $TTD seconds, and TTL is set to zero by default, so that tinydns(8) interpretes the timestamp as time-to-die.
Note: you probably want to adjust SOA ttl, or create a wildcard record, to prevent DNS caches from caching nxdomain, when using this
feature.
LOC location. $LOC must be two characters long. If LOC is set, it specifies the client location for records to be updated.
EXIT CODES
If tinydyndns-update cannot find a TYPE A record for fqdn in data.cdb, it prints a warning and exits 114.
If dynip does not differ from the IP address of the TYPE A record of fqdn in data.cdb, and the environment variable TTD is not set, tiny-
dyndns-update prints a note and exits 0.
tinydyndns-update exits 100 if it has trouble opening data.cdb, and leaves data.cdb unchanged.
tinydyndns-update exits 111 on temporary error, and leaves data.cdb unchanged.
If data.cdb was changed successfully, tinydyndns-update exits 0.
FILES
./data.cdb
./data.tmp
SEE ALSO
tinydyndns-data(8), tinydyndns-conf(8)
http://smarden.org/tinydyndns/
AUTHOR
Gerrit Pape <pape@smarden.org>
tinydyndns-update(8)