Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

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)

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

DBIx::Class::Storage::DBI::SQLAnywhere - Driver for SQL Anywhere DESCRIPTION
This class implements autoincrements for SQL Anywhere and provides DBIx::Class::InflateColumn::DateTime support and support for the "uniqueidentifier" type (via DBIx::Class::Storage::DBI::SQLAnywhere::Cursor.) You need the "DBD::SQLAnywhere" driver that comes with the SQL Anywhere distribution, NOT the one on CPAN. It is usually under a path such as: /opt/sqlanywhere11/sdk/perl Recommended connect_info settings: on_connect_call => 'datetime_setup' METHODS
connect_call_datetime_setup Used as: on_connect_call => 'datetime_setup' In connect_info to set the date and timestamp formats (as temporary options for the session) for use with DBIx::Class::InflateColumn::DateTime. The "TIMESTAMP" data type supports up to 6 digits after the decimal point for second precision. The full precision is used. The "DATE" data type supposedly stores hours and minutes too, according to the documentation, but I could not get that to work. It seems to only store the date. You will need the DateTime::Format::Strptime module for inflation to work. MAXIMUM CURSORS
A DBIx::Class application can use a lot of cursors, due to the usage of prepare_cached. The default cursor maximum is 50, which can be a bit too low. This limit can be turned off (or increased) by the DBA by executing: set option max_statement_count = 0 set option max_cursor_count = 0 Highly recommended. 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::SQLAnywhere(3)
Man Page

15 More Discussions You Might Find Interesting

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

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

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

4. Shell Programming and Scripting

Checking variables

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)
Discussion started by: penfold
10 Replies

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

6. SCO

Media for Informix 4.1

Discussion started by: tomribeiro
5 Replies

7. UNIX for Advanced & Expert Users

Inserting a new column in a file

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)
Discussion started by: rosh0623
4 Replies

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

9. UNIX for Dummies Questions & Answers

getting unix stats for a specific process

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)
Discussion started by: fwellers
1 Replies

10. Filesystems, Disks and Memory

Veritas Storage Foundation

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)
Discussion started by: mark54g
2 Replies

11. Shell Programming and Scripting

need shell script to read particular records from a file

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)
Discussion started by: bradc
8 Replies

12. UNIX for Dummies Questions & Answers

what does it mean: ${0}, ${1}

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)
Discussion started by: prabhuSethu
4 Replies

13. HP-UX

Compress dbexport on the fly

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)
Discussion started by: fella
1 Replies

14. SCO

Kernel parameters for Informix on Open Server 6

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)
Discussion started by: ferdez
6 Replies

15. AIX

Change processor compatibility mode without hmc

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)
Discussion started by: fapl
3 Replies