09-30-2009
Truncate and Append in unix shell scripting
Hi All,
I have a long log file (abc.log) which contains large volume of data that need to be inserted into the database as clob.
I am having problem in inserting the long log file into the clob field if the cahracters in the file exceeds. So iwould like to truncate the file upto 32767 characters and append a string at last "Log file to large to view go to server".
Please advice, any links or samples appriciated.
Thanks
Raj
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
please give the difference between AIX shell scripting and Unix shell scripting. (2 Replies)
Discussion started by: haroonec
2 Replies
2. Shell Programming and Scripting
hi all ,
i am looking for a shell script which looks into a directory of text files and searches for a string(abc123) in all the text files and if that exists add a new line(abc124) in all the *.txt files automatically, or if (abc124) exists add (abc123) can you all please help me. (6 Replies)
Discussion started by: joseph.dmello
6 Replies
3. Shell Programming and Scripting
Hi ,
I have a file myhost.txt which contains below,
127.0.0.1 localhost
1.17.1.5 atrpx958
11.17.10.11 atrpx958zone nsybhost
I need to append words only after "atrpx958" like 'myhost' and 'libhost' and not after atrpx958zone.
How to search the word atrpx958(which is hostname) only,... (5 Replies)
Discussion started by: gsreeni
5 Replies
4. Shell Programming and Scripting
Hi All,
I have one file called date1.txt and it contains dates like
130112
140112
150112
160112
170112
180112
190112
201012
so i need a script to read this file line by line and find out the day of each date and assign this value in one variable. And validate Weekday="Mon" then... (4 Replies)
Discussion started by: vichuelaa
4 Replies
5. Shell Programming and Scripting
hi experts,
i m a btech student......my mini project is making a secure unix shell which is intented to stop mal practice in educational environment...........in other words need to create a new shell in which commands like cp do not work....can anyone suggest me how to begin with it....refrence... (3 Replies)
Discussion started by: vikas MENON.S
3 Replies
6. UNIX for Dummies Questions & Answers
Hello Experts,
I have the following questions to be discussed here at this esteemed discussion forum.
I have two Excel sheets which contain Unix Commands llike creating directory the structure/ftp/Copy/Zip etc to basically create an environment. I need help in understanding some of... (1 Reply)
Discussion started by: faizsaadq
1 Replies
7. Shell Programming and Scripting
Hi,
How to read .lst file line by line and while reading time it needs to copy the file into another file in unix shell script.
could you please help in this issue.
Thanks,
Rami Reddy. (4 Replies)
Discussion started by: Rami Reddy
4 Replies
8. UNIX for Dummies Questions & Answers
Hello everyone,
I am trying to reproduce the following SQL statement in UNIX. Can anyone help me out with this one..
SELECT trunc(add_months(SYSDATE, -1), 'mm') FROM DUAL;
date +"%Y%m%d" -d last-month
This gives me last month date but I need to truncate that to 1st of that month.
Any... (2 Replies)
Discussion started by: ronitreddy
2 Replies
9. Programming
Hi All,
need help to complete the automation but stuck at a perticular situation
below is the code
<code>
fixed_function_name
{
code....
code....
variable_map=
{
a="/a"
b="/b"
c="/c"
so on...
} (7 Replies)
Discussion started by: yadavricky
7 Replies
10. UNIX for Beginners Questions & Answers
Describe in short the word completion feature of the tcsh
Completion works anywhere in the command line, not at just the end, for both commands and filenames. Type part of a word and hit the Tab key, and the shell replaces the incomplete word with the complete one in the input buffer. The... (1 Reply)
Discussion started by: Elena Lauren
1 Replies
LEARN ABOUT NETBSD
iprop-log
IPROP-LOG(8) BSD System Manager's Manual IPROP-LOG(8)
NAME
iprop-log -- maintain the iprop log file
SYNOPSIS
iprop-log [--version] [-h | --help] command
iprop-log truncate [-c file | --config-file=file] [-r string | --realm=string] [-h | --help]
iprop-log dump [-c file | --config-file=file] [-r string | --realm=string] [-h | --help]
iprop-log replay [--start-version=version-number] [--end-version=version-number] [-c file | --config-file=file] [-r string | --realm=string]
[-h | --help]
DESCRIPTION
Supported options:
--version
-h, --help
command can be one of the following:
truncate
-c file, --config-file=file
configuration file
-r string, --realm=string
realm
Truncates the log. Sets the new logs version number for the to the last entry of the old log. If the log is truncted by emptying
the file, the log will start over at the first version (0).
dump
-c file, --config-file=file
configuration file
-r string, --realm=string
realm
Print out all entries in the log to standard output.
replay
--start-version=version-number
start replay with this version
--end-version=version-number
end replay with this version
-c file, --config-file=file
configuration file
-r string, --realm=string
realm
Replay the changes from specified entries (or all if none is specified) in the transaction log to the database.
last-version
-c file, --config-file=file
configuration file
-r string, --realm=string
realm
prints the version of the last log entry.
SEE ALSO
iprop(8)
BSD
February 18, 2007 BSD