dbix::class::storage::dbi::firebird::common(3pm) [debian man page]
DBIx::Class::Storage::DBI::Firebird::Common(3pm) User Contributed Perl Documentation DBIx::Class::Storage::DBI::Firebird::Common(3pm)NAME
DBIx::Class::Storage::DBI::Firebird::Common - Driver Base Class for the Firebird RDBMS
DESCRIPTION
This class implements autoincrements for Firebird using "RETURNING" as well as auto_nextval, savepoints and server version detection.
CAVEATS
o "last_insert_id" support by default only works for Firebird versions 2 or greater, auto_nextval however should work with earlier
versions.
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.14.2 2011-05-10 DBIx::Class::Storage::DBI::Firebird::Common(3pm)
Check Out this Related Man Page
DBIx::Class::Storage::DBI::InterBase(3) User Contributed Perl Documentation DBIx::Class::Storage::DBI::InterBase(3)NAME
DBIx::Class::Storage::DBI::InterBase - Driver for the Firebird RDBMS via DBD::InterBase
DESCRIPTION
This driver is a subclass of DBIx::Class::Storage::DBI::Firebird::Common for use with DBD::InterBase, see that driver for general details.
You need to use either the disable_sth_caching option or "connect_call_use_softcommit" (see "CAVEATS") for your code to function correctly
with this driver. Otherwise you will likely get bizarre error messages such as "no statement executing". The alternative is to use the ODBC
driver, which is more suitable for long running processes such as under Catalyst.
To turn on DBIx::Class::InflateColumn::DateTime support, see "connect_call_datetime_setup".
connect_call_use_softcommit
Used as:
on_connect_call => 'use_softcommit'
In connect_info to set the DBD::InterBase "ib_softcommit" option.
You need either this option or "disable_sth_caching => 1" for DBIx::Class code to function correctly (otherwise you may get "no statement
executing" errors.) Or use the ODBC driver.
The downside of using this option is that your process will NOT see UPDATEs, INSERTs and DELETEs from other processes for already open
statements.
connect_call_datetime_setup
Used as:
on_connect_call => 'datetime_setup'
In connect_info to set the date and timestamp formats using:
$dbh->{ib_time_all} = 'ISO';
See DBD::InterBase for more details.
The "TIMESTAMP" data type supports up to 4 digits after the decimal point for second precision. The full precision is used.
The "DATE" data type stores the date portion only, and it MUST be declared with:
data_type => 'date'
in your Result class.
Timestamp columns can be declared with either "datetime" or "timestamp".
You will need the DateTime::Format::Strptime module for inflation to work.
For DBIx::Class::Storage::DBI::ODBC::Firebird, this is a noop.
CAVEATS
o with "connect_call_use_softcommit", you will not be able to see changes made to data in other processes. If this is an issue, use
disable_sth_caching as a workaround for the "no statement executing" errors, this of course adversely affects performance.
Alternately, use the ODBC driver.
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 2014-01-30 DBIx::Class::Storage::DBI::InterBase(3)
I have a huge matrix file containing some 1.5 million rows and 6000 columns. The matrix looks something like this:
1 2 3
4 5 6
7 8 9
3 4 5
I want to add all the numbers in the columns of this matrix and display the result to my stdout. This means that the numbers in the first column are:
... (2 Replies)
Hi,
Just trying to get to grips with sed and awk for some reporting for work and I need some assistance:
I have a file that lists policy names on the first line and then on the second line whether the policy is active or not.
Policy Name: Policy1
Active: yes
Policy... (8 Replies)
version info :
vi availabe with RHEL 5.4
I have a text file with 10,000 lines. I want to copy lines from 5000th line to 7000th and redirect to a file. Any idea how I can do this?
Note:
The above scenario is just an example. In my actual requirement, the file has 14 million lines and I want... (9 Replies)
Hi everyone,
I know the following questions are noobish questions but I am asking them because I am confused about the basics of history behind UNIX and LINUX.
Ok onto business, my questions are-:
Was/Is UNIX ever an open source operating system ?
If UNIX was... (21 Replies)
Hello,
I couldn't find an actual introduction thread, so I decided to just put this here.
I go by d0wngrade online. I have been programming in multiple languages for about 15+ years. I started with standard web design languages like HTML and CSS, but I then advanced from design to development... (2 Replies)
Hi guys...
The first active code line in AudioScope.sh is set -u .
This causes a complete exit if a variable is used/found but has not been allocated at the start of the program.
However, apart from writing code to do the task, is there a switch to to check which variables have been... (17 Replies)
Hi.
In thread https://www.unix.com/shell-programming-and-scripting/267833-grouping-counting.html rovf and I had a mini-discussion on grep and awk.
Here is a demo script that compares the awk and grep approaches for this single problem:
#!/usr/bin/env bash
# @(#) s2 Demonstrate group... (1 Reply)
Hello,
I have to fish out some specific columns from a file based on the header value. I have the list of columns I need in a different file. I thought I could read in the list of headers I need,
# file with header names of required columns in required order
headers_file=$2
# read contents... (11 Replies)
For those interested in installing dash shell on OSX Lion to help test POSIX compliancy of shell scripts, it is quite easy. I did it like this:
If you don't have gcc on your system:
0. Download and install the Command Line Tools for Xcode package from Sign In - Apple *
1. Download the dash... (2 Replies)
Hello and thanks in advance for any help anyone can offer me
I'm trying to learn the find command and thought I was understanding it... Apparently I was wrong. I was doing compound searches and I started getting weird results with the -size test. I was trying to do a search on a 1G file owned by... (14 Replies)
I have data of an excel files as given below,
file1
org1_1 1 1 2.5 100
org1_2 1 2 5.5 98
org1_3 1 3 7.2 88
file2
org2_1 1 1 2.5 100
org2_2 1 2 5.5 56
org2_3 1 3 7.2 70
I have multiple excel files as above shown.
I have to copy column 1, column 4 and paste into a new excel file as... (26 Replies)
Dear All,
Taking a break from Vue.js coding for the site, SEO and YT videos; and hopefully addressing some well deserved criticism from some here that I have been too focused on the visual aspects of the forums versus the substance and the community....
While the "current generation... (9 Replies)
Hi all...
Well guys and gals, I jumped in at the deep end and found things that PERL cannot do by default.
Many tricky terminal escape codes are not catered for so I had to create workarounds.
One thing I searched for was this:
Passing perl variable to shell command
AND, @Neo this was... (15 Replies)