Can you do what you need using DBI and DBD::DB2?

To my knowledge DBD::DB2 doesnt support execution of sql scripts / ddl file that sets up a database. But if thats wrong i would be very happy if someone would enlighten me.

Just to be clear. The task of the ddl file contains definition of numerous tables.

bannaN:

One of the examples (Listing 5) in this article show how to do DDL with DBI and DBD::DB2, so perhaps you can just convert your script.

...roboticus

When your only tool is a hammer, all problems look like your thumb.

Update: Trivial edit (specify which example performs DDL), changed plural to singular.

Have the script like this?

`/bin/sh /home/db2inst1/sqllib/db2profile`;
system("db2 terminate");
[download]

If i try to run something like this, the db2 command will not be recognized.
Error: "Can't exec "db2": No such file or directory"

So if i understood you correctly that doesnt work for some reason. As you may have understood i am not that into the logic of how different shells acquire their environment, and pass it on.
Am i right in the assumption that the system command will fork and inherit the environment from the perl script?
If i am, the question still stands, how can i make the perl script acquire the db2 environment

A parent process cannot inherit from a process it spawns.

You can however set the environment within the Perl script and then the system call will inherit it or you could run the db2profile scipt prior to running the Perl script and then everything would inherit it.

Rewriting as Perl

$ENV{PATH}="$ENV{PATH}:/opt/db2/bin"
...
[download]

Or calling everything from a shell script...

#!/bin/sh
. /home/db2inst1/sqllib/db2profile 
/home/db2instl/bin/stop_db.pl # Or whatever the script is called
[download]

print "Good ",qw(night morning afternoon evening)[(localtime)[2]/6]," fellow monks."

• How do I ... and have that change affect my current shell?
• export environment variable from a perl program
• How do I set env. Variables from Perl with shell script
• Get default login environment
• Shell::EnvImporter - Perl extension for importing environment variable changes from external commands or shell scripts