Hello,

as I understand DBI::DB2 it is for use with SQL-Statements and not for use
with external utilities like bind is one!

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
db2-Command-line-interfaces on your respective operating system.

Mit freundlichen Gruessen / Best regards

Manfred Beilfuss

Deutsche Verm�gensberatung AG
IT_Systemmanagement , DBA
M�nchenerstr. 1
60329 Frankfurt
Tel.: +49 (69) 2384 - 639
Fax: +49 (69) 2384 - 329
Mailto:[EMAIL PROTECTED]


                                                                                       
                                        
                    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









Reply via email to