MVSFORUMS.com

ramu_mohan21 · Posted: Mon Apr 09, 2007 7:02 am Post subject: Usage of DB2 Connect and WinSQL

HI Board,
Our mainframes System have been divided into 3 parts. 1) Normal Mainframes (Back-end) 2) Front End(Consisting of VB) 3) UNISYS Mainframes. All three systems will interact through messaging.

In Front End System my client will enter SQLs in WinSQL tool to get the data and to delete the data. Accordingly in the back-end DB2 tables will respond. Sometime back we asked our client that how does it happen? We have been told that we need to have DB2 connect in our system.

Here my questions is:
(1)
Whatever the SQLs written in WinSQL(In Front end) will be transferred to Back-end mainframes through DB2 connect and deletes the Z/OS version of DB2?

(or)

WinSQL ONLY interacts the Front-End DB2 tables(I.e DB2 for Windows) and sends the message to Back-end to reflect the same?

(2) Can we get/update the data of the Mainframes DB2 version through front-end(Without calling any Stored Procedues. Do we have any tools like QMF/SPUFI)?

Please clarify.
_________________
Best Regards,
----------------
Rammohan Pabba
Software Engineer

kolusu · Posted: Mon Apr 09, 2007 7:53 am Post subject:

ramu_mohan21 · Posted: Tue Apr 17, 2007 8:59 am Post subject:

Thanks Kolusu for your clarification.
_________________
Best Regards,
----------------
Rammohan Pabba
Software Engineer