PHP & os/390 question

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
rxsid
Forum Commoner
Posts: 82
Joined: Thu Aug 29, 2002 12:04 am

PHP & os/390 question

Post by rxsid »

Hi all,

I realize this may be a very obtuse question that perhaps no one out there has an answer to, but here goes....

Does anyone know how I could use PHP to establish a connection to a mainframe (os/390), then browse a VSAM file to look for a certain date range, extract those dates into an array, then close the connection.

I know how to issue an ftp function to actually download the VSAM file I need...however, this file is extremely large (which presents connection problems, etc).

Any ideas??

Thanks.
fractalvibes
Forum Contributor
Posts: 335
Joined: Thu Sep 26, 2002 6:14 pm
Location: Waco, Texas

Post by fractalvibes »

I feel your pain.... I'd suggest you post your question here:
http://groups.google.com/groups?hl=en&l ... es.ibm-db2

also, as it will probably take a certain amount of middle-ware. I tried a similar thing a couple of years ago, an ASP script calling a DB2 stored procedure written in COBOL running on the OS/390...turned out there were some os/390 memory management/task control block/etc. issues
that prevented this from being implemented, and IBM recommended against it strongly...I managed to completely bring down an entire DB2 subsytem (test, thank God!) and the server I was calling from.

So....they created processes to replicate data daily from VSAM to DB2,
used DB2 Connect and all is well, mostly.

No, I do not work for IBM, but developing ASP apps which must talk with DB2 has not always been an easy task!

Phil


I think with DB2 V 8 or perhaps 7.2, not sure!, there are some Data Integration products available now to access most anything; so try that DB2 list above - I think you will get some responses, and most likely from IBM DB2 people included.

Also - consider this a valuable site for DB2 info:

http://www7b.boulder.ibm.com/dmdd/
Post Reply