02-20-2016
Quote:
Originally Posted by
rohit_shinez
... can any modification done from my query which i have posted ...
Yes, and that's exactly what I did. I started with your query as the starting point and ended up at the posted query.
Quote:
Originally Posted by
rohit_shinez
... while taking 500 i need take greatest(500,T1 max_amt) ...
Post an example of what the output looks like for such a case. How are the ranges shifted? What are their intervals? What is the final output? You can take the example you posted earlier or a new one.
Quote:
Originally Posted by
rohit_shinez
...if i change the value of 500 to another value for eg. 200 it doesnt work
How do you determine it doesn't work?
What do you look for in the output? Or, how is the output different from what you expect?
Post an example to demonstrate the difference between what you expect and what you get.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
HI all
I'm trying to write an awk script to print the min and max value in a range(s) contained in another file - the range values are in $2
EG
114,7964,1,y,y,n
114,7965,1,y,y,n
114,7966,1,y,y,n
114,7967,1,y,y,n
114,7969,1,y,y,n
114,7970,1,y,y,n
114,7971,1,y,y,n
114,7972,1,y,y,n... (3 Replies)
Discussion started by: Mudshark
3 Replies
2. Shell Programming and Scripting
Hi,
I have writtena script that will recursivly go into subdirecotries and report out what files there are in there that have not been accessed over various date ranges.
I do this using a number of find commands:
find . -path './.snapshot' -prune -o -type f -atime -8
find... (4 Replies)
Discussion started by: littleIdiot
4 Replies
3. Shell Programming and Scripting
Hi people,
I have 2 files, one with a list of non consecutive ranges (File1.txt), where each range begins with the value in column 1
and finishes with the value in column 2 in the same line, as can be seen above.
215312581156279 215312581166279
215312582342558 215312582357758... (4 Replies)
Discussion started by: cgkmal
4 Replies
4. Shell Programming and Scripting
Hi,
Please anyone help to achive this using perl or unix scripting .
This is date in my table 20090224,based on the date need to check the files,If file exist for that date then increment by 1 for that date and check till max date 'i.e.20090301 and push those files .
files1_20090224... (2 Replies)
Discussion started by: akil
2 Replies
5. Shell Programming and Scripting
hi !
how can i get files in a directory between certain date ranges ?
say all files created/modified between Jan24 - Jan31
thanks (10 Replies)
Discussion started by: aliyesami
10 Replies
6. Shell Programming and Scripting
Hi, I need to create weekly files from daily records stored in individual monthly filenames from 1999-2010. my sample file structure is like the ones below:
daily record stored per month:
199901.xyz, 199902.xyz, 199903.xyz, 199904.xyz ...199912.xyz
records inside 199901.xyz (original data... (4 Replies)
Discussion started by: ida1215
4 Replies
7. Shell Programming and Scripting
Hi,
I have two files
file1 chr1_22450_22500
chr2_12300_12350
chr1_34500_34550
file2 11000_13000
15000_19000
33000_44000
If the file 1 ranges fall between file2 ranges then assign the value of file2 in column 2 to file1
output:
chr2_12300_12350 11000_13000
chr1_34500_34550 ... (7 Replies)
Discussion started by: Diya123
7 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I have a tab delimited text file with multiple columns. The second and third columns include numbers that have not been sorted. I want to extract rows where the second column includes a value between -0.01 and 0.01 (including both numbers) and the first third column includes a value between... (1 Reply)
Discussion started by: evelibertine
1 Replies
9. Shell Programming and Scripting
Need to get saturday's date of the previous week.
Input will be the sysdate (today's date)
Output should be previous weeks's saturday format
Your help is required extremely.
I have done all the date arthimetic calculation, but not getting the desired output. Please help (10 Replies)
Discussion started by: help_scr_seeker
10 Replies
10. Shell Programming and Scripting
Hi There, Good Day !!
I have txt file containing data in the below format. There are many lines, here i have mentioned for example.
cat remo.txt
2/3/2017 file1
3/4/2016 file2
6/6/2015 file5
1/1/2018 file3
4/3/2014 file4
-
-
-
I need to grep the file names for given date rage... (11 Replies)
Discussion started by: kumar85shiv
11 Replies
LEARN ABOUT HPUX
sys_attrs_kevm
sys_attrs_kevm(5) File Formats Manual sys_attrs_kevm(5)
NAME
sys_attrs_kevm - KEVM (Kernel Event Manager) subsystem attributes
DESCRIPTION
This manpage lists and describes attributes for the Kernel Event Manager subsystem. See evm(5) for more information about Event Manager
software.
An asterisk preceding the name of an attribute in the following list means that the attribute can be configured at run time. Values of
other attributes cannot be changed without rebooting the system.
A value that can be used to reinitialize all of the
attributes. Changing to any non-zero value causes all the attributes to be reset to zero, and then itself is automatically reset
to zero.
Default value: 0
Minimum value: 0
Maximum value: 2,147,483,647
If you use to change the value of the updated attribute values are not visible until you exit and restart
The number of EVM events currently queued in kernel space for
collection by the EVM daemon. This attribute is query only.
The size (in bytes) of the fixed buffer used to queue any EVM events
that are posted while the kernel is executing at interrupt level. Events are moved out of the buffer as soon as the system
returns to normal operating mode. The default buffer size should be adequate for most systems.
Default value: 65, 536 (bytes)
Minimum value: 1
Maximum value: 1,844,674,407,370
A value that indicates whether a process (such as
currently has or does not have the interface in an open state. The value 1 means that a process has the interface open (always
the case if is running) and the value 0 means that no process has the interface open. This attribute is query only.
The major device number being used by the
interface. This attribute is query only.
The number of EVM events that have been posted in the kernel since the
the system was started or the counter was reset. You can reset directly, or by changing to a non-zero value.
Minimum value: 0
Maximum value: 2,147,483,647
The number of EVM events that have been read from kernel space by the
EVM daemon since the system was started or the counter was reset. You can reset manually or by changing to a non-zero value.
Minimum value: 0
Maximum value: 2,147,483,647
The highest number of EVM events that have been queued in kernel space
waiting to be collected by the EVM daemon since the system was started or the counter was reset. You can reset manually or by
changing to a non-zero value.
Minimum value: 0
Maximum value: 2,147,483,647
SEE ALSO
evm(5).
System Administration
sys_attrs_kevm(5)