Hi all,
Pls consider the following script.
in the above script i am trying to insert the data from trn_vehlog to rcur_test
using execute immediate.I am building the query based on the parameters passed to the shell script.
The query is built correctly as follows.
But ,execute immediate is not insertng the data into rcur_test table.
Any idea on this.
cheers
RRK
Last edited by Yogesh Sawant; 03-19-2008 at 04:53 AM..
Reason: added code tags
:cool:
I need to execute a shell script to do the following:
cat a file
run two back ground processes using the first two values from the file
wait till those background processes finish
run two more background processes using the next two values from the file
wait till those background... (1 Reply)
o
hola..
Tengo un script que se ejecuta bajo una tarea del CronJOb del unix, tengo la version 11 de unix, mi script tiene un ciclo que lee unos archivos .txt luego cada uno de esos archivos debe pasar por un procedimiento almacenado el cual lo tengo almacenado en mi base de datos oracle 10g,... (4 Replies)
Hi All
I have a file containing the following information
SOURCESERVER DESTINATIONSERVER DESTINATIONENVIRONMENT CONDITION
I was trying to read and then execute the conditions,like if SOURCESERVER is XXXX0001 and the DESTINATIONSERVER is XXXX0002 and the DESTINATIONENV is YYY the... (3 Replies)
Hi,
I have a shell scripting. This will take 7 digit number in each line and add 7 digit number with next subsequent lines ( normal addition ).
Eg:
0000001
0000220
0001235
0000022
0000023
...........
.........
........
Like this i am having around 1500000 records. After adding... (23 Replies)
In LINUX(CentOS, RedHat) is there a way to have the banner statement appear before the logon instead of after the logon? In UNIX and Windows the banner appears before a person actually logs on, what I'm seeing in LINUX is that it appears after the login(ftp, telnet, SSH).
Thanks (0 Replies)
Hi,
I have a query for executing the script. I have a script in korn shell. Now I want to execute that script in the born shell. How can I execute. (3 Replies)
I am trying to understand why the runnable jar file runs on one Unix server, but not the other with same environment settings.
I copied exact same test jar from here -->
http://www.javaworld.com/javaworld/javatips/javatip127/MakeJarRunnable.zip
on to both Unix servers. Then changed... (5 Replies)
Hello everyone, I'm in need of some assistance. I'm currently enrolled in an introductory UNIX shell programming course and, well halfway through the semester, we are receiving our first actual assignment. I've somewhat realized now that I've fallen behind, and I'm working to get caught up, but for... (1 Reply)
Hi All,
I am using the below script which has awk command, but it is not returing the expected result. can some pls help me to correct the command.
The below script sample.ksh should give the result if the value of last 4 digits in the variable NM matches with the variable value DAT. The... (7 Replies)
Discussion started by: G.K.K
7 Replies
LEARN ABOUT REDHAT
times
TIMES(2) Linux Programmer's Manual TIMES(2)NAME
times - get process times
SYNOPSIS
#include <sys/times.h>
clock_t times(struct tms *buf);
DESCRIPTION
The times() function stores the current process times in the struct tms that buf points to. The struct tms is as defined in <sys/times.h>:
struct tms {
clock_t tms_utime; /* user time */
clock_t tms_stime; /* system time */
clock_t tms_cutime; /* user time of children */
clock_t tms_cstime; /* system time of children */
};
The tms_utime field contains the CPU time spent executing instructions of the calling process. The tms_stime field contains the CPU time
spent in the system while executing tasks on behalf of the calling process. The tms_cutime field contains the sum of the tms_utime and
tms_cutime values for all waited-for terminated children. The tms_cstime field contains the sum of the tms_stime and tms_cstime values for
all waited-for terminated children.
Times for terminated children (and their descendants) is added in at the moment wait(2) or waitpid(2) returns their process ID. In particu-
lar, times of grandchildren that the children did not wait for are never seen.
All times reported are in clock ticks.
RETURN VALUE
The function times returns the number of clock ticks that have elapsed since an arbitrary point in the past. For Linux this point is the
moment the system was booted. This return value may overflow the possible range of type clock_t. On error, (clock_t) -1 is returned, and
errno is set appropriately.
NOTES
The number of clock ticks per second can be obtained using
sysconf(_SC_CLK_TCK);
In POSIX-1996 the symbol CLK_TCK (defined in <time.h>) is mentioned as obsolescent. It is obsolete now.
On Linux, if the disposition of SIGCHLD is set to SIG_IGN then the times of terminated children are automatically included in the
tms_cstime and tms_cutime fields, although POSIX 1003.1-2001 says that this should only happen if the calling process wait()s on its chil-
dren.
Note that clock(3) returns values of type clock_t that are not measured in clock ticks but in CLOCKS_PER_SEC.
CONFORMING TO
SVr4, SVID, POSIX, X/OPEN, BSD 4.3
HISTORICAL NOTES
SVr1-3 returns long and the struct members are of type time_t although they store clock ticks, not seconds since the epoch. V7 used long
for the struct members, because it had no type time_t yet.
On older systems the number of clock ticks per second is given by the variable HZ.
SEE ALSO time(1), getrusage(2), wait(2), clock(3), sysconf(3)Linux 2002-06-14 TIMES(2)