Hi Jim, Thanks a lot for the information. -----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Fenner, Jim Sent: Monday, August 01, 2005 4:41 AM To: [email protected] Subject: Re: How can I convert ER diagram into SQL QUERY
Srinivas, (i) You must have database specialists who created these tables and designed their foreign keys, indexes, partitioning etc in the first place. See them for advice. If your organisation happens to possess a tool that would, as you request, "convert ER diagram into SQL QUERY", then they presumably are the experts in using that tool (ii) If you are using DB2 on a mainframe, you should in any case (whatever your job description) possess and absorb a copy of Craig Mullins "DB2 Developer's Guide 5th Edition' published by SAMS . If not, ... DISCLAIMER: This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
