Hello Manfred, [EMAIL PROTECTED] wrote:
> Hello, > > as I understand DBI::DB2 it is for use with SQL-Statements and not for use > with external utilities like bind is one! I do not agree, because I can also use the bind statement in my DB2 Command Window. I have only to write: bind q:\test\pputdb.bnd isolation cs qualifier ISIS and execute it. And the funny thing is if I put the statement into single ticks like 'bind ...' it works with the DBD::DB2 driver. > > > You might want to generate your bind-Statements using DBI::DB2! > But to execute them you should invoke any kind of external OS-Shell ( e.g. > system() ) and process your bind-Statements inclusive any needed At this time I do so, I use "db2cmd" for it, but the problem is that I have to use a sleep(), because often the connection is very slow and perl does not wait for the if the db2cmd was finished, because I pass multible system commands to db2cmd. > > db2-Command-line-interfaces on your respective operating system. > > Mit freundlichen Gruessen / Best regards > > Manfred Beilfuss > > 60329 Frankfurt mit freundlichen Gr��en, with my best regards, Reinhard P.S: Greetings from Austria :-) > > > Reinhard Pagitsch > <[EMAIL PROTECTED] An: [EMAIL PROTECTED] > pyrus.com> Kopie: > Thema: DBD::DB2 and bind > 04.02.2004 13:21 > > > > Hello, > > Have someone of you expirence with DBD::DB2? I want to pass a bind > statement > to my DB2 on NT, but everytime I get error messages: > DBD::DB2::st execute failed: [IBM][CLI Driver][DB2/NT] SQL0007N The > character " > \" following "bind Q:" is not valid. SQLSTATE=42601 > DBD::DB2::st execute failed: [IBM][CLI Driver][DB2/NT] SQL0007N The > character " > \" following "bind Q:" is not valid. SQLSTATE=42601 > > I want to pass the following statement: > bind q:\test\pputdb.bnd isolation cs qualifier ISIS > > If I use it without a path then DBI nags the point in pputdb.bnd. > I tryed it the line with \\ and / but nothin helps. > Only if I put the statement into a variable with single ticks it works: > like $var = 'bind q:\test\pputdb.bnd isolation cs qualifier ISIS'; > > Can someone help me? > > Thank you, > Reinhard
