Re: Antwort: Re: Antwort: Re: Antwort: DBD::DB2 and bind ['securiQ.Watchdog': Qberpr=FCft=5D?=
From: Reinhard Pagitsch (reinhard.pagitsch_at_isis-papyrus.com)
Date: 02/04/04
- Next message: Michael Cesar: "HELP PLEASE! Problems using returning a cursor to DBI & DBD::Oracle using Stored Procedures"
- Previous message: Manfred Beilfuss: "Antwort: Re: Antwort: Re: Antwort: Re: Antwort: DBD::DB2 and bind ['securiQ.Watchdog': Qberpr=FCft]?="
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Wed, 04 Feb 2004 17:01:33 +0100 To: Manfred.Beilfuss@dvag.com
Hello Manfred,
I just tryed the bind again and it seems to me that the bind statement is not
supported by DBD::DB2 because now I get allways an error message about the
bind or Q:\ . But I am realy confused why I did not got an error message
some days before if I used it? Maybe my perl was a little confused?
I will give up and use my system command again.
regards and thank you for your help, I understand now a little bit more about DBI,
Reinhard, sighing
P.S: I will keep your SELECT statement in mind for further use.
Manfred.Beilfuss@dvag.com wrote:
> Hello Reinhard,
>
> you could submit e.g. "Select * from SYSCAT.PACKAGES order by
> last_bind_time desc fetch first 20 rows only" which will show you the last
> 20 packages bound against the database you are connected to.
> See the attached example from one of my database's where I did run a
> db2look against to get some ddl from it.
> If you run your normal bind-utility from the db2-command-line you will see
> with the above mentioned statement what the name of your package is. It's
> sometimes a very cryptical name.
> Then you can do your single one.tick.perl.script and again my sql. If you
> have a different last_bind_time it really did work.
>
> (See attached file: package.txt)
>
> Mfg
> Manfred
>
>
> Reinhard Pagitsch
> <reinhard.pagitsch@isis-pa An: Manfred.Beilfuss@dvag.com
> pyrus.com> Kopie: dbi-users@perl.org
> Thema: Re: Antwort: Re: Antwort: DBD::DB2 and bind
> 04.02.2004 16:23
>
>
>
> Hello Manfred,
>
> Manfred.Beilfuss@dvag.com wrote:
>
> > Hello Reinhard,
> >
> > it is interesting to hear that bind does work in single ticks.
> >
> > Being a db2-dba and a perl-beginner I would never have tried to do that.
> >
> > As far as I understand the development of db2-related
> > client-server-software I really doubt that it really works.
>
> Maybe that it not realy works, I only tryed it and did not got a DBI error
> message. So I thought it would work, but I did not checked what happens in
> the database.
>
> >
> >
> > Bind is a very db2-specific-utility that doesn't exist on other DB-Server
> > like oracle, ms-sql or sybase.
>
> Sure, you are right, I know that.
>
> >
> >
> > Therefore alone I doubt that standard dbi and dbd::db2 support it.
> >
> > If it would, there would be a note in the description of dbd::db2 in the
> > actual programming with perl dbi ( I just checked the german version !)
> All
> > it talks about is data-definition and data-manipulation-statements. Here
> > they talk about binding of ( external or host- ) Parameter to your
> > perl/sql-statements. Don't mix this. It is something different.
>
> No I will not mix it, I understand, or belive that I understand it, the
> differences.
>
> >
> >
> > It may be possible that there is one or more specific dbi- or dbix-Module
> > supporting the way of using the bind-utility you are heading for.
>
> I use Activestate Perl v5.6.1 MSWin32-x86-multi-thread, DBI version 1.35
> and
> DBD version 0.76.
>
> >
> >
> > DB2-Bind-Uitility needs the bind-file to transport the executable-part
> of
> > the client-sql-statements to the db2-server. This concept is not there in
> > the other dbms or done somehow inline the
> > software-(-pre-)compilation-process on the client-side. If it is
> > unnecessary when using sql-procedure-language I just did not know
> already.
> > Here your "q:\test\pputdb.bnd" points to a path on your client machine,
> > which must not be identical on your server. Any sql-statement you call
> gets
> > executed on the server and not on the client. How to find your bind-file
> > there?
>
> I do not realy know what the pputdb.bnd contains. We are developing
> programs
> with which you can insert AFP or PDF documents to DB2, Oracle, Sybase,
> MSSQL Server database,
> and get them also back, f.e. in a web browser.
> For DB2 I need the pputdb.bnd file to get not a "time stamp conflict" error
> message if I
> insert the documents.
>
> >
> >
> > To really understand what you are doing, I need to know more about your
> > environment.
>
> Please tell me what you want to know, and I will try to explain it.
>
> >
> > If binding is successful you must find updates in your syspackages-table
> > with a correlating timestamp.
>
> Please can you tell me in which tables I shall look for that? So I will
> write
> a smal script to use the bind command via DBD::DB2 with the single ticks,
> and look
> in them.
>
> I have to say I am not a DB2 expert, I can only use it.
>
> >
> >
> > Mit freundlichen Gruessen / Best regards
> > >From Germany to Austria
> > 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:Manfred.Beilfuss@dvag.com
> >
> >
> > Reinhard Pagitsch
> > <reinhard.pagitsch@isis-pa An:
> Manfred.Beilfuss@dvag.com
> > pyrus.com> Kopie:
> dbi-users@perl.org
> > Thema: Re:
> Antwort: DBD::DB2 and bind
> > 04.02.2004 14:11
> >
> >
> >
> > Hello Manfred,
> >
> > Manfred.Beilfuss@dvag.com 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
> > > <reinhard.pagitsch@isis-pa An:
> > dbi-users@perl.org
> > > 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
>
> mit freundlichen Grüßen,
> with my best regards,
> Reinhard
>
> --
> QA
> ISIS Information Systems
> Austria tel: (+43) 2236 27551 150 Fax: 2236 21081
> Visit our web site http://www.isis-papyrus.com
>
> ------------------------------------------------------------------------
> Name: package.txt
> package.txt Type: Plain Text (text/plain)
> Encoding: base64
- Next message: Michael Cesar: "HELP PLEASE! Problems using returning a cursor to DBI & DBD::Oracle using Stored Procedures"
- Previous message: Manfred Beilfuss: "Antwort: Re: Antwort: Re: Antwort: Re: Antwort: DBD::DB2 and bind ['securiQ.Watchdog': Qberpr=FCft]?="
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
