How to pass a date read from database to the shell script? Post: 302353533

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

read a file as input and pass each line to another script

Hi, I am trying to write a ftp script which will read a file for filenames and ftp those files to another server. Here's my ftp script, but it's scanning the current directory for file names. My question is how can I pass multiple files (these files will have the name of data files that need to...

2. Shell Programming and Scripting

getting date from shell and pass it to java

Hi, I have a variable called asOfDate in shell script. I need to pass it as a command line argument to a java command which will be called from the same shell script. The format of that variable is "MM/DD/YYYY" while doing echo, it is printing correctly in the java command. ie....

3. Shell Programming and Scripting

Read Oracle Username password SID from single file and pass it to shell

Dear All I am trying to write one shell which will be running through Cron which contain one SQL query. But I want to draw/fetch the Username password and Instance name (required to loging to the database) from one single file to run that SQL query . Also this file contain details of multiple...

4. Shell Programming and Scripting

How to pass a variable as a parameter to DB2 database from shell script

I need to pass a variable as a parameter from shell script into a DB2 database. var=bhuk_1123_Q_11/22/09 select * from tbl1 where serial_id='$var'; I have tried executing it using db2 -tvf scriptname Somebody please help me out with this. It is throwing an error. Please tell me how...

5. Shell Programming and Scripting

The scope of the shell/perl script is to read the input text file. Validate the expiry date of each

The scope of the shell/perl script is to read the input text file. Validate the expiry date of each certificate and send the mail to the user. The user takes action to add the new certificate to the storage file and user owns the responsibility to update the input text file with the new certificate...

6. Shell Programming and Scripting

Unable to pass shell script variable to awk command in same shell script

I have a shell script (.sh) and I want to pass a parameter value to the awk command but I am getting exception, please assist. diff=$1$2.diff id=$2 new=new_$diff echo "My id is $1" echo "I want to sync for user account $id" ##awk command I am using is as below cat $diff | awk...

7. Shell Programming and Scripting

Read input from file and pass it to sub shell

i have a scenario where in i have to monitor jobs which run in different servers, The job details(job name, host server, etc) are present in a dat file. I have written a script a script which reads the details from the dat file and calls a local method where the job monitoring logic is present....

8. UNIX for Dummies Questions & Answers

How to write Config shell script to pass variables in master shell script?

Dear Unix gurus, We have a config shell script file which has 30 variables which needs to be passed to master unix shell script that invokes oracle database sessions. So those 30 variables need to go through the database sessions (They are inputs) via a shell script. one of the variable name...

9. Shell Programming and Scripting

How to write config shell script to pass variables in master shell script?

10. Shell Programming and Scripting

How to pass and read an array in ksh shell script function.?

I'm able to read & print an array in varaible called "filelist" I need to pass this array variable to a function called verify() and then read and loop through the passed array inside the function. Unfortunately it does not print the entire array from inside the funstion's loop. #/bin/ksh...

LEARN ABOUT DEBIAN

lbdb-fetchaddr

LBDB-FETCHADDR(1)						   User Manuals 						 LBDB-FETCHADDR(1)

NAME

       lbdb-fetchaddr - grab addresses from mails add append them to lbdb database

SYNOPSIS

       lbdb-fetchaddr [-d dateformat] [-x headerfieldlist] [-c charset] [-a]
       lbdb-fetchaddr [-v|-h]

DESCRIPTION

       lbdb-fetchaddr  is  a  shell  script  which reads a mail on stdin. It extracts the contents of some header fields (default: `From:', `To:',
       `Cc:',  `Resent-From:',	and  `Resent-To:')  from  the  mail  header  (only  addresses  with   a   real	 name)	 and   appends	 them	to
       $HOME/.lbdb/m_inmail.list.   For  performance  issues lbdb-fetchaddr appends new addresses to this file without removing duplicates. To get
       rid of duplicates, the program lbdb-munge exists, which is run by m_inmail if needed and removes duplicates.

       To use this program, put the following lines into your $HOME/.procmailrc:
	    :0hc
	    | lbdb-fetchaddr

       lbdb-fetchaddr writes the actual date to the third column of the database by using strftime(3).	It uses "%Y-%m-%d %H:%M"  as  the  default
       date  format (e.g. "1999-04-29 14:33"). You can change this by using the -d option to select a different date format string as parameter of
       lbdb-fetchaddr command like
	    :0hc
	    | lbdb-fetchaddr -d "%y-%m-%d"
       which results in e.g. "99-04-29".

OPTIONS

       -v     Print version number of lbdb-fetchaddr.

       -h     Print short help of lbdb-fetchaddr.

       -d dateformat
	      Use the given date format using strftime(3) syntax.

       -x headerfields
	      A colon separated list of header fields, which should be searched for mail addresses.  If this option isn't given, we fall  back	to
	      `from:to:cc:resent-from:resent-to'.

       -c charset
	      The  charset  which  will  be used to write the database. This should be the charset which the application expects (normally the one
	      from your current locale).  If this option isn't given, we fall back to `iso-8859-15'.

       -a     Also grab addresses without a real name.	Use the local part of the mail address as real name.

FILES

       $HOME/.lbdb/m_inmail.list
       /usr/lib/lbdb/fetchaddr
       /usr/lib/lbdb/m_inmail

SEE ALSO

       lbdbq(1), lbdb_dotlock(1), procmail(1), procmailrc(5), strftime(3).

CREDITS

       Most of the really interesting code of this program (namely, the RFC 822 address parser used by lbdb-fetchaddr)	was  stolen  from  Michael
       Elkins' mutt mail user agent. Additional credits go to Brandon Long for putting the query functionality into mutt.

AUTHOR

       The  lbdb  package  was	written by Thomas Roessler <roessler@guug.de> and is now maintained and extended by Roland Rosenfeld <roland@spin-
       naker.de>.

Unix								   October 2005 						 LBDB-FETCHADDR(1)