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.
PHP & os/390 question
Moderator: General Moderators
-
fractalvibes
- Forum Contributor
- Posts: 335
- Joined: Thu Sep 26, 2002 6:14 pm
- Location: Waco, Texas
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/
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/