05-16-2013
We are using AIX. I have used Perderabo's datecalc. Was wondering is there any short code. For time being I 'm using database to get this going.
Thanks
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I have to kick off a script on every Monday to get some data from database for last week (Sunday thru Saturday).
If its Monday (12/12/2005)
Begin date will be Sunday - 12/4/2005
End date will be Saturday - 12/10/2005
The script might not kick off on some Mondays.
So my... (2 Replies)
Discussion started by: skymirror
2 Replies
2. UNIX for Dummies Questions & Answers
How to find last sunday (date) using perl?
Eg, If i run today (26-Feb-2008 / Tuesday), I should get 24-Feb-2008 (Sunday).
Any help? (3 Replies)
Discussion started by: deepakwins
3 Replies
3. Shell Programming and Scripting
I am currently running the following Korn shell script which works fine:
#!/usr/bin/ksh
count=`db2 -x "select count(*) from schema.tablename"`
echo "count"
I would like to add a "where" clause to the 2nd line that would allow me to get a record count of all the records from schema.tablename... (9 Replies)
Discussion started by: sasaliasim
9 Replies
4. Shell Programming and Scripting
Hi
Please help me with this problem
i need to find the date of last week sunday from the current given date (12 Replies)
Discussion started by: aishsimplesweet
12 Replies
5. Shell Programming and Scripting
Hi,
I want to compare today's date(DDMMYYYY) with yesterday(DDMMYYYY) from system date,if (today month = yesterday month) then execute alter query else do nothing.
The above requirement i want in Shell script(KSH)...
Can any one please help me?
Double post, continued here. (0 Replies)
Discussion started by: kumarmsk1331
0 Replies
6. Shell Programming and Scripting
Hi All,
I have a requirement in my project where a batch runs on any day of a week. The input files will land to the server every Sunday. I need to read these files based on the current BUS_DAY (which falls any day of the week).
For e.g : if the BUS_DAY is 20120308, we need to derive the... (3 Replies)
Discussion started by: dsfreddie
3 Replies
7. Shell Programming and Scripting
Hello,
I have a file like this:
2012112920121130
12345620121130msABowwiqiq
34477420121129amABamauee
e7748420121130ehABeheheei
in case the content of the file has the date of yesterday within the lines containing pattern AB this should be replaced by the current date. But if I use... (3 Replies)
Discussion started by: Lilu_CK
3 Replies
8. Shell Programming and Scripting
Hi
I want to get tomorrow and yesterday date from date command. My shell is KSH and server is AIX. I tried several options, but unable to do. Please help on this.
Regards
Rajesh (5 Replies)
Discussion started by: rajeshmepco
5 Replies
9. Shell Programming and Scripting
Hello,
I'd like to write a monthly archive script that archives some logs. But I'd like to do it based on yesterday's date. In other words, I'd like to schedule the script to run on the 1st day of each month, but have the archive filename include the previous month instead.
Here's what I... (5 Replies)
Discussion started by: nbsparks
5 Replies
10. Shell Programming and Scripting
hi all,
How to compare two files whether they are same are not...? like i had my input files as 20141201_file.txt and 20141130_file2.txt
how to compare the above files based on date .. like todays file and yesterdays file...? (4 Replies)
Discussion started by: hemanthsaikumar
4 Replies
LEARN ABOUT DEBIAN
databases
databases(5) GNATS configuration files databases(5)
NAME
databases - the known set of GNATS databases
DESCRIPTION
The databases configuration file is a site-wide configuration file containing the list of GNATS databases that are available either on the
host itself or remotely over the network, together with some parameters associated with each database. It is located in the directory
/usr/share/gnats.
The file contains one line for each database. For databases located on the host itself, each line consists of three fields separated by
colons:
database name:short description:/path/to/database
The first field is the database name. This is the name used to identify the database when invoking programs such as query-pr or send-pr,
either by using the --database option of the program or by setting the GNATSDB environment variable to the name of the database. The sec-
ond field is a short human-readable description of the database contents, and the final field is the directory where the database contents
are kept.
For a database that is located across a network, but which should be accessible from this host, the entry for the database should look like
this:
database name:short description of database::hostname:port
The first two fields are the same as for local databases, the third field is empty (notice the two adjacent `:' symbols, indicating an
empty field), the fourth field is the hostname of the remote GNATS server, and the fifth field is the port number that the remote GNATS
server is running on.
Note that if you add a new local database, you must create its data directory, including appropriate subdirectories and administrative
files after adding an entry to databases. This is best done using the mkdb tool.
Lines beginning with a # are ignored.
The database name default is special; this is the entry used if no database name is specified via a --database option or the GNATSDB envi-
ronment variable.
SEE ALSO
Keeping Track: Managing Messages With GNATS (also installed as the GNU Info file gnats.info)
databases(5), dbconfig(5), delete-pr(8), edit-pr(1) file-pr(8), gen-index(8), gnats(7), gnatsd(8), mkcat(8), mkdb(8), pr-edit(8), query-
pr(1), queue-pr(8), send-pr(1).
COPYING
Copyright (c) 1993, 2000, 2003, Free Software Foundation, Inc.
Permission is granted to make and distribute verbatim copies of this manual provided the copyright notice and this permission notice are
preserved on all copies.
Permission is granted to copy and distribute modified versions of this manual under the conditions for verbatim copying, provided that the
entire resulting derived work is distributed under the terms of a permission notice identical to this one.
Permission is granted to copy and distribute translations of this manual into another language, under the above conditions for modified
versions, except that this permission notice may be included in translations approved by the Free Software Foundation instead of in the
original English.
GNATS
August 2003 databases(5)