On 1/10/07, Brimacomb, Brent <[EMAIL PROTECTED]> wrote:
: [IBM][CLI Driver] CLI0124E Invalid argument value. SQLSTATE=HY009 at
AACTSS.pl line 38
Uncaught exception from user code:
Connection failed with error: [IBM][CLI Driver] CLI0124E
Invalid argument value. SQLSTATE=HY009 at AACTSS.pl line 38.
at AACTSS.pl line 38
Brent
I'm no DB2 expert, but a quick google revealed that that error message
means that DB2 is not liking something about your $dsn. The first
thing I don't know is whether that database showed up in your list of
DB2 datasources. If it is showing up, try just passing the DataSource
Name in the $dsn portion of the connect string:
my $dsn = 'USNETAALDSN2';
my $dbh = DBI->connect("dbi:DB2:$dsn",$user,$pass) or die $DBI::errstr;
According to perldoc DBD::DB2, your format is correct for an
un-cataloged database. I'm wondering if the database name on the
OS/390 box is different from the alias that you have cataloged on your
local box, since this format uses the database name on the host, not
the DSN name that as it's cataloged on the client.
--
--------------------------------------------------------------------------------------------------------------
The darkest places in hell are reserved for those who maintain their
neutrality in times of moral crisis.
Dante Alighieri (1265 - 1321)
They who would give up an essential liberty for temporary security,
deserve neither liberty or security.
Benjamin Franklin
Our lives begin to end the day we become silent about things that matter.
Martin Luther King
The right of the people to be secure in their persons, houses, papers,
and effects, against unreasonable searches and seizures, shall not be
violated, and no warrants shall issue, but upon probable cause,
supported by oath or affirmation, and particularly describing the
place to be searched, and the persons or things to be seized.
Amendment IV to the Constitution of the United States
--------------------------------------------------------------------------------------------------------------
