How can i make a report from some insert in UNIX shell?
I have some insert in my unix shell script. This every insert has a spool (a file with datas) and a sql file with the query. I have to create a report file with three columns:
The first(TAB_NAME) will contains the name of the table in wich has been done the insert, the second (STATE) will contains if there is a dupkey or not and the last (RECORDS) will contains the number of insert record. So i suppose that i have to make a `SELECT COUNT` after the insert right? How can i do the report? The structure of the report (a file):
i have a small problem getting a batxh shell script to run in shell
this is the code
the problem seems to be centered around the ffmpeg command, something maybe to do with the ' ' wrapping around the vhook part command
this is a strange problem , if i take the ffmpeg command and... (1 Reply)
Is there a way to append or insert a word into a text file?
for example:
if a file contains the lines......
profilename="test_profile"
ear="${WpsInstallLocation}/installableApps/"
conntype="SOAP"
What I would like to have is the word test.ear inserted as below.....
... (4 Replies)
Hi,
Anybody know on how to insert C code in shell script. I am writing BLOB data to a database table in C but I don't know on how to insert the C code in shell script. Thanks in advance. (1 Reply)
Hi Frnds,
in shell script I have one problem while inserting into oracle table .
my script
#! /usr/bin/sh
while read record
do
echo $record
X=`sqlplus -s STN/errrmddb20@MAHFDR <<eof
insert into STN.STN_ERROR_TABLE values($record);
eof`... (12 Replies)
Hi,
I need to ping all the systems in my network and then create a log for the ones, from where I successfully get the ping-response (ICMP packet).
Now, I've used the ping command successfully, but am unable to use 'grep' command to locate the IPs for which the ping was successful (so that I... (5 Replies)
Hi gud day,
I would like to ask if possible to load the driver i compiled module without installing it in the ubuntu-kernel-distro/updates* or simple not executing "make install". what i mean is i compile the compat wireless driver using make and i want to try to load
on the system without... (1 Reply)
Hai,
How to insert a new line chracter "\n" in a line if it has more than 72 characters. My requirement is if the line has 72 characters i have to split it into two lines as follows.
I/p line :
this is a test line which is crossing seventy two characters so i have to split it -- this is of... (4 Replies)
i am new to unix shell scripting, could someone please help me. i was asked to develop a unix script and requirement of the script is as follows:
1. In source directory, if any new files are being dropped by external system then an email should be sent out with a message saying "files are... (3 Replies)
I have input data looks like this which is a part of a csv file
7,1265,76548,"0102:04"
8,1266,76545,"0112:04"
I need to make the output data should look like this and the output data will be part of text file:
7|1265000 |7654899 |A|
8|12660000 |76545999 |B|
The logic behind the... (6 Replies)
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
LEARN ABOUT XFREE86
times
times(1) User Commands times(1)NAME
times - shell built-in function to report time usages of the current shell
SYNOPSIS
sh
times
ksh
times
DESCRIPTION
sh
Print the accumulated user and system times for processes run from the shell.
ksh
Print the accumulated user and system times for the shell and for processes run from the shell.
On this man page, ksh(1) commands that are preceded by one or two * (asterisks) are treated specially in the following ways:
1. Variable assignment lists preceding the command remain in effect when the command completes.
2. I/O redirections are processed after variable assignments.
3. Errors cause a script that contains them to abort.
4. Words, following a command preceded by ** that are in the format of a variable assignment, are expanded with the same rules as a vari-
able assignment. This means that tilde substitution is performed after the = sign and word splitting and file name generation are not
performed.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
SEE ALSO ksh(1), sh(1), time(1), attributes(5)SunOS 5.10 15 Apr 1994 times(1)