10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi Guys,
i am having .sql script which inserts data from one table to another table based on date condition, i need to pass range on based on how many number of months, for e.g
set timing on;
whenever sqlerror exit failure;
spool myscript.log append
accept start_date... (7 Replies)
Discussion started by: rohit_shinez
7 Replies
2. Shell Programming and Scripting
Dear all,
how can I select in the file below only the files created between Aug 14 2014 and Feb 03 2015?
EZA2284I -rw-r--r-- 1 30 8 356954 Aug 15 2014 file1
EZA2284I -rw-rw-r-- 1 30 8 251396 Feb 05 12:53 file2
EZA2284I -rw-rw-r-- 1 30 8 ... (3 Replies)
Discussion started by: simomuc
3 Replies
3. UNIX for Dummies Questions & Answers
My unix version is IBM AIX Version 6.1
I tried google my requirement and found the below answer,
find . -newermt “2012-06-15 08:13" ! -newermt “2012-06-15 18:20"
But newer command is not working in AIX version 6.1 unix
I have given my requirement below:
Input:
atr files:
... (1 Reply)
Discussion started by: yuvaa27
1 Replies
4. UNIX for Dummies Questions & Answers
Hi
i am try to run a script by using a dates here is what i am doing
EXPORTDATE=`date --date "2 days ago" +%Y-%m-%d`
sh /path/to/the/files.sh ${EXPORTDATE}
the above code runs the job for one day,if i want to run the job for all the past 4 days how can i pass the date as a... (1 Reply)
Discussion started by: vikatakavi
1 Replies
5. Shell Programming and Scripting
Solaris 10
ksh88
Sorry for re-hashing some of this, but I can't find a proper solution in the forums.
Starting with /a/archive containing (on and on date formatted directories)
20060313 20080518 20100725 20121015
20060314 20080519 ... (1 Reply)
Discussion started by: moesplace
1 Replies
6. Shell Programming and Scripting
Hi Everyone How all are doing today,
Want some help from All in Unix, What I am trying to do is , A shell file should be a called with two date parameters suppose the shell file name is run.sh
run.sh <start_date> <end_date>
If end date is not given it will pick today's date. The date should... (7 Replies)
Discussion started by: adisky123
7 Replies
7. Shell Programming and Scripting
Hi,
I am writting a script. i am not sure what i am trying to do is possible or not. thats why asking the best of the best.
the script i want to write will recieve as input parameters 2 different options.
as in
MODE 1
-- start_date / end_date (2 dates has 2 go at a time
MODE 2... (2 Replies)
Discussion started by: dazdseg
2 Replies
8. Shell Programming and Scripting
Hi All,
I need to run a job every month at the beginning of the month which is scheduled through autosys, lets say on 03/01/2010. I need to pass the last month's i.e February's first_date = 02/01/2010 and last_date = 02/28/2010 as variables to a stored procedure. Can somebody please pass... (2 Replies)
Discussion started by: vigdmab
2 Replies
9. UNIX Desktop Questions & Answers
I have a number of instances wher I need to run reports for the previous month and need to include the last months date range in the sql.
I want to create a string which consists of the first and last dates of last month separated with an ' and ' ie for this month (Feb) I want it to say
'01/01/10... (3 Replies)
Discussion started by: Niven
3 Replies
10. Shell Programming and Scripting
Hi Experts,
I have files name
report_20090416
report_20090417
report_20090418
report_20090420
report_20090421
I have 2 input from user
From Date: 20090417
To Date: 20090420
and I need to grep only those line in between. Output should be
report_20090417
report_20090418... (3 Replies)
Discussion started by: tanit
3 Replies