I have converted data written on excel sheet in unix through shell & perl prg
now the problem is I want that if starting columns of the xls sheet is Blank than when data is converted into unix then it should appear with this '|' sign. but it appearing like this:
hfgg|tytt|
but I want like... (2 Replies)
hi friends i want to know details of `exec` exact use of this command .....
actually i went through the man page but i didn`t get the satisfactory ...conclusion....
thaks in advance.... (1 Reply)
find /A/B/C/{1,3,5,7} -name "*.txt" -o -name "*.csv" -o -name "*.TXT" -o -name "*.dat" |xargs ls -ltr |awk '{print $8 ,$9}' > result.xls
it will give the result that is $8 and &9 in the result file...
let say i need the result is a excel file....and i need the result to be print like $8 field... (10 Replies)
I just started to learn unix -
need help to write a script to query a logfile and produce the results that
contains a specific word "alarm" for a period from X day to Y day.
I really have no idea how to begin - :(
please help...
____________________________________________________
#... (1 Reply)
I would like to use the result of a query in another query. How do I redirect/add the output to another variable?
$result = odbc_exec($connect, $query);
while ($row = odbc_fetch_array($result)) {
echo $row,"\n";
}
odbc_close($connect);
?>
This will output hostnames:
host1... (0 Replies)
Hi,
I have a requirement as below which needs to be done viz UNIX shell script
(1) I have to connect to an Oracle database
(2) Exexute "SELECT field_status from table 1" query on one of the tables.
(3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
hi
i want to make script. where i want to query from the user yes or no
exp: do you want to proceed :
y for yes
n for NO.
how this is possible in unix (3 Replies)
Hi expert,
I have a script which is connecting with sql internally, fetch same data, store it in a file and then from os I cat this file and sending it to mail (windows outlook).
This is working fine, I just need to know wether we can add some html codes with the sql query like we can add... (0 Replies)
Below i have the sample code. i need to pass the entire query from file or as parameter and read the results and write into a output file.
here the number of columns are unknown. some times it may be 2,3 or entire columns from the table.
read all the column results and write into a comma... (0 Replies)
Hi,
I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database.
For instance:
USER CITY
--------- ----------
A CITY_A
B CITY_B
C ... (2 Replies)
Discussion started by: DevendraG
2 Replies
LEARN ABOUT DEBIAN
rescan-scsi-bus
RESCAN-SCSI-BUS.SH(8) System Manager's Manual RESCAN-SCSI-BUS.SH(8)NAME
rescan-scsi-bus.sh - rescan the SCSI bus.
SYNOPSIS
rescan-scsi-bus.sh [ -l ] [ -w ] [ -c ] [ -r ] [ host... ]
DESCRIPTION
rescan-scsi-bus.sh is a program that is used to rescan the SCSI bus using the SCSI add-single-device feature of the Linux SCSI layer.
OPTIONS -l Activates scanning for LUNs 0 .. 7 (default: 0).
-L NUM Activates scanning for LUNs 0 .. LUN (default: 0).
--luns=LIST
Scan only LUNs in LIST.
-w Enables scanning for device IDs 0 .. 15 (default: 0 .. 7).
--ids=LIST
Scan only device IDs in LIST.
-i, --issue-lip
Issue a FibreChannel LIP reset (default: disabled).
-r, --remove
Enables removing of devices (default: disabled).
--forceremove
Remove and readd every device (dangerous).
-c Enables scanning of channels 0 1 (default: 0).
--channels=LIST
Scan only channels in LIST.
host, --hosts=LIST
If host adapters are given, only these are scanned (default: all).
--nooptscan
Don't stop looking for LUNs if 0 is not found.
--color
Use coloured prefixes OLD/NEW/DEL.
LIST is a comma separated list of single values and ranges (no spaces allowed), e.g. 0,2-3,8,10-15.
AUTHOR
rescan-scsi-bus.sh was written by Kurt Garloff <garloff@suse.de>.
COPYRIGHT
This program is free software. You can use it under the terms of the GNU GPL (General Public License) Version 2 (or any later version, at
your option). Note, that the GNU GPL implies, that there is NO WARRANTY at all. Full text of the GPL can be found in /usr/share/common-
licenses/GPL file.
AVAILABILITY
rescan-scsi-bus.sh is available from
http://www.garloff.de/kurt/linux/scsidev/
March 1998 RESCAN-SCSI-BUS.SH(8)