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):
Code:
TAB_NAME | STATE | RECORDS
------------------------------
TAB1 | DUPKEY | 25
TAB2 | DUPKEY | 50
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 SUNOS
has_ic
has_ic(3XCURSES) X/Open Curses Library Functions has_ic(3XCURSES)NAME
has_ic, has_il - determine insert/delete character/line capability
SYNOPSIS
cc [ flag... ] file... -I /usr/xpg4/include -L /usr/xpg4/lib
-R /usr/xpg4/lib -lcurses [ library... ]
c89 [ flag... ] file... -lcurses [ library... ]
#include <curses.h>
bool has_ic(void);
bool has_il(void);
DESCRIPTION
The has_ic() function determines whether or not the terminal has insert/delete character capability.
The has_il() function determines whether or not the terminal has insert/delete line capability.
RETURN VALUES
The has_ic() function returns TRUE if the terminal has insert/delete character capability and FALSE otherwise.
The has_il() function returns TRUE if the terminal has insert/delete line capability and FALSE otherwise.
ERRORS
None.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Interface Stability |Standard |
+-----------------------------+-----------------------------+
|MT-Level |Unsafe |
+-----------------------------+-----------------------------+
SEE ALSO libcurses(3XCURSES), attributes(5), standards(5)SunOS 5.10 5 Jun 2002 has_ic(3XCURSES)