Hi
I want to get the a field from a SQL query into unix shell script variable. the whole situation is like this.
1. Opened a cursor to a table in DB2 databse.
2. Fetching individual rows with the help of cursor.
3. Each row has 4 fields.
I want each of the field in individual shell... (1 Reply)
I am trying to write a shell script that launches an expect script and then use results of the expect script in the rest of the shell script.
The expect script is connecting to a remote host and looking up certian user info like UID and home directory. This part is working
I then want the... (2 Replies)
All,
I have a shell script which parses the /var/adm/messages file for errors every 15 minutes as a cron job. The script runs at 01, 16, 31, and 46 minutes every hour. The problem is if the error is encountered any time during the beginning of hour I can get paged three times. I would like to... (2 Replies)
Hello,
Currently i have a ksh script which will disply the results in plain text format.
I want to format the result in more readable format like Making bold headings and format with colors etc. Something like html or excel format and send that content as email.
Please help me how i can do... (2 Replies)
Hi ,
I am not familiar with shell programming. I have a requirement like i have two files
.I need to compare the two files by comparing each parameter and i should produce 2 outputs.
1)i have around 35 parameters say i have one parameter name called db_name=dcap in one file and... (7 Replies)
I am trying to parse two files and get data that does not match in one of the columns ( column 3 in my case )
Data for two files are as follows
A.txt
=====
abc 10 5 0 1 16
xyz 16 1 1 0 18
efg 30 8 0 2 40
ijk 22 2 0 1 25
B.txt
=====
abc... (6 Replies)
Hello !
I am very aware that this is not the first time this question is asked here, because I have already read a lot of previous answers, but none of them worked, so...
As said in the title, I want to read a csv file with a bash script.
Here is a sample of the file:
... (4 Replies)
i run the command
snmptable -v2c -c public myIP IF-MIB::ifTable
the result look like this :
SNMP table: IF-MIB::ifTable
ifIndex ifDescr ifType ifMtu ifSpeed ifPhysAddress ifAdminStatus ifOperStatus
1 Unit: 1 Slot: 0 Port: 1... (7 Replies)
Hello All,
I am writing the below unix script to email the result of a small pl sql procedure:
#!/bin/bash
ORACLE_HOME=/opt/oracle/orcts/product/9.2.0; export ORACLE_HOME
SQLPLUS=$ORACLE_HOME/bin/sqlplus
sqlplus -s user/pass@Db_instance<<EOF
set echo off
set feedback off
set pages 0... (9 Replies)
Discussion started by: Bunty bedi
9 Replies
LEARN ABOUT FREEBSD
tcpdrop
TCPDROP(8) BSD System Manager's Manual TCPDROP(8)NAME
tcpdrop -- drop TCP connections
SYNOPSIS
tcpdrop local-address local-port foreign-address foreign-port
tcpdrop [-l] -a
DESCRIPTION
The tcpdrop command may be used to drop TCP connections from the command line.
If -a is specified then tcpdrop will attempt to drop all active connections. The -l flag may be given to list the tcpdrop invocation to drop
all active connections one at a time.
If -a is not specified then only the connection between the given local address local-address, port local-port, and the foreign address
foreign-address, port foreign-port, will be dropped.
Addresses and ports may be specified by name or numeric value. Both IPv4 and IPv6 address formats are supported.
The addresses and ports may be separated by periods or colons instead of spaces.
EXIT STATUS
The tcpdrop utility exits 0 on success, and >0 if an error occurs.
EXAMPLES
If a connection to httpd(8) is causing congestion on a network link, one can drop the TCP session in charge:
# sockstat -c | grep httpd
www httpd 16525 3 tcp4
192.168.5.41:80 192.168.5.1:26747
The following command will drop the connection:
# tcpdrop 192.168.5.41 80 192.168.5.1 26747
The following command will drop all connections but those to or from port 22, the port used by sshd(8):
# tcpdrop -l -a | grep -vw 22 | sh
SEE ALSO netstat(1), sockstat(1)AUTHORS
Markus Friedl <markus@openbsd.org>
Juli Mallett <jmallett@FreeBSD.org>
BSD January 30, 2013 BSD