Re: problem with running export utility for db2 from perl.

[Michael A Chase]

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,$table_name);
 
  $output = `@exp_command 21`;
 
 error says the connection not available.
 I have tried using dbh-connect,still doesnt work.
 Could anyone guide me to do this.

The `` commands are passed to the shell to execute and have nothing to do
with DBI.  I don't see where you are using DBI at all.
-- 
Mac :})
** I normally forward private questions to the appropriate mail list. **
Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.

problem with running export utility for db2 from perl.

[Naveen Prabhakar]

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 using dbh-connect,still doesnt work.
Could anyone guide me to do this.

Thank you.
Naveen



__
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos  More
http://faith.yahoo.com