Looking for any advise from a DBA/DA. When should you use CHAR and when should you use VARCHAR when designing a table. From my readings seems like VARCHAR will accept any length string even though you define a length to it, so I setup gadget VARCHAR(10) I could actually put something with 20... (1 Reply)
Hi ,
I need to sort a file based on multiple columns All the columns are of varchar type
can any one give me the command to sort for varchar columns?
Thanks (3 Replies)
Hi
I have a file in the following format:
4135 f4135acc: 39798 rmtdb: 0 /t1/data/f4135acc.dta
4135 f4135pdb: 39795 rmtdb: 0 /bb/data/f4135pdb.dta
4135 p4135eng: 0 rmtdb: 0 /bb/bin/p4135eng
4135 r4135eng: 14142 rmtdb: 0 ... (6 Replies)
hi , i am very new to perl . scriptting.. pllease can any one help me ...pleaseeeeeee
i ll have a file which look likes
123 |something |567
456 |welcome |789
457 |inboxpost |790
.
.
123 |something |567
i have to execute all the lines in the file except the first and the... (14 Replies)
I am familiar with using tar and exclude/include files:
tar zcf backup.dirs.tgz --files-from=include.mydirs --exclude-from=exclude.mydirs --no-recursion
but was wondering if I could use find in the same way. I know that you can just specify the directories to exclude but my list is... (2 Replies)
Hi Gurus.
I have a directory and i receive many files with extension .log. I processed the file as i get it. i want to process all the files except one which i know i don't want to process.
cd /backup/temp/rajesh/PACS #--- directory , under this i have below files... (1 Reply)
hi,
i am trying to use a exclude file to exclude some file directories while making a tar archive. This is my command:
tar -pcvf orahome10gR2.tar.gz db_1 -X /home/oracle/excludeFile.txt /home/oracle/
when i execute it, it seem to be tar-ing. But once is done, i cd to /home/oracle and could... (2 Replies)
Hello,
I have a list of patterns which I'd like to exclude from a file. I tried to do
while read line
do
grep -v $line file >> new.file
done < mylist
But obviously it won't work. It only works for just grep. I know I can do:
grep -Ev 'pattern1|pattern2|...' myfile
but my... (7 Replies)
Hello everyone,
I try to find folders older than 3 years and display them, but excluding some directories, the below code does NOT exclude listed directories:
find . -maxdepth 3 -mtime +1095 -type d -exec ls -l {} \; | grep -vFf oldExclude >> older
oldExclude
Folder1/
Folder2/... (7 Replies)
Discussion started by: Abu Rayane
7 Replies
LEARN ABOUT DEBIAN
bb-csvinfo.cgi
BB-CSVINFO.CGI(1) General Commands Manual BB-CSVINFO.CGI(1)NAME
bb-csvinfo.cgi - CGI program to show host information from a CSV file
SYNOPSIS
bb-csvinfo.cgi
DESCRIPTION
bb-csvinfo.cgi is invoked as a CGI script via the bb-csvinfo.sh CGI wrapper. Based on the parameters it receives, it searches a comma-
separated file for the matching host, and presents the information found as a table.
bb-csvinfo.cgi is passed a QUERY_STRING environment variable with the following parameters:
key (string to search for, typically hostname)
column (columnnumber to search - default 0)
db (name of the CSV database file in $BBHOME/etc/, default hostinfo.csv)
delimiter (delimiter character for columns, default semi-colon)
CSV files are easily created from e.g. spreadsheets, by exporting them in CSV format. You should have one host per line, with the first
line containing the column headings. Despite their name, the default delimiter for CSV files is the semi-colon - if you need a different
delimiter, invoke bb-csvinfo.cgi with the "delimiter=<character>" in the query string.
Example usage
This example shows how you can use the bb-csvinfo CGI. It assumes you have a CSV-formatted file with information about the hosts stored as
$BBHOME/etc/hostinfo.csv, and the hostname is in the first column of the file.
Use with the bbgen --docurl
The --docurl option to bbgen(1) sets up all of the hostnames on your Xymon webpages to act as links to a CGI script. To invoke the
bb-csvinfo CGI script, run bbgen with the option
--docurl=/cgi-bin/bb-csvinfo.sh?db=hostinfo.csv&key=%s
SEE ALSO bb-hosts(5), hobbitserver.cfg(5), bbgen(1)Xymon Version 4.2.3: 4 Feb 2009 BB-CSVINFO.CGI(1)