09-30-2008
code to identify the New Quarter
I am a sql programmer, I don't know much about UNIX. I want to modify the existing unix script
-----------------------------------------------------------------
............
cd /home/location/file
set timing on
sqlplus user/$IDPW <<!
prompt RUNNING NEW QUARTER PROCESSING. PLEASE WAIT.
@/home/location/file/new_period.sql
prompt LOADING NEXT TABLES. PLEASE WAIT.
@/home/location/file/file_next.sql
!
echo "TABLES HAVE FINISHED LOADING."
echo "Check output listings: files.lst"
----------------------------------------------------------------
With the following logic:
Get the system date
If system date month = February, May, August, November
prompt RUNNING NEW QUARTER PROCESSING. PLEASE WAIT.
@/home/location/file/new_period.sql
Else
prompt LOADING NEXT TABLES. PLEASE WAIT.
@/home/location/file/file_next.sql!
echo "TABLES HAVE FINISHED LOADING."
echo "Check output listings: files.lst"
Any help will be really appreciated.
Thank you.
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hello everyone,
this question is probably simple for you ppl but i am jus a beginner and still learing. i was wondering if someone could tell me that how does unix identify different program codes in it's environment.
for example, unix recognises this C code in the body of any script. how... (2 Replies)
Discussion started by: a25khan
2 Replies
2. UNIX for Advanced & Expert Users
I im just a beginner here. I wanted to know how to calculate the Quarter of a Month, and i want to assign Number like if the month falls on 1st quarter then i have to assign to 1 then going on till the last Quarter!!
Any help will be much use to me..
~Renne (2 Replies)
Discussion started by: pidu_rak
2 Replies
3. Shell Programming and Scripting
CTB_KT_OllyotLvos_20081204_164352_200811.txt
CTB_KT_LN_utahfwd_20081204_164352_200811.txt
CTB_KT_LN_utahfwd_Summ_20081204_164352_200811.txt
CTB_KT_PML_astdt_prFr_20081204_210153_200811.txt
CTB_KT_PML_astdt_prOt_20081204_210153_200811.txt
CTB_KT_PML_astdt_Nopr_20081204_210153_200811.txt... (7 Replies)
Discussion started by: w020637
7 Replies
4. Shell Programming and Scripting
Hi All,
I am trying to generate quarter dates with user giving input as begin date and end date. Example: Input by user:
begin_date = "2009-01-01"
end_date = 2010-04-30"
required output:
2009-01-01 2009-03-31 09Q01
2009-04-01 2009-06-30 09Q02
.
.
till
2010-01-01 2010-03-31 10Q01
... (9 Replies)
Discussion started by: sol_nov
9 Replies
5. UNIX for Dummies Questions & Answers
Hi
I need to produce a report that the start date must be the first day of the current quarter. Therefore a repor that is run today the start date would be 01/10/2010 (ddmmyyyy).
Obvioulsy I could hard code this date in but what happens when the report is run in January the start of the... (6 Replies)
Discussion started by: theref
6 Replies
6. UNIX for Dummies Questions & Answers
Dear Members,
Depending on the current date i should find out the start and end dates of the quarter.
ex: Today date is 14-Nov-2011 then Quarter start date should be Oct 1 2011 and Quarter End date should be Dec 31 2011.
How can i do this?
Thanks
Sandeep (1 Reply)
Discussion started by: sandeep_1105
1 Replies
7. Shell Programming and Scripting
Hi ,
I need to trigger few jobs based on the system date ( in case user is not passing any date to the script. In case passing then need to take the user date).
Here is the requirement
1. Everyday call daily script
2. On 1st day of week call weekly script
3. On 1st day of month call... (4 Replies)
Discussion started by: Anupam_Halder
4 Replies
8. Shell Programming and Scripting
Hi,
Trying to automate a Postgres query using Shell script
Every month 1st week has to run a Monthly Queries to generate delimited files.
July 1st start of fiscal yr which has 4 Quarters until next June 30th
Example
If I'm running on Sept 5th it has to generate one file(Becuase it... (12 Replies)
Discussion started by: krux_rap
12 Replies
9. Linux
Hi,
My question is how to calculate the quarter end date according to the current date in shell script? (2 Replies)
Discussion started by: Divya_1234
2 Replies
LEARN ABOUT OSX
platform::shell
platform::shell(n) Tcl Bundled Packages platform::shell(n)
__________________________________________________________________________________________________________________________________________________
NAME
platform::shell - System identification support code and utilities
SYNOPSIS
package require platform::shell ?1.1.4?
platform::shell::generic shell
platform::shell::identify shell
platform::shell::platform shell
_________________________________________________________________
DESCRIPTION
The platform::shell package provides several utility commands useful for the identification of the architecture of a specific Tcl shell.
This package allows the identification of the architecture of a specific Tcl shell different from the shell running the package. The only
requirement is that the other shell (identified by its path), is actually executable on the current machine.
While for most platform this means that the architecture of the interrogated shell is identical to the architecture of the running shell
this is not generally true. A counter example are all platforms which have 32 and 64 bit variants and where a 64bit system is able to run
32bit code. For these running and interrogated shell may have different 32/64 bit settings and thus different identifiers.
For applications like a code repository it is important to identify the architecture of the shell which will actually run the installed
packages, versus the architecture of the shell running the repository software.
COMMANDS
platform::shell::identify shell
This command does the same identification as platform::identify, for the specified Tcl shell, in contrast to the running shell.
platform::shell::generic shell
This command does the same identification as platform::generic, for the specified Tcl shell, in contrast to the running shell.
platform::shell::platform shell
This command returns the contents of tcl_platform(platform) for the specified Tcl shell.
KEYWORDS
operating system, cpu architecture, platform, architecture
platform::shell 1.1.4 platform::shell(n)