Sponsored Content
Full Discussion: Scripts for Informix
Special Forums UNIX and Linux Applications Scripts for Informix Post 302165259 by zcanji on Thursday 7th of February 2008 08:48:13 AM
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!
 

10 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

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

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

10. 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
DBIx::Class::Storage::DBI::Informix(3)			User Contributed Perl Documentation		    DBIx::Class::Storage::DBI::Informix(3)

NAME
DBIx::Class::Storage::DBI::Informix - Base Storage Class for Informix Support DESCRIPTION
This class implements storage-specific support for the Informix RDBMS METHODS
connect_call_datetime_setup Used as: on_connect_call => 'datetime_setup' In connect_info to set the "DATE" and "DATETIME" formats. Sets the following environment variables: GL_DATE="%m/%d/%Y" GL_DATETIME="%Y-%m-%d %H:%M:%S%F5" The "DBDATE" and "DBCENTURY" environment variables are cleared. NOTE: setting the "GL_DATE" environment variable seems to have no effect after the process has started, so the default format is used. The "GL_DATETIME" setting does take effect however. The "DATETIME" data type supports up to 5 digits after the decimal point for second precision, depending on how you have declared your column. The full possible precision is used. The column declaration for a "DATETIME" with maximum precision is: column_name DATETIME YEAR TO FRACTION(5) The "DATE" data type stores the date portion only, and it MUST be declared with: data_type => 'date' in your Result class. You will need the DateTime::Format::Strptime module for inflation to work. AUTHOR
See "AUTHOR" in DBIx::Class and "CONTRIBUTORS" in DBIx::Class. LICENSE
You may distribute this code under the same terms as Perl itself. perl v5.16.2 2012-08-16 DBIx::Class::Storage::DBI::Informix(3)
All times are GMT -4. The time now is 08:25 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy