Shell Script: want to insert values in database when update script runs

ring · #1 (**permalink**) 10-25-2007

Hi ,

I am new to linux and also also to shell scripting.
I have one shell script which unpacks .tgz file and install software on machine.
When this script runs I want to insert id,filename,description(which will be in readme file),log(which will be in log file) and name of unpacked folder like: tmp/MyFile into "MyTable"(database).
I don't have any idea about how to read data from file and insert that data into database table. This is for description and log field. Datatype of these fields is CLOB. Even I want to find max(id) from exiting table data, so that I can insert mew entry as maxid+1.

I am facing problems while writing this script.
Could anybody help me with this?

Thanks in advance
Ring

porter · #2 (**permalink**) 10-25-2007

What database are you talking about?

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Sunsolaris shell script runs only as super user	gjithin	SUN Solaris	4	05-09-2008 08:47 AM
passing values from sql to shell script	sachin.gangadha	Shell Programming and Scripting	3	04-22-2008 11:11 PM
Values of value($$X) in unix shell script	ganesh_111	Shell Programming and Scripting	5	09-22-2006 06:25 AM
Passing Values from a shell script	dhananjaysk	Shell Programming and Scripting	6	04-06-2006 09:33 AM
Returning Values (shell Script)	jennifer01	Shell Programming and Scripting	3	11-29-2001 06:31 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by