View previous topic :: View next topic
|
Author |
Message |
go4salu
New User
Joined: 12 Jan 2006 Posts: 11
|
|
|
|
Hi,
My requirement is to unload vsam and convert it into tabular form so that I could run sql queries on it. Basically, we are developing a tool in front-end wherein user will give the selection criteria and that tool will fetch the data. We have done it for DB2 and we want to replicate it to VSAM files.
It would be fairly easy if we could convert our vsam into some tabular structure in front end and then run the sql queries on the converted data. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
thanks for letting us know |
|
Back to top |
|
|
go4salu
New User
Joined: 12 Jan 2006 Posts: 11
|
|
|
|
Alriht, so is there a way to do this : "My requirement is to unload vsam and convert it into tabular form so that I could run sql queries on it." Is there a way or tool available ? |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Yes, it would probably be called an in-house program written by the people who wished to do these things. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
why in <heaven> don' t You convert/copy the vsam data to a db2 table
and proceed from there...
( obvious answer ) the reqirement is not to do it...
( obvious reply ) the requirement is stupid anyway, write a program to achieve the same query functionality |
|
Back to top |
|
|
|