Hi Reinhard, I really don't know why your blob's are splitted on OS/390 nor can I judge, if and when or where they need to get splitted. In my last firm, we did a project with db2/V6 on both winnt and OS390 and we did load blob's greater than 2 MB down from OS390 to clients on NT.
But I don't remember details. 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: Re: Antwort: Re: Antwort: Re: Antwort: Re: Antwort: Re: Antwort: 16.02.2004 11:13 DBD:: DB2 and bind ['securiQ.Watchdog': �berpr�ft] Hi Manfred, Manfred Beilfuss wrote: > Hi Reinhard, > > last week I've been away from office, therefore I didn't answer your email > up til now. I know it, it is no problem for me. > > > 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. And I am also be able to connect to DB2 on OS/390 from windows in practice. The only you have todo is to install "DB2 Connect" and configure it correctly, on the Windows site. What happens on DB2 on OS/390 is the work of our Host admins, I guess. :-) > > > 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. > We are using here DB2 V6.1 and V7. I allready connected with DBD::DB2 to our OS/390 database in the past, and it is similar the same as I do it to an DB2 on AIX or Windows. The only difference is with the BLOB's. On Windows they are not "splitted" as on OS/390 if the data stored is larger than 2MB, isn't it? So what have I done is to query to all blob's with the same ID and than I merged the BLOB parts. And if I load the file physically to my harddisk there is no error with it. So I can say the problem was solved. The only what I want to know is if there is a DB2 query which can do the work, so I have not to do it manually in my Perl script. You know what I mean? Thank you for your answer, Reinhard > 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 -- QA ISIS Information Systems Austria tel: (+43) 2236 27551 150 Fax: 2236 21081 Visit our web site http://www.isis-papyrus.com
