UNIX for Dummies Questions & Answers

Hi Ahamed,

I am giving auto commit like below

Code:

while read filename
do
awk '/ n /{print "insert into lastlogon values(" q$1q, q$3q, q$4q, $5, q$6q ");"
}' q=\' OFS=", " userreport.txt
SET AUTOCOMMIT ON;
done<userreport.txt

but getting below error when I compile

Code:

insert into lastlogon values(se3aa', 'Wed', 'Jun', 30, '2010');
insert into lastlogon values('34s34', 'Tue', 'Mar', 15, '2011');
insert into lastlogon values('34saw', 'Mon', 'Feb', 3, '2014');
+ SET AUTOCOMMIT ON
loaddata1.ksh[14]: SET:  not found
+ read filename

You need to echo it out...

Code:

...
echo "SET AUTOCOMMIT ON;"
...

I assume after running the script, you feed the output into the DB.
If that doesn't work, I am not an sql expert, but why dont you try one record at a time with normal commit?

--ahamed

---------- Post updated at 07:11 PM ---------- Previous update was at 07:09 PM ----------

Just noticed, why are you using the while loop on the same file again? The awk alone is enough to get you the insert statements from userreport.txt!

--ahamed

---------- Post updated at 07:13 PM ---------- Previous update was at 07:11 PM ----------

Also, not sure if its a typo, but you are missing a single quote in the first data of the first record.

--ahamed

Also,