Shell Programming and Scripting

Hi All,

Language like C,Java can interact with database..and can use database information .. can a shall script do this?

if yes thn plz guide me.....

thankx

Yes u can interact with database. See below for the pseudo code

Code:

...
sqlconnect()
{
        sqlplus -s  scott/tiger@ORACLE << EOF
        select sysdate from dual;
        EOF
}
...

sqlconnect

You can also search the site for more details. Check this link Oracle Connect

The unit of execution in a shell is a process. You are unlikely to be able to make a single transaction span multiple processes. If you need multiple steps within a single transaction you will need to generate the sql to pipe into a program like sqlplus.

Code:

isql database_name <<!
select * from table_name
!

you can try this logic if you are using infomix

Pretty much I have used only dbaccess for informix
is isql a supported client for informix.

Matrixmadhan,
Before IBM bought Informix in 2001, Informix had separated its development
tools into three different groups:
1) Informix 4GL (for programmers).
2) isql (for non-programmers).
3) dbaccess (for database administrators).

Both 'isql' and 'dbaccess' have a lot of commom functions, but there are
several mutually exclusive functions.

Among other functions, 'dbaccess' does not have 'Forms' or 'Reports'.

Among other functions, 'isql' cannot create stored procedures nor perform
some database and table maintenance.

As far as I know, IBM-Informix supports both 'isql' and 'dbaccess'.

Hi Srikanth,

Suppose I need to capture a Value that is the result of the query
How do i do it.
Like

Select x from Tablex where y='56';
I need the value x to be stored in a variable for further processing
How do I accomplish this ??

Regards
Srikanth GR