11-02-2007
unix command to find the version of Informix database
Thank you very much guys.
I tried connecting to Informix database using dbaccess command.
Even though connection was successful, I could not figure out the version details in that
As suggested, I could find the version info from the installed directories
$INFORMIXDIR.
Thanks,
Suresh
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I am extremely new here. Someone wants to upgrade off of Unix to Windows 2000 and wants to know if they need to buy new hardware
How do I find out what type of Unix they're using?
How do I find out the current hardware of the system? (Intel, ..etc)
Thanks (3 Replies)
Discussion started by: tomsha
3 Replies
2. 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
3. UNIX for Dummies Questions & Answers
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
4. Shell Programming and Scripting
hi,
i am looking through the perl documentation in the man pages for the first time but I have looked at some other reference giudes before (at a glance) and remember that there is a find command used by perl can any one give me a structured example of that command and how it works and if possible... (2 Replies)
Discussion started by: moxxx68
2 Replies
5. Shell Programming and Scripting
Hi,
I want to know where can I download the DBD-Informix drive for windows version of perl.
Regards,
Mahehs
:confused: (0 Replies)
Discussion started by: maheshsri
0 Replies
6. UNIX for Dummies Questions & Answers
hello,
i'm trying to figure out the size of a mysql database shelling into my server with putty / command line.
is there / are there any commands that will return the size of a database, in MB?
thanks. (4 Replies)
Discussion started by: sbourgeois
4 Replies
7. SCO
hi,
I need to download Informix SE version 7 for SCO but i could'nt find the link.
please if someone can send me the link.
thinks. (1 Reply)
Discussion started by: whisper
1 Replies
8. UNIX for Dummies Questions & Answers
Having trouble doing the following things, I know it has something to do with using metacharacters but I'm not able to get it working correctly.
I need a command to get a long directory listing of all the files that have:
exactly two characters following the letters zot.
all files that... (1 Reply)
Discussion started by: lakers34kb
1 Replies
9. 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
10. Shell Programming and Scripting
Hi,
I am looking to extract linux version from /etc/*-release file.
I am specifically tring to avoid use of awk command here. would be great if can do done via sed or grep command.
Red Hat Enterprise Linux Server release 6.5 (Tikanga)
output must be 6
regards,
Litu (7 Replies)
Discussion started by: Litu1988
7 Replies
LEARN ABOUT OSX
dbix::class::storage::dbi::informix
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)