topic Re: open connection with informix in Operating System - HP-UX

open connection with informix

kamal_15 — Sun, 23 Jan 2005 13:32:54 GMT

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

Re: open connection with informix

Slawomir Gora — Sun, 23 Jan 2005 13:52:57 GMT

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.

Re: open connection with informix

kamal_15 — Sun, 23 Jan 2005 13:58:14 GMT

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

Re: open connection with informix

Slawomir Gora — Sun, 23 Jan 2005 14:25:11 GMT

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 ...

Re: open connection with informix

kamal_15 — Sun, 23 Jan 2005 14:34:30 GMT

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

Re: open connection with informix

Slawomir Gora — Sun, 23 Jan 2005 16:29:29 GMT

Hi,

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

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

Re: open connection with informix

kamal_15 — Tue, 25 Jan 2005 09:26:11 GMT

many thankx

kamal