Do you know about using sqlldr? It is a lot faster than trying to write and run a sql file with thousands of insert statements, and is meant to do exactly what you want.
sqlldr will be in your PATH, if you have your environment variables set so that
connects you to the db you want.
loader1.dat is a control file in the current directory
The log file shows errors. If there are errors this helps you to correct input
and remove the good lines that were entered. Then you can rerun.
Shell command:
This User Gave Thanks to jim mcnamara For This Post:
Guys,
I want to insert some values from a log file into a temporary table. the values in the log file looks like this
SV_NAME CC_NAME CP_DISP_RUN_STATE
------- ------------------- -----------------
sble01 ALLTEL WorkMon24Hrs Running
I want to enter the... (2 Replies)
Where to start?
Ok, I need to pick up a Worldpay exchange rates file from a url such as:
https://select.worldpay.com/wcc/info?op=rates&instId=12345&op=rates-today
the http response returns a exchange rates file with content-type "text/plain" content as below:
#Exchange rates for... (2 Replies)
how to assign values in this date format
a=`date +"%H%M%S"`
how to give value of H=22,here in this format so that i can grep 22nd hour.Below is the script
--------------------------------------------------------------------------
a=`date +"%H%M%S"`
for i in *.log
do
cat $i | grep $a... (3 Replies)
hello all,
I am new to shell scripting and to unix... so the following is my assignment..
here i am trying to insert a values into sqlplus database using shell script.
the following is my shell script
InsertDelete.sh
#! /bin/sh
echo "*********The MENU********
1.Insert The Values... (2 Replies)
Here's the problem.
I have a shell script running for every one minute as cronjob that outputs to a log file. I want to be able to take the data from the log file and insert it into a mysql database. The script needs to run at a set period of time and remove the log file data once the insert is... (7 Replies)
Hi All,
I have a directory containing multiple files.
and also a txt file which contains the list of all filenames and certain values.
I want to read the text file line by line and if its 2nd column is matched with the filename in directory, then it must insert the values in 7th column to... (14 Replies)
hi all,
i have one shell script like this
#!/bin/bash -xv
ENV_NAME=`cat $IB_HOME_DIR/cfg/ibProfile.sh | grep "RDM_CONN" | cut -f 2 -d "@"`
CURRENT_DIR=`pwd`;
string=$IB_HOME_DIR
string1="$string/FRGFOLDER/input"
#sed "s/string3/$string1" frg_event_src.sql > modifiedinsert.sql
sqlplus... (2 Replies)
Hi,
I have a requirement where I have an excel sheet with the below values
COL1 COL2 COL3
Germany URGENT NORMAL
I want to cut the values of this excel in such a way that I get the values and pass it to an insert statement
update tbfin set... (2 Replies)
I have a script working out ink percentages
#!/bin/bash
currentcyan=$'iso.3.6.1.2.1.43.11.1.1.9.1.1 = INTEGER: 990'
currentmagenta=$'iso.3.6.1.2.1.43.11.1.1.9.1.2 = INTEGER: 972'
currentyellow=$'iso.3.6.1.2.1.43.11.1.1.9.1.3 = INTEGER: 972'
currentblack=$'iso.3.6.1.2.1.43.11.1.1.9.1.4 =... (1 Reply)
Discussion started by: leshy93
1 Replies
LEARN ABOUT OPENSOLARIS
ds.log
ds.log(4) File Formats ds.log(4)NAME
ds.log - Availability Suite data services log file
DESCRIPTION
The /var/adm/ds.log file contains the Availability Suite data services command log. The administration commands log activities to the file
in the format:
date time product: message
Note that when the size of the log file exceeds 10 Mbytes, ds.log is renamed /var/adm/ds.log.bak and a new /var/adm/ds.log file is cre-
ated.
The ds.log fields are:
date
The date format is mmm nn, where mmm is the local three-character abbreviation for the month and nn is the day of the month on which
the event occurred.
time
The time of the event, in hh:mm:ss format.
product
A product code that identifies which component of the data services produced the event. The code is separated from the message that
follows by a colon (:) and a space.
message
A message that can extend over more than one line describing the event that occurred. The second or following lines are not pre-
fixed by the date, time, and product code strings.
EXAMPLES
The example below shows sample ds.log file content:
Jan 25 05:26:17 ii: iiboot suspend cluster tag <none>
Jan 25 05:32:02 ii: iiboot resume cluster tag <none>
Jan 25 05:32:04 sv: svboot: resume /dev/vx/rdsk/bigmaster
Jan 25 05:32:04 sv: svboot: resume /dev/vx/rdsk/bigshadow
Jan 25 05:32:04 sv: svboot: resume /dev/vx/rdsk/mstvxfs
Jan 25 05:32:04 sv: svboot: resume /dev/vx/rdsk/master01
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+---------------------+---------------------------------------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+---------------------+---------------------------------------------------------+
|Architecture | x86 |
+---------------------+---------------------------------------------------------+
|Availability | SUNWscmu |
+---------------------+---------------------------------------------------------+
|Interface Stability | Committed |
+---------------------+---------------------------------------------------------+
SEE ALSO iiadm(1M), sndradm(1M), svadm(1M), attributes(5)SunOS 5.11 08 Jun 2007 ds.log(4)