dbix::class::storage::dbi::informix(3) [osx man page]
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)
Check Out this Related Man Page
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)
Firstly - aplogies to Vino
I need to check wether or not a variable called DATE is actually a date by doing the following - checking it is all numeric and secondly checking if it is 8 digits long.
Any help appreciated (10 Replies)
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)
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)
Hey..
I'm writing a code to download some stuff from Informix database and put it on Xls. It works fine, but I have a problem fitting in a new requirement.
I have currently a file which has information like below.
f_name|Ronnie|Johnson|23.00|
f_sal|Ronnie|Jhonson|4000.00|... (4 Replies)
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)
Hi,
We are trying to run reports to determine what percentage of the physical cpu's are being used by Informix ( oninit ) processes on an Aix5.3 box.
Is there any way to do that ? Sar just captures percentages but not by process name
Topas allows us to see some of the processes, but even those... (1 Reply)
Hi.
I've been working with UNIX/Linux for several years, but never in a VSF environment where I actually got to use any of it.
I downloaded the basic package for free (Don't worry, Symantec now allows for this for limited use) and intend to try this out on Linux and Solaris (also not my... (2 Replies)
i am reading an i/p file input.txt as below and want to read all filenames as in highlighted in bold below and put them in a different file output.txt. can someone help me with a shell script to do this? thanks in advance
regards
brad
input.txt
---------
START
TYPE:OPT
INIT_SEQ:01... (8 Replies)
hi guys,
i have script like below:
if
then
DATETIME=${1}
fi
pls can anyone explain what does ${1} means? what if i have i have two arguments and have {2} added to the if cond? any links to get this claruified on the syntax? (4 Replies)
Hi,
I have an old HPUX 10.20 server running Informix 7.23
I need to dump the database to get it off that hardware before it dies.
Unfortunately there is insufficient local diskspace to do so.
I have set up a linux box with sufficient disk onto which I can export the database.
Having... (1 Reply)
Hi guys,
Anybody is running Informix Dynamic Server on Open Server 6?
Can you share your kernel parameters for SHM, SEM, etc.?
I have a situation where oninit stops starting when the BUFFERS Informix parameter is increased. Already went through the machine release notes for Informix but... (6 Replies)
Hello,
One of my colleagues is working on a p730 without HMC, only one LPAR has all resources.
The server is showing some issues with Informix (10.00 & 11.50), the same config (OS & IFX) works perfectly on Power6 so I would like to ask him to change the processor compatibility mode to power6 on... (3 Replies)