02-21-2008
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
#! /bin/ksh
############################
# AFI Monitor Script
############################
. /db2/uszlad48/sqllib/db2profile
export mondir=/home/script/krishna
export monlog=$mondir/Error_Report_`date +%Y%m%d`.log
echo "connect to database r2pdev" >>$monlog
db2 connect to r2pdev user... (1 Reply)
Discussion started by: regnumber
1 Replies
2. Shell Programming and Scripting
Hi,
I am using the following format command for formatting my text file in unix.
awk -F":" '{ printf "%-50s%-1s%-50s\n", $1,":", $2}' filename > targetfile
The target file is then sent as an attachment via email.
When I view the target file in notepad multiple lines get spanned as a... (2 Replies)
Discussion started by: AAA
2 Replies
3. Shell Programming and Scripting
Hi ,
I have a text file noname.txt containing 1000+ records like this. One of the record I have given below.
Input will b e like this
BOT:
2010/06/01 00:25:59
21 = "private"
Access-Method = 31
NCC = GBR
01 =... (5 Replies)
Discussion started by: smalya
5 Replies
4. Shell Programming and Scripting
while read l
do
vTimeCreated=`perl -e '@d=localtime ((stat(shift))); printf "%02d-%02d-%04d %02d:% 02d:%02d\n", $d,$d+1,$d+1900,$d,$d,$d' ${l}`
echo "${l} || ${vTimeCreated}" >> ${fPrefx}_Output_Files_${vDate}.txt
done < servername.txt Using the above code to format date time for each of the... (0 Replies)
Discussion started by: HeadBang
0 Replies
5. Shell Programming and Scripting
Hi,
Am using the following command to create a csv file
paste File_1.csv File_4.csv File_7.csv >Out1.csv
paste File_2.csv File_5.csv File_8.csv >>Out1.csv
paste File_3.csv File_4.csv File_9.csv >>Out1.csv
Input Data:
Expected Output:
Column 1 Column 2 ... (2 Replies)
Discussion started by: meva
2 Replies
6. Shell Programming and Scripting
hi, please help me with the below
1)i have a file like below with data
389096
389097
389098
..and i need some thing like below
'389096','ZZ1111'
'389097','ZZ1111'
'389098','ZZ1111'
2)i have a file like below with data
8300003225
8300003223
8300006494 (7 Replies)
Discussion started by: kr123
7 Replies
7. Shell Programming and Scripting
hi folks
am running the shell script below
#!/bin/bash
sqlplus 'scott@orcl/tiger'<<ENDSQL >> outputlogfile.csv
SET PAGES 0
SET HEAD ON
SET ECHO OFF
SET FEEDBACK OFF
SET LINESIZE 100
SET PAGESIZE 100
SET SERVEROUTPUT ON
--# Fire the query on database
select *
from employee;
... (2 Replies)
Discussion started by: coolboy98699
2 Replies
8. Shell Programming and Scripting
Hi Techies,
i need in n UNIX to Windows file formatting.
i have created a csv file using a script and mailed it to my email, when i open the file with Excel sheet it looks like below
Collector_no|_|Collector_Name|_|SE_Count|_|Installed_Domains|_|CPU_Sys|_|CPU_Idle|_|Memory_Util... (9 Replies)
Discussion started by: mahi_mayu069
9 Replies
9. Shell Programming and Scripting
Hi
I have a shell variable storing DATE in YYYY-MM-DD format
is there a way i extract required field say only DD
Also, would be great if there is a way which could take date format as well so that code is generic for any date format eg DDMMYYYY or DD/MM/YYYY or YYYY/MM/DD etc.
Thanks (4 Replies)
Discussion started by: skyineyes
4 Replies
10. Shell Programming and Scripting
Hi All,
Here is an oracle command to list out the bug fix patches applied on Oracle Software.
(hostname)/home/oracle-> $ORACLE_HOME/OPatch/opatch lsinventory -bugs_fixed
The output of this command is as follows(Pasting only relevant section):
List of Bugs fixed by Installed Patches:
... (3 Replies)
Discussion started by: veeresh_15
3 Replies
LEARN ABOUT V7
restorefont
restorefont(1) Svgalib User Manual restorefont(1)
NAME
restorefont - save or restore the SVGA font for textmode.
SYNOPSIS
restorefont {-r|-w} filename
DESCRIPTION
The font used by SVGA when in textmode is written to or restored from filename using the vga_gettextfont(3) and vga_puttextfont(3) func-
tions.
FILE FORMAT
The VGA font file filename has the following format:
Offset:
0 - 31 Character 0
... ...
8164 - 8195 Character 255
Each row of a character bitmap is stored as a byte (8 pixels). The space that is left from the 32-byte buffer for each character is
ignored, e.g. a 16 line font uses only offsets 0 - 15 of each character.
Linux textmode screen resolutions:
80x25 16 line font 400 scanlines
80x28 14 line font 400 scanlines
80x50 8 line font 400 scanlines
The font sizes and resolutions of extended textmodes depend on the video card type and BIOS:
132x25 14 line font 350 scanlines (ugly)
132x25 16 line font 400 scanlines
132x43 8 line font 350 scanlines (use fix132x43 to fix/improve)
132x50 8 line font 400 scanlines
Using a font that has less lines per character than the textmode works, but the characters are smaller. Using a font that is bigger than
the textmode font results in the bottom part of characters being cut off.
The svgalib distribution contains sample fonts with 8, 14 and 16 line characters in the files utils/font8, utils/font14, and utils/font16.
The convfont (1) program can be used to convert fonts straightforwardly stored character-after-character (i.e. each character only uses
8/14/whatever bytes), to the 32-byte per character format that restorefont requires.
The purpose of this program is usually to recover from a crashed console due to an svgalib, Xfree or other program bug. First save the
state of the SVGA card when on a text console. After the crash restore this state. The savetextmode(1) and textmode(1) script makes this
procedure very easy.
The national/fontpak packages, which include kernel patches, allow different textmode fonts to be used in different virtual consoles. These
have been superseded by the kbd package (in the kernel since ages). See the setfont(8) utility of the kbd package as a starting point.
Recent kernels support up to 2 fonts with 512 chars each. Recent versions of svgalib take this into account and extend the size of the
datafile accordingly.
OPTIONS
-w filename
write the font to the file filename.
-r filename
restore the font from the file filename.
SEE ALSO
svgalib(7), vgagl(7), libvga.config(5), setfont(8), vga_gettextfont(3), vga_puttextfont(3), dumpreg(1), convfont(1), fix132x43(1), restore-
textmode(1), restorepalette(1), runx(1), savetextmode(1), setmclk(1), textmode(1).
AUTHOR
This manual page was edited by Michael Weller <eowmob@exp-math.uni-essen.de>. The exact source of the referenced utility as well as of the
original documentation is unknown.
It is very likely that both are at least to some extent are due to Harm Hanemaayer <H.Hanemaayer@inter.nl.net>.
Occasionally this might be wrong. I hereby asked to be excused by the original author and will happily accept any additions or corrections
to this first version of the svgalib manual.
Svgalib (>= 1.2.11) 2 Aug 1997 restorefont(1)