open connection with informix

[kamal_15]

hi all
iam new with hp-ux
i have hp-ux version 10.2 and database informix version 5.05

i want to execute a simple script containing insert statment.

but how can i establish connection with the database and execute this query?


thankx
kamal

[Slawomir Gora]

Hi,

you can use dbaccess command as informix user.
ex:
dbaccess DB_NAME script.sql
(replace DB_NAME)

without arguments dbaccess will run in cursor-graphics mode.

[kamal_15]

thank u fro your reply

but i need to open a connection with database and execute my query from my script

not from user command prompt

how can i do it?
thankx

[Slawomir Gora]

Hi,

I'am not sure what you want to do, what type
of script do you want to write ?

If you want simple shell script you can use
dbaccess command in syntax:
dbaccess DB_NAME insert.sql

where insert.sql has entries:
insert into ...

[kamal_15]

i want to do the following


1-vi file1

2-i want to type in this file sql statment

i want when execute this file the sql statment executed without openinig the database in graphical mode.(without typing dbaccess)

(i want to make a simple script as any application working with database)


thankx

[Slawomir Gora]

Hi,

just run dbaccess in this syntax:
dbaccess DB_NAME script.sql

there will be no graphical mode - this is syntax for scripting.

[kamal_15]

many thankx

kamal