Sponsored Content
Top Forums UNIX for Dummies Questions & Answers accessing the informix database Post 19962 by shibz on Thursday 18th of April 2002 11:14:48 AM
Old 04-18-2002
Hi,

Check this out..

#$INFORMIXDIR/bin/isql :-takes u to the querry building
#$INFORMIXDIR/bin/dbaccess : for database access.
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

how to figure out the size in MB for an informix database

This is the info i have so far. please if you are dead positive can u let me know if i my math/process is correct. Chunks address chk/dbs offset size free bpages flags pathname 5003e1f8 1 1 0 250000 177177 PO- /database/link_cw_p01_rootdbs 5003e494 2 ... (5 Replies)
Discussion started by: Optimus_P
5 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

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

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

6. Shell Programming and Scripting

unix command to find the version of Informix database

Hi All Please let me know if there is command to check the version of the informix database installed..? Thanks in advance. Suresh (4 Replies)
Discussion started by: sureshg_sampat
4 Replies

7. UNIX and Linux Applications

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... (1 Reply)
Discussion started by: zcanji
1 Replies

8. UNIX for Dummies Questions & Answers

Debian - Connect To Informix Database

Can anyone point me toward information on setting up a Debian server ODBC connection to an Informix server? I have a Windows server set up with the Informix drivers in ODBC and I'd like to do the same thing on Debian so that my Rails apps can query the database beneath our call-logging software. ... (1 Reply)
Discussion started by: badmoon75
1 Replies

9. Programming

Column update using Informix

Hi, I am using INFORMIX 8 and trying to update column value by apending '09' to existing record . update sample_data_table set Name = Name||22 where id = 90 and state = NY This worked fine in oracle Database,But throwing error in informix . I need output as Ravi22 for Ravi record in... (0 Replies)
Discussion started by: Perlbaby
0 Replies

10. Linux

Problem in accessing Oracle Database Server from Linux Machine

I am facing a strange issue in connecting to Oracle database from Linux Machine - The connectivity is not failing all the time , the failure to success ratio is 1:70. - Error "ORA-12545: Connect failed because target host or object does not exist" - Majority of the time the connection... (6 Replies)
Discussion started by: balaji kumar
6 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.18.2 2013-12-16 DBIx::Class::Storage::DBI::Informix(3)
All times are GMT -4. The time now is 03:10 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy