12-24-2012
Will tbl_daily_status reflect WHICH job had that stat and endtime?
10 More Discussions You Might Find Interesting
1. Programming
I'm having a oracle server and i'm having a table in that.
I'm having a linux server which is in network with the oracle server. I need to write a c program in linux env when on execution loads the table with the text file given as input.
Please explain me the flow of process in that and also... (6 Replies)
Discussion started by: rramprasad
6 Replies
2. UNIX for Advanced & Expert Users
Hi,
I have delimited file(|).
Sample data:
1|name|50009|DS24|0|12
2|name|30009|DS24|0|13
3|name|20409|DS24|0|14
4|name|20009|DS24|0|15
5|name|10009|DS24|0|16
I want to load this data into a oracle table (update and insert)
Please help me the commands and also... (1 Reply)
Discussion started by: unihp1
1 Replies
3. Shell Programming and Scripting
This is the sample sqlldr log:
------------------------------------------------------------------------------------------------------------
SQL*Loader: Release 9.2.0.7.0 - Production on Sun Feb 8 23:37:02 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Control... (13 Replies)
Discussion started by: aimy
13 Replies
4. Shell Programming and Scripting
Hi
I am having three oracle databases running in three different machine. their ip address is different. from one of the DB am able to access both the databases.(means am able to select values and insert values in to tables individually.)
I need to fetch some data from DB1 table(say DB1 ip is... (2 Replies)
Discussion started by: aemunathan
2 Replies
5. Shell Programming and Scripting
Hi,
I am trying to insert a record into a table (say dips_tbl) which resides in Oracle DB through a ksh script. I want to insert records into few of the table columns-not all. I'll give an e.g. for the date column "CREATE_DATE".
For that I first execute
SQL1="SELECT SYSDATE FROM DUAL"
... (1 Reply)
Discussion started by: dips_ag
1 Replies
6. UNIX for Dummies Questions & Answers
hi,
I need to create a bash shell script which picks up data from a text file and in the output file puts it into an html made table. I have to use sed and awk utilties to do this
the input text file will contain data in the format:
job name para1 para2 para3 para4 para4
1 ... (1 Reply)
Discussion started by: intern123
1 Replies
7. Shell Programming and Scripting
My script gives the following result. Is it possible to display the same in table format ?
1.
rex_best
Latest feeds are not avaialable. The last feed was generated on 2012-05-17
File Name = ekb_best_20120517_010949_665.tar.gz
The Number of entry elements = 4209539
2.
rex_genre
Latest... (2 Replies)
Discussion started by: kishorekumar87
2 Replies
8. Shell Programming and Scripting
Hello All Members,
I am new to this forum and to the shell scripting. I want to write a shell script to do the following:
Scenario: I have a pipe delimited .txt file with multiple fields in it. The very first row of the file contains the name of the column which resembles the name of the... (18 Replies)
Discussion started by: chetanojha
18 Replies
9. Shell Programming and Scripting
Team
I have files in different directories . How can i take the count of latest file and insert into Db2 table .
I am using
awk 'END{print NR+1-ARGC}' (File name)
to get the counts.
How can i take
1.The count of latest file
2.Insert into Db2 table( File Name and Counts) .
cd... (4 Replies)
Discussion started by: Perlbaby
4 Replies
10. UNIX for Beginners Questions & Answers
Hi All
I am trying to create a shell script to insert in to oracle table
so far insert happens with out an issue,
but i cant pass message variable to sqlplus script insert. i have highlighted the variable in red.
Please help.
thanks in advance.
#!/bin/sh
df -H | grep -vE... (3 Replies)
Discussion started by: LPK
3 Replies
STAT(2) System Calls Manual STAT(2)
NAME
stat, fstat - get file status
SYNOPSIS
#include <sys/types.h>
#include <sys/stat.h>
stat(name, buf)
char *name;
struct stat *buf;
fstat(fildes, buf)
struct stat *buf;
DESCRIPTION
Stat obtains detailed information about a named file. Fstat obtains the same information about an open file known by the file descriptor
from a successful open, creat, dup or pipe(2) call.
Name points to a null-terminated string naming a file; buf is the address of a buffer into which information is placed concerning the file.
It is unnecessary to have any permissions at all with respect to the file, but all directories leading to the file must be searchable. The
layout of the structure pointed to by buf as defined in <stat.h> is given below. St_mode is encoded according to the `#define' statements.
The mode bits 0000070 and 0000007 encode group and others permissions (see chmod(2)). The defined types, ino_t, off_t, time_t, name vari-
ous width integer values; dev_t encodes major and minor device numbers; their exact definitions are in the include file <sys/types.h> (see
types(5).
When fildes is associated with a pipe, fstat reports an ordinary file with restricted permissions. The size is the number of bytes queued
in the pipe.
st_atime is the file was last read. For reasons of efficiency, it is not set when a directory is searched, although this would be more
logical. st_mtime is the time the file was last written or created. It is not set by changes of owner, group, link count, or mode.
st_ctime is set both both by writing and changing the i-node.
SEE ALSO
ls(1), filsys(5)
DIAGNOSTICS
Zero is returned if a status is available; -1 if the file cannot be found.
ASSEMBLER
(stat = 18.)
sys stat; name; buf
(fstat = 28.)
(file descriptor in r0)
sys fstat; buf
STAT(2)