04-18-2002
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.
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
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
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
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
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
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
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
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
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
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
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
LEARN ABOUT MOJAVE
dbix::class::storage::dbi::informix5.18
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)