). As it turns out,
even though sqlplus worked from this machine, the broken machine was
missing a few files in the following directories :
(these directories weren't empty but they were exactly the same)
/export/home/oracle/product/9.2.0/rdbms/lib and
/export/home/oracle/product/9.2.0/rdbms/lib32
mentioned in @EXPORT = qw() of yy.pm . would it work in xx.pl
I know the ones mentioned for the EXPORT would be inherited to the
caller's namespace by default.
I thought for the subroutines not mentioned in EXPORT could be used by
other packages only in their complete qualified form
On 06/22/2005 04:06 AM, Vamsi_Doddapaneni said:
I have a doubt regarding the usage of export.pm.
This is not a DBI question, you would be better off asking on a general
Perl forum.
--
Mac :})
** I usually forward private questions to the appropriate mail list. **
Ask Smarter:
Hi,
The following exp command ran find on Unix command prompt.
$ exp file=users.dmp transport_tablespace=y tablespaces=USERS
userid=\'sys/[EMAIL PROTECTED] as sysdba\'
When I tried calling it in Perl,
my $rc=system(exp file=users.dmp transport_tablespace=y
tablespaces=USERS userid=\'sys/[EMAIL
You need to escape the @ in your command.
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Tiffany Thang [mailto:[EMAIL PROTECTED]
Sent: Monday, February 28, 2005 4:06 PM
To: dbi-users@perl.org
Subject: running Oracle export in perl
Hi,
The following
escape the @,
my $r=system(exp file=users.dmp transport_tablespace=y tablespace=users
userid=\'sys/[EMAIL PROTECTED] as sysdba\');
Date: Mon, 28 Feb 2005 18:05:59 -0500
From: Tiffany Thang [EMAIL PROTECTED]
To: dbi-users@perl.org
Subject: running Oracle export in perl
Hi,
The following
' for help
EXP-0: Export terminated unsuccessfully
thanks.
On Mon, 28 Feb 2005 17:13:32 -0600 (CST), Michael Nhan
[EMAIL PROTECTED] wrote:
escape the @,
my $r=system(exp file=users.dmp transport_tablespace=y tablespace=users
userid=\'sys/[EMAIL PROTECTED] as sysdba\');
Date: Mon, 28
, February 28, 2005 4:36 PM
To: Michael Nhan
Cc: dbi-users@perl.org
Subject: Re: running Oracle export in perl
I did that but I got a different error message. I thought maybe I had
it wrong. Any idea? Is this the only way of executing exp in Perl or
is there a more efficient method?
LRM-00112
Hi, I'am using DBI::DB2 for a lot of program and now I
need to create a programme to archive data. So, I
would like to export data from database to a file and
then load that file in another db2 database.
Here is what I try:
$dbh-do(q{export to test.ixf of ixf select * from
steph_test}) or die
.
On Wed, 16 Feb 2005 08:43:33 -0500 (EST), Stephane Legault
[EMAIL PROTECTED] wrote:
Hi, I'am using DBI::DB2 for a lot of program and now I
need to create a programme to archive data. So, I
would like to export data from database to a file and
then load that file in another db2 database
On Mon, Aug 23, 2004 at 03:53:51PM -0400, Steven Lembark wrote:
For example neat (see below for perldoc) 'knows' if a string
is numeric or char in the database.
Not quite. It knows if the perl scalar value has numeric and/or
string representations cached (the SvPOK and SvINOK flags).
If I
For example neat (see below for perldoc) 'knows' if a string
is numeric or char in the database. If I could get a hash keyed
by $sth-{NAME} that had, say, DBD-specific metadata it'd help
quite a bit on handling some error situaions. One use is returning
a copy of the query with placeholders filled
Hmmm I see that the export command is in the Command Reference
manual and not in SQL Reference Manual, so looks like it might not be
valid sql.
Although export ( like import ) in DB2 is called from within DB2
prompt, not directly on the command line.
Thanks a lot for the info.
Sumitro
Hi,
Googling did not get me anywhere so hoping for some pointers here.
Using DBD::DB2, this do/prepare fails during execute:
my $sth = $dbh-prepare(qq{export to product.exp of del messages
product.mes select * from product.product where pr_upc = ?}) || die
Couldn't prepare statement.$dbh
On Thu, 17 Oct 2002 13:05:54 -0700 (PDT) Naveen Prabhakar [EMAIL PROTECTED] wrote:
I am unable to execute a db2 export command this way.
@conn_command = (db2 connect to gtbookdb);
$output = `@conn_command 21`;
@exp_command = ( db2 export to $textfile of del
select \* from
Hi,
I am unable to execute a db2 export command this way.
conn_command = (db2 connect to gtbookdb);
$output = `conn_command 21`;
exp_command = ( db2 export to $textfile of del
select \* from,$table_name);
$output = `exp_command 21`;
error says the connection not available.
I have tried
Hiya. I'm using DBD::ODBC and an Access2000 database. Is there a module or
function that can export an Access2000 database to an Excel spreadsheet? If
so, would someone mind pointing me in the right direction?
Thanks!
Nick Hoffman
Hi,
we use DBIx::Copy and DBD::CSV( or was it DBD::Text)
Apperently there is a DBD::Excel as well
Regards
Paul
- Original Message -
From: Nick Hoffman [UWO] [EMAIL PROTECTED]
To: DBI-Users [EMAIL PROTECTED]
Sent: Tuesday, July 23, 2002 08:53
Subject: module/function to export to Excel
On Tue, 23 Jul 2002 02:53:45 -0400, Nick Hoffman [UWO] wrote:
Hiya. I'm using DBD::ODBC and an Access2000 database. Is there a module or
function that can export an Access2000 database to an Excel spreadsheet? If
so, would someone mind pointing me in the right direction?
FWIW, Spreadsheet
fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
- Original Message -
From: "Loo, Peter # PHX" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 13, 2001 12:28 PM
Subject: Unix export
Does anyone know how I can export a variable as I would in Unix.
On Tue, 13 Mar 2001, Loo, Peter # PHX wrote:
Does anyone know how I can export a variable as I would in Unix.
Export it where and on what OS?
-- Brett
http://www.chapelperilous.net/~bmccoy
2001 1:39 PM
To: Loo, Peter # PHX; [EMAIL PROTECTED]
Subject: Re: Unix export
Any value you add to %ENV is added to the environment of the current process
and any called subprocesses. They won't return to the program that called
the Perl script though.
--
Mac :})
** I normally forward privat
On Tue, 13 Mar 2001, Loo, Peter # PHX wrote:
Example:
export SOMETHING="A_VALUE"
Right, I understand what exporting variables are. You said 'like in
Unix'. Where are you trying to export variables 'like in Unix'? Sun OS
IS Unix, but if you are using ksh and not bash, yo
script and test it to see what the results are on your platform :)
cheers,
Aaron
-Original Message-
From: Brett W. McCoy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 2:32 PM
To: Loo, Peter # PHX
Cc: [EMAIL PROTECTED]
Subject: RE: Unix export
On Tue, 13 Mar 2001, Loo, Peter
"Brett W. McCoy" wrote:
On Tue, 13 Mar 2001, Loo, Peter # PHX wrote:
Example:
export SOMETHING="A_VALUE"
Right, I understand what exporting variables are. You said 'like in
Unix'. Where are you trying to export variables 'like in Unix'? Sun OS
25 matches
Mail list logo