Delaporte, Olivier wrote:
I am trying to build the DBD-Informix module DBD-Informix-2003.04 on HP-UX
11.11v1 with Perl 5.8.0.B and gcc 3.3.3. The informix parameters are:
INFORMIXDIR=/apps11/informix ; export INFORMIXDIR
INFORMIXSERVER=fab3_prd1 ; export INFORMIXSERVER
PATH=$PATH:$INFORMIXDIR/bin ;
leegold wrote (off list):
So, something like:
$dbh->{csv_sep_char}='###';
would work, you think?
Hi,
First, please respond to the list rather than to an individual. The
individual might be busy :-). Also, if the answer is on the list, then
everyone can learn from it.
The {csv_sep_char} is
Hello
I am trying to build the DBD-Informix module DBD-Informix-2003.04 on HP-UX
11.11v1 with Perl 5.8.0.B and gcc 3.3.3. The informix parameters are:
INFORMIXDIR=/apps11/informix ; export INFORMIXDIR
INFORMIXSERVER=fab3_prd1 ; export INFORMIXSERVER
PATH=$PATH:$INFORMIXDIR/bin ; export PATH
DB
So, if the delimiter is '###' something like:
$dbh->{sep_char}='###';
would work, you think?
--
http://www.fastmail.fm - Sent 0.02 seconds ago
leegold wrote:
I understand there is support for comma tab and pipe delimited files.
Let'say I have '###' as field delimiter in a flat text file. Can
I "inform" the DBI and use this?
DBI does not deal directly with databases, it leaves that to DBD
(database driver) modules which are used alongsid
-Original Message-
From: leegold [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 11, 2004 9:41 AM
To: [EMAIL PROTECTED]
Subject: different field delimiters and xml question
I'm slightly cross posting because I have similiar question on
newsgroup but no response (yet). Wondered if you can e
I'm slightly cross posting because I have similiar question on
newsgroup but no response (yet). Wondered if you can entertain my ques.
I understand there is support for comma tab and pipe delimited files.
Let'say I have '###' as field delimiter in a flat text file. Can
I "inform" the DBI and use
..Also found this in the Docs (perldoc DBI, search for binary)
Perl supports binary data in Perl strings, and the DBI will pass
binary
data to and from the driver without change. It is up to the
driver
implementors to decide how they wish to handle such binary data.
On Mo
..forgot to cc list.
On Mon, 2004-05-10 at 14:33, Scott T. Hildreth wrote:
> I guess it would depend on which database you are using. I would try
> it with a bind column and let the DBD driver handle the quoting if need
> be,
>
> $dbh->do(q{
> update mystuff set binaryfld=?
> Where id=
