08-10-2010
Shell programing to implement SQL package
hi all,
i have a table with employee details like his name,addr,DOB etc.
i need a shell program which takes one date as input from user and print the employees whose DOB is less than that date.
in sql package the select query is written
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
A shell in crontab per 5 min write a file
B shell in crontab per 6 min read a file
how to lock the share file a ;avioid confilict in write and read?
Thx : -) (1 Reply)
Discussion started by: zz_xm
1 Replies
2. Shell Programming and Scripting
Hi folks,
In our product installation program we edit xml files by deleting lines and appending new lines instead of them.
For example:
update_Log4plsql_xml()
{
machineName=`uname -n`
hostIP=`cat /etc/hosts | grep ${machineName} | cut -f1`
trap 'clean_up | tee -a $installLog ; exit' 1 2... (0 Replies)
Discussion started by: nir_s
0 Replies
3. Linux
Well Acording to my job...
Anyhelp plz.
I need some basic scripting stuff. (3 Replies)
Discussion started by: Irish Jimmy
3 Replies
4. Programming
Hello
I need to translade the power of unix command shell (grep, sed, awk, wc, etc..) to windows.
In my work every day I administrate 15 unix server ans 18 windows server, and I have the problem the absolutly limitation of windows shell. I´m a system administrator but I know programming.
I... (2 Replies)
Discussion started by: dalmus
2 Replies
5. Shell Programming and Scripting
Hi...
i need to write a shell script wich shows the full name and
station of every logged user in the system.
pls help! (1 Reply)
Discussion started by: relu89
1 Replies
6. Shell Programming and Scripting
I'm working on a program in with shell programming and it needs to be able to delete the contents of files in the Home directory on certain days of the week.(like tuesday). Can anyone help me with this?
Thanks in advance, Taffy. (7 Replies)
Discussion started by: Taffy
7 Replies
7. Shell Programming and Scripting
How would you make sure that a shell script (or a portion thereof) does not run (it waits or it terminates with error) when another instance of it is already running? (11 Replies)
Discussion started by: colemar
11 Replies
8. Shell Programming and Scripting
I have been asked to create a shell script that accepts a number of SQL select queries as input, runs them in sequence, spools the output to an EXCEL workbook, where, each worksheet is an output of a Select statement run above.
The workbook should be in a .XLS format. If a particular select... (2 Replies)
Discussion started by: ShellNovice1
2 Replies
9. Homework & Coursework Questions
1. The problem statement, all variables and given/known data:
Write a Shell script to automatically check that a specified user is logged in to the computer.
The program should allow the person running the script to specify the name of the user to be checked, the frequency in seconds at... (5 Replies)
Discussion started by: operator
5 Replies
10. Shell Programming and Scripting
Hi,
I am facing one issue.I am working on one script where I want to implement one check
PSS/TFM/Coupon/trunk/CouponProject/CouponService/src/test/java/com/travelport/service/pss/coupon/validator/CouponValidationReqValidatorTest.java
Now my problem is or requirement is if the above... (1 Reply)
Discussion started by: anuragpgtgerman
1 Replies
DP(8) [nmh-1.5] DP(8)
NAME
dp - parse dates 822-style
SYNOPSIS
/usr/lib/mh/dp [-form formatfile] [-format string] [-width columns] [-version] [-help] dates ...
DESCRIPTION
Dp is a program that parses dates according to the ARPA Internet standard. It also understands many non-standard formats, such as those
produced by TOPS-20 sites and some UNIX sites using ctime(3). It is useful for seeing how nmh will interpret a date.
The dp program treats each argument as a single date, and prints the date out in the official 822-format. Hence, it is usually best to
enclose each argument in quotes for the shell.
To override the output format used by dp, the -format string or -format file switches are used. This permits individual fields of the
address to be extracted with ease. The string is simply a format string and the file is simply a format file. See mh-format(5) for the
details.
Here is the default format string used by dp:
%<(nodate{text})error: %{text}%|%(putstr(pretty{text}))%>
which says that if an error was detected, print the error, a `:', and the date in error. Otherwise, output the 822-proper format of the
date.
FILES
$HOME/.mh_profile The user profile
PROFILE COMPONENTS
None
SEE ALSO
ap(8), Standard for the Format of ARPA Internet Text Messages (RFC-822)
DEFAULTS
`-format' default as described above
`-width' default to the width of the terminal
CONTEXT
None
BUGS
The argument to the -format switch must be interpreted as a single token by the shell that invokes dp. Therefore, one must usually place
the argument to this switch inside quotes.
MH.6.8 11 June 2012 DP(8)