Hi....can you guys help me out in this script??
Below is a text file script....called Bukom.txt and it contains these:
BUKOM 20060101 2.5 2.6 2.7 2.8 2.9 2.3 2.1
BUKOM 20060102 2.4 2.5 2.6 2.7 2.7 2.6 2.4
BUKOM 20060103 2.1 ... (9 Replies)
Hi,
Need to get help from you guys about this issue.
I need to insert data into MySql database from a text file which is located in other server.
The text file is something look like below:
Date | SubscriberNo | Call Duration
20/7/07 | 123456788 | 20
20/7/07 | 123412344 | 30
The... (4 Replies)
Hi....can you guys help me out in this script??
Below is a text file and it contains these:
GEF001 000093625 MKL002510 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL003604 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL005675 000001... (4 Replies)
If you have a text file and if you want to Insert data to your Database Table, You can do it with these queries
LOAD DATA LOCAL INFILE '/path/yourTextFile.txt' INTO TABLE yourTableName
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n' (0 Replies)
i hava a file which contains database like
emp
dept
loc
now i want to create a script that read this file line by line and create a seperate query that ll be run in database like..
DELETE FROM TRS_ONE_ATDE WHERE DATA_DT = <from file>
how can this be achieved. pls help. (5 Replies)
Enclosed is comma separated text file. I need to write a korn shell program that will parse the text file and insert the values into Oracle database.
I need to write the korn shell program on Red Hat Enterprise Linux server.
Oracle database is 10g. (15 Replies)
I have a test file that I want to read and insert only certain lines into the
the table based on a filter.
1. Rread the log file 12 Hours back Getdate() -12 Hours
2. Extract the following information on for lines that say "DUMP is
complete"
A. Date
B. Database Name
C.... (2 Replies)
I have a log file that's created daily by this command:
sar -u 300 288 >> /var/log/usage/$(date "+%Y-%m-%d")_$(hostname)_cpu.log
It that contains data like this:
Linux 3.16.0-4-amd64 (myhostname) 08/15/2015 _x86_64_ (1 CPU)
11:34:17 PM CPU %user %nice ... (12 Replies)
Hi Experts,
I have a situation where I need to write a shell script to continuously monitor a log directory with multiple log files and perform following:
1. Read the latest log file continuously and grep "Success" OR "Failure"
2. As it capture either Success or Failure, it has to perform a... (1 Reply)
Hi All,
We've a VDI infrastructure in AWS (AWS workspaces) and we're planning to automate the process of provisioning workspaces. Instead of going to GUI console, and launching workspaces by selecting individual users is little time consuming. Thus, I want to create them in bunches from AWS CLI... (6 Replies)
Discussion started by: arun_adm
6 Replies
LEARN ABOUT SUSE
alevt-date
ALEVT-DATE(1) Teletext time ALEVT-DATE(1)NAME
alevt-date - display/set time received via Teletext
SYNOPSIS
alevt-date [options]
DESCRIPTION
alevt-date displays the time received from a Teletext source. It can be used to set the system time. The date is not interpreted (not
even transmitted on most channels). So it allows only adjustment of +/-12 hours. The default allowed adjustment is limited to +/-2 hours
(use -delta to change). Without the -set option it just displays the date in the format of the date(1) command.
OPTIONS
A summary of options is included below.
-set Set system time from time received via Teletext.
-delta seconds Maximum allowed adjustment made to the system time. The default is 7200 seconds (2 hours) and the maximum that may be
given is 12 hours.
-format string Format string to used to print the time. Look at strftime(3) for possible control sequences.
-vbi device Use the given device name (default: /dev/vbi0).
-timeout seconds If the time can't be detected in seconds, the program is terminated with a SIGALRM.
--help Show summary of options.
--version Show version of program.
Before starting this program, you have to set the TV channel with another program like xawtv of set-tv.
Note: This program does not set the battery backed up clock of your computer. clock -w will do this.
FILES
/dev/vbi*
SEE ALSO alevt(1x), alevt-cap(1), strftime(3), date(1), clock(8).
BUGS
This program is just a toy. The time transmitted by the TV stations is more than inaccurate. Some are within a few seconds of your local
time reference but others are more then 15 minutes off. You've been warned. (And don't assume the pkt8/30 time is better. It's even
worse.)
No bug reports to <froese@gmx.de> *g*.
LINUX 1.6.2 ALEVT-DATE(1)