Scripts for Informix


 
Thread Tools Search this Thread
Special Forums UNIX and Linux Applications Scripts for Informix
# 1  
Old 02-07-2008
Scripts for Informix

Hello,
I want to write a ksh script to connect to a remote Informix DB and insert rows. I understand from the various threads that isql is the most popular choice and that it can be done. I'm new to both scripting and Informix and have some questions -

1) Does isql have listener/ tnsnames files as Oracle has, that I need to configure? Or any other config files?

2) Are there some unixODBC configs to be done? The isql I have looks like its got to do something with unixODBC as I haven't installed isql on the system.
The syntax mentioned in the threads here for isql -
#isql -U$user -Ppwd -S$server
doesnt seem to work, the syntax is -
isql DSN [UID [PWD]] [options]
and when I use this syntax, I get --
[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect


3) What about dbaccess, can I get a download from somewhere and use it to connect to the infornix DB?

I know most of the ques are DB oriented, but its all in Unix env and I wanna write a ksh script, so I reckon its all within the boundaries Smilie

Thanks, any help will be greatly appreciated!
# 2  
Old 02-09-2008
I will move this thread to the Applications forum where it may have a better chance at an answer. But I don't think that we have many Informix experts here.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. HP-UX

how to identify the size of a informix db(in kb/mb)?

I just used the dbsize command to find the size, but i guess, it doesn't gets me what i look for. (0 Replies)
Discussion started by: dvah
0 Replies

2. BSD

Informix ClientSDK on freeBSD

Hi, I've read the limited information there are on Internet about this theme and some people say that this work should be done with SCO OpenServer CSDK (IBM - Informix Client Software Development Kit - System requirements for SCO - OpenServer) plus the binary emulation of CSO and others that it... (0 Replies)
Discussion started by: efrenba
0 Replies

3. SCO

Media for Informix 4.1

HI ! I NEED A MEDIA TO INSTALLING INFORMIX 4.1 IN SCO UNIX. OUR MEDIA ARE LOST AND THE SERVER IS GOING BAD ! HELP ME PLEASE ! THANK YOU VERY MUCH ! (5 Replies)
Discussion started by: tomribeiro
5 Replies

4. HP-UX

Upgrade HP UX in Informix environment

Currently running Informix 7.23 UC11 on HP UX 10.20. Want to upgrade O/S to HP UX 11i. ANyone done this before? will informix 7.23 run on 11i? Thanks. (4 Replies)
Discussion started by: mrviking
4 Replies

5. SCO

Installing informix SE at sco 5.0.6

Dear Sir, We are using sco 5.0.6 version. we need to install the informix database standard engine(SE) into this server. Kindly give me detailed instruction of preconfiguration( e.g. path) of sco 5.0.6 server. Kind Regards, Mostafizur Rahman (1 Reply)
Discussion started by: rahmanm
1 Replies

6. UNIX for Dummies Questions & Answers

offset - informix chunk

Hello all, I am trying to add chunks to my informix dataspace. I have one dataspace ( the rootdbs ) and the new chunk is a raw device. Precisely slice1 on my new external harddisk. The question is, what should be the offset value. The document says, the offset is used by the engine to... (1 Reply)
Discussion started by: shibz
1 Replies

7. UNIX for Dummies Questions & Answers

accessing the informix database

How do I access Informix from unix? It's been about 2 years since I've last used unix and I've forgotten the command. (2 Replies)
Discussion started by: pbouknight
2 Replies

8. UNIX for Dummies Questions & Answers

Informix

Hi there thanks for checking in. Would you know where i should go to find a Informix tutorial In html. Thanks in advance. (1 Reply)
Discussion started by: nemex
1 Replies

9. UNIX for Dummies Questions & Answers

Informix server

Hi, Just installed solaris Does anyone know where I can download Informix server for Unix thanks, (1 Reply)
Discussion started by: Mike1
1 Replies

10. UNIX for Dummies Questions & Answers

Unix/Informix and CTI

Can anyone please help me? I need to find out if a Unix server running Solaris 2.4 and an Informix V5 Database is capable of CTI via a CSTA Link to a telephone system for screen popping, and what APIs for CTI are supported? Any help or pointers in the right direction would be much appreciated.... (2 Replies)
Discussion started by: Dave34
2 Replies
Login or Register to Ask a Question