Hi Reinhard,
last week I've been away from office, therefore I didn't answer your email
up til now.
I really doubt being able to help a lot with your actual question.
Theoretical you should be able to work from windows against DB2 on all
different platforms in the same way.
But talking about DB2/390 it depends a lot on which version's are
installed, on the various steps you go through your architecture. Beginning
with the win-client, the connect-gateway, the communication-protocol's used
on the way, and last but least the version's of the used host-software,
e.g. DDF / TCP/IP-Stack/ OS/390 or z/OS and finally DB2 and how everything
fit's together.
Just to repeat it again,
if you have the most recent package's with applicable fixpak's and
everything composed ( bind and so on ) neatly together,
you should be able to work the same way as in a windows-only environment.
But that is not the simplest thing to reach, and must be accomplished by
the people ( system + db-admin's ) in charge at your shop.
On OS/390 it may as well be a matter of additonal license fee's for one or
more of the needed components, that you don't need anywhere else.
If have done it, already with DB2/v6 on OS/390 starting to try to get it in
DB2/V4.9 ! Actually we ( new firm now) have DB2/V7 on OS390 and I don`t
know if I could do it here as I'am not working on DB2/390 here.
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: [EMAIL PROTECTED]
Thema: Re: Antwort: Re:
Antwort: Re: Antwort: Re: Antwort: DBD::DB2 and
09.02.2004 14:56 bind ['securiQ.Watchdog':
überprüft]
Hello Manfred,
I have an additional question about the content of a BLOB of a DB2 database
on MVS,
maybe you can help me again.
If I make a select statement to a BLOB on a Windows DB2 database I get the
whole
BLOB content. But if I do the same against a DB2 on MVS than I one or more
BLOB's
for one ID (in my case PERM_ID), depending on the size of the BLOB.
Ok, but how can I now "download" these two BLOB's to my file system? Is
there a way to do it
with SELECT statement, like SELECT content from table sum(ID). Or have I
look in the result how many
rows I found an than I have to concatenate both? And how do I know which is
the first, the secound....?
Because I use the wrong order the result will be corupted.
Thank you,
Reinhard
[EMAIL PROTECTED] wrote:
> Hi Reinhard,
>
> it's nice being of help sometimes. ;-}
> 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:
[EMAIL PROTECTED]
> Thema: Re:
Antwort: Re: Antwort: Re: Antwort: DBD::DB2 and bind
> 04.02.2004 17:01
['securiQ.Watchdog': überprüft]
>
>
>
>
> 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.
>
> [EMAIL PROTECTED] 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
> > <[EMAIL PROTECTED] An:
> [EMAIL PROTECTED]
> > pyrus.com> Kopie:
> [EMAIL PROTECTED]
> > Thema: Re:
> Antwort: Re: Antwort: DBD::DB2 and bind
> > 04.02.2004 16:23
> >
> >
> >
> > Hello Manfred,
> >
> > [EMAIL PROTECTED] 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:[EMAIL PROTECTED]
> > >
> > >
> > > Reinhard Pagitsch
> > > <[EMAIL PROTECTED] An:
> > [EMAIL PROTECTED]
> > > pyrus.com> Kopie:
> > [EMAIL PROTECTED]
> > > Thema: Re:
> > Antwort: DBD::DB2 and bind
> > > 04.02.2004 14:11
> > >
> > >
> > >
> > > 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
> >
> > 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
