dbix::class::schema::loader::dbobject::informix(3pm) [debian man page]
DBIx::Class::Schema::Loader::DBObject::Informix(3pm) User Contributed Perl Documentation DBIx::Class::Schema::Loader::DBObject::Informix(3pm)NAME
DBIx::Class::Schema::Loader::DBObject::Informix - Class for Database Objects for Informix Such as Tables and Views in
DBIx::Class::Schema::Loader
DESCRIPTION
This is a subclass of DBIx::Class::Schema::Loader::DBObject that adds support for fully qualified objects in Informix including both
"database" and schema of the form:
database:owner.object_name
METHODS
database
The database name this object belongs to.
Returns undef if ignore_schema is set.
sql_name
Returns the properly quoted full identifier with "database", schema and name.
SEE ALSO
DBIx::Class::Schema::Loader::Table::Informix, DBIx::Class::Schema::Loader::DBObject, DBIx::Class::Schema::Loader::Table,
DBIx::Class::Schema::Loader, DBIx::Class::Schema::Loader::Base
AUTHOR
See "AUTHOR" in DBIx::Class::Schema::Loader and "CONTRIBUTORS" in DBIx::Class::Schema::Loader.
LICENSE
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.14.2 2012-05-05 DBIx::Class::Schema::Loader::DBObject::Informix(3pm)
Check Out this Related Man Page
DBIx::Class::Schema::Loader::DBI::Writing(3pm) User Contributed Perl Documentation DBIx::Class::Schema::Loader::DBI::Writing(3pm)NAME
DBIx::Class::Schema::Loader::DBI::Writing - Loader subclass writing guide for DBI
SYNOPSIS
package DBIx::Class::Schema::Loader::DBI::Foo;
# THIS IS JUST A TEMPLATE TO GET YOU STARTED.
use strict;
use warnings;
use base 'DBIx::Class::Schema::Loader::DBI';
use mro 'c3';
sub _table_uniq_info {
my ($self, $table) = @_;
# ... get UNIQUE info for $table somehow
# and return a data structure that looks like this:
return [
[ 'keyname' => [ 'colname' ] ],
[ 'keyname2' => [ 'col1name', 'col2name' ] ],
[ 'keyname3' => [ 'colname' ] ],
];
# Where the "keyname"'s are just unique identifiers, such as the
# name of the unique constraint, or the names of the columns involved
# concatenated if you wish.
}
sub _table_comment {
my ( $self, $table ) = @_;
return 'Comment';
}
sub _column_comment {
my ( $self, $table, $column_number ) = @_;
return 'Col. comment';
}
1;
DETAILS
The only required method for new subclasses is "_table_uniq_info", as there is not (yet) any standardized, DBD-agnostic way for obtaining
this information from DBI.
The base DBI Loader contains generic methods that *should* work for everything else in theory, although in practice some DBDs need to
override one or more of the other methods. The other methods one might likely want to override are: "_table_pk_info", "_table_fk_info",
"_tables_list" and "_extra_column_info". See the included DBD drivers for examples of these.
To import comments from the database you need to implement "_table_comment", "_column_comment"
AUTHOR
See "AUTHOR" in DBIx::Class::Schema::Loader and "CONTRIBUTORS" in DBIx::Class::Schema::Loader.
LICENSE
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.14.2 2012-06-08 DBIx::Class::Schema::Loader::DBI::Writing(3pm)
Hi all again,
here is the file i am working on :
GREIMBAJ00;BAN_CAV;Loader.sh;2003/06/13;17:04:04
GREIMBAJ00;BAN_CAV;Loader.sh;2003/06/13;17:04:06
GREIMBAJ00;BAN_PAK;Loader.sh;2003/06/13;17:04:11
GREIMBAJ00;BAN_PAK;Loader.sh;2003/06/13;17:04:18... (5 Replies)
Hi,
We are running a perl script to upload some data using SQL* Loader. We pipe the data in a http request to SQL*Loader which loads the data to the database. We encounter the error "Inappropirate ioctl for device" when we try to upload huge data. Any solution would be greatly appreciated.... (4 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)
Hi,
Last week, we experienced 2 KERNEL PANIC error on our SCO Unix 5.0.7 server within a 2 hour span. So I called our sofware support which is OGC using running on an Informix Database. Within 5 minutes I had as answer that the problem was an Hardware issue. Since the server is supported by... (4 Replies)
Hi,
This is my first thread.
Iam trying the following:
OS: Sun
Database: DB2, Informix, Oracle
* Get the status of the database (using database command line options)
* pipe to a text file
* send mail of the text file to receiptents.
TODO1:
First step i tried to send a test message.... (3 Replies)
This is the sample sqlldr log:
------------------------------------------------------------------------------------------------------------
SQL*Loader: Release 9.2.0.7.0 - Production on Sun Feb 8 23:37:02 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Control... (13 Replies)
Hi Everyone,
I want to know which database (Oracle,SQL,Informix...) are installed on Unix Machine.
I have very limited experience on Unix Environment, :confused: So I have no idea of getting this information. But in windows we can get Service names using WMI. Is there any similar way of Doing... (5 Replies)
Hi,
I have a log file whose size is number of characters in the file with multiple lines.
Example:
SQL*Loader: Release 10.2.0.4.0 - Production on Sat Sep 12 07:55:29 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Control File: ../adm/ctl/institution.ctl
Character Set... (4 Replies)
Need a help ..Schema browser in Toad not listing the tables when i connected to Oracle 11g schema
did any body faced the issue... ? How to resolve the issue..
I need it asap thats y posted here
Thanks (5 Replies)
Hi,
I'm planning to load the data from FLAT files into tables.
Source file: more input.txt
LRNO|Bale|Horsepower|NumberOfBarges|BollardPull|NumberOfCars|GasCapacity|GrainCapacity|IndicatedHorsepower|LiquidCapacity|... (6 Replies)
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)
The data below consits of items with Class, Sub Class and Property values. I would like to find out same value being captured for different property values for a same Class/Sub Class combination (with in an Item & across items). Like 123 being captured for PAD1, PAD2, PAD4 for ABC-DEF, 456 captured... (4 Replies)